[xwiki-devs] Query XObject two property values
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). 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 -- Ricardo Rodríguez CTO eBioTIC. Life Sciences, Data Modeling and Information Management Systems
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
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
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#HGetti... 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
Hi, Marius Dumitru Florea wrote:
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#HGetti...
Does it help? Marius
It helped a lot. Sorry for being late with this reply. What it still difficult to understand for me is how http://platform.xwiki.org/xwiki/bin/view/DevGuide/velocityHqlExamples#HNon-e... can be completed as, for the best of my knowledge, this is a key point for people using, let's say, VTL to design templates.
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
-- Ricardo Rodríguez CTO eBioTIC. Life Sciences, Data Modeling and Information Management Systems
participants (2)
-
[Ricardo Rodriguez] eBioTIC. -
Marius Dumitru Florea