We are trying to limit the items in contentlist by updating JCR query such as
select rx:sys_contentid, rx:sys_folderid from rx:XXX where jcr:path like ‘//Sites/YYYSite%’ and rx:sys_pubdate < sysdate
Is there any reason why this may not be working ?
All,
Looks like JCR 1.o does not support sysdate in where clause. Got around this issue by writing a custom Java Extension (extend com.services.filter.IPSItemFilterRule) and adding it to Public Filter List. That worked out great.