On 10/14/2010 11:18 AM, [Ricardo Rodriguez] eBioTIC. wrote: > > > Marius Dumitru Florea wrote: >> Hi Ricardo, >> >> On 10/14/2010 12:40 AM, [Ricardo Rodriguez] eBioTIC. wrote: >> >>> Hi! >>> >>> Following http://platform.xwiki.org/xwiki/bin/view/DevGuide/QueryGuide >>> and a lot of help from people on this list, I got working this query: >>> >>> #set($query = ", BaseObject as obj, StringProperty as prop where >>> doc.fullName = obj.name and obj.className='Users.PdrUserClass' and >>> obj.id=prop.id.id and prop.id.name='Type' and (prop.value like '" + >>> $usertypeOne + "' or prop.value like '" + $usertypeTwo + "') order by >>> doc.fullName asc") >>> >>> >> >> >>> I do need to add now another criteria with an *AND* operator querying a >>> different property (Withdrawal) of the same class (User.PdrUserClass). >>> >> >> Is Withdrawal a StringProperty too? >> > > Yes. Thanks.
I put a second example on http://platform.xwiki.org/xwiki/bin/view/DevGuide/velocityHqlExamples#HGettingdocumentswhereobjects27propertiesequalssomevalue Does it help? Marius >> >>> I'm miserably failing to construct this query; some of my attempts lead >>> MySQL to eat 99% of the processor time use. >>> >>> Please, could you help me with this query? Thanks! >>> >>> Ricardo >>> >>> >> _______________________________________________ >> devs mailing list >> [email protected] >> http://lists.xwiki.org/mailman/listinfo/devs >> >> > _______________________________________________ devs mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/devs
