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 _______________________________________________ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users