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 <[email protected]>:
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-tp75816... Sent from the XWiki- Users mailing list archive at Nabble.com. _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users