Selecting subset data from complex collection
We have the User's data with complex collection storing various groups the user has access to :
-Groups (Complex Type(Collection))
-- GroupID (int)
-- Tags (Collection)
-- GroupName (String)
What we want to select is UserID, GroupName & Tags matching the GroupID passed.
SerchParameter.Filter = "UserID=1 and GroupID in (2,4)"
SerchParameter.FilterFields = "UserID, Groups" .. FilterFields is something new different form SearchParameter.Fields