Sorry that's right, it's not mapped as a list but as a comma separated string.
Your approach with 'like' should work but you miss the % :

obj.tMembers like '%${usedUser}%'



2012/10/8 Eugen Colesnicov <ecolesni...@gmail.com>:
> Hello!
> I need help with xwql quering.
>
> I have my own class with property tMembers with type="user list" also this
> property is a multi-select.
> How is possible to query all docs of this class with filter for some user?
>
> If no multiselect - all is easy:
> #set($xwlquery="from doc.object($class) as obj where doc.fullName <>
> '$template' and obj.tStatus='2' and obj.tMembers='$usedUser' order by
> doc.date desc")
>
> If multiselect switched on, but only one user selected - also this query
> working. But, when used multiselect (selected 2 users) this query not
> working.
>
> Also I tryed - obj.tMembers like '$usedUser' and - obj.tMembers.content like
> '$usedUser' - no result.
>
> --
> Thanks beforehand!
> Eugen Colesnicov
>
>
>
> --
> View this message in context: 
> http://xwiki.475771.n2.nabble.com/multi-select-property-xwql-quering-tp7581692.html
> Sent from the XWiki- Users mailing list archive at Nabble.com.
> _______________________________________________
> users mailing list
> users@xwiki.org
> http://lists.xwiki.org/mailman/listinfo/users
_______________________________________________
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users

Reply via email to