14 Oct
2010
14 Oct
'10
11:43 a.m.
On 10/14/2010 11:18 AM, [Ricardo Rodriguez] eBioTIC. wrote:
Marius Dumitru Florea wrote:
I put a second example on
http://platform.xwiki.org/xwiki/bin/view/DevGuide/velocityHqlExamples#HGett…
Does it help?
Marius
Hi Ricardo,
On 10/14/2010 12:40 AM, [Ricardo Rodriguez] eBioTIC. wrote:
Yes. Thanks. 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
devs(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/devs