22 Oct
2010
22 Oct
'10
7:19 a.m.
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