JCR Query to return a List of Assembly Items filtered by sysdate

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 ?


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.