Tag asset:filterassetsbydate Tag Excludes Assets With Today As Start Date Due to The Use of Milliseconds (Doc ID 2004428.1)

Last updated on AUGUST 21, 2023

Applies to:

Symptoms

On : 11.1.1.8.0 version, WebCenter Sites

When attempting to use <asset:filterassetsbydate> tag and only date is passed (without time), the following error occurs.

ERROR
-----------------------
The tag adds the timestamp as 00:00:00.000 and then attempts to filter assets. This filters out assets that have the same date but non-null timestamp.

Sample Test Case
-----------------------
1. In avisports site, create an AVIImage asset with id <id>, set the startdate to 2015-03-23 00:00:00, and set enddate to 2015-03-30 00:00:00 and save.

2. Check the AVIImage table, and see the startdate value for the asset is 2015-03-23 00:00:00.636.

3. Implement a CSElement named "testAssetFiltering" with the following logic: (assettype and assetid are hardcoded for testing purposes)

4. Create a SiteEntry named "testAssetFiltering" for the CSElement created in step 3.

5. Hit the testAssetFiltering page - http://hostname:port/cs/ContentServer?d=&pagename=testAssetFiltering - and do not see AVIImage:<id> returned.

Changes

In futuretense.ini: cs.sitepreview=contentmanagement

This allows the tag to filter assets based on the input date parameter value.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.