6 Mar
2009
6 Mar
'09
4:18 p.m.
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