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? > > 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
