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'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 > > -- Ricardo RodrÃguez CTO eBioTIC. Life Sciences, Data Modeling and Information Management Systems _______________________________________________ devs mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/devs
