Hello! I need an HQL query that does the following:
Last modified date should be less than 15 days from today
This is what I've tried:
#set($sql = ", BaseObject as obj, $proptype as prop where
obj.className='${ISDclassname}' and obj.id=prop.id.id and
prop.name='${viewby}' and doc.fullName=obj.name and
doc.fullName!='${ISDclasstemplate}' and ($xwiki.getDate() -
doc.contentUpdateDate) < 15 order by prop.value")
But I'm getting an error on the and ($xwiki.getDate() -
doc.contentUpdateDate) < 15 statement. What should I write instead?
Mary Ellen Coleman