TS Search Date Issue

VAIBHAV

Hi,

I have a requirement where I want to search a content that is getting expired using CSSDK Search API.

Problem faced:
OOTB search is giving results but not getting results using CSSDK Search API for the custom date EA.

I have the expire date set in field mapping as below:
fieldName : TeamSite/Metadata/Expire_Date
fieldType : date
formatString : yyyy-MM-dd
fieldStorage : CustomDate1


I can see that OOTB search converts the date to time when executing the query:
name : TeamSite/Metadata/Expire_Date
value : ![CDATA[1361989800000]]

In my java class I am also converting the string date (from calendar) to time using java date utils:
SimpleDateFormat sdf = new SimpleDateFormat();
sdf.applyPattern("yyyy-mm-dd");
Date fromDateConstraint = sdf.parse(fromDate);

and using in search query as below:
....
new CSFieldConstraint(EXPIRY_DATE.toString(),
CSOperator.GREATER_THAN, fromDateConstraint)
where EXPIRY_DATE is : TeamSite/Metadata/Expire_Date

I tried below too and passed it in search query:
long toTime = ((Date) fromDateConstraint).getTime();
value = new Long(toTime);


I can see that the time for same date the OOTB search is using and the one that I am getting after converting the same date is different.

Any pointers would be appreciated. Do let me know if anything else is needed from end.

Thanks,
Vaibhav

Rick Poulin

SimpleDateFormat sdf = new SimpleDateFormat(); sdf.applyPattern("yyyy-mm-dd"); Date fromDateConstraint = sdf.parse(fromDate);

Is this a typo? mm is minutes, you want MM.

I can see that the time for same date the OOTB search is using and the one that I am getting after converting the same date is different.

Assuming the above was a typo, this is the first thing to resolve. By what amount are the numbers different? You may not be accounting for time zone info on both sides, or perhaps not in the same way.