Hi! Eugen Colesnicov wrote:
Hi! Maybe somebody can help me.
I need to select some docs with own class. Together I need 3 filters: 1) by class: only "myclass" 2) by property value: where "myproperty" = "myvalue" 3) by date: where doc date = current date - 5 days I created xwql script with 2 creterias and it's working well:
select obj.name from Document doc, doc.object(mySpace.myClass) as obj where obj.myProperty like 'myValue' order by obj.name
How need to add one more criteria by date?
This query is working fine in a XE 1.3.8295 installation, but I'm using HQL though. #set($query = ", BaseObject as obj, StringProperty as type, StringProperty as withdrawal where doc.fullName = obj.name and obj.className='Users.PdrUserClass' and obj.id=type.id.id and type.id.name='Type' and obj.id=withdrawal.id.id and withdrawal.id.name='Withdrawal' and (type.value like '%lonxa%' or type.value like '%xest%') and withdrawal.value ='non' and year(doc.date) = '2010' order by doc.fullName asc") HTH, Ricardo -- Ricardo RodrÃguez CTO eBioTIC. Life Sciences, Data Modeling and Information Management Systems