Hi,
I have a single type field that can contain zero or more values (comma
separated values). This field stores some sort of access value.
In the filter, I am given a list of allowed values for the field and a
document must be considered if all values contained in its field must be
present in the allowed values specified in the filter.
How can i write filter query for this?
To illustrate this further:
If a field "field1" in a document contains (a1, a3, a5) values.
1. Case #1) If the allowed values specified in the filter are (a1, a3,
a4, a6) --> the document should not be considered since user doesn’t have
access to “a5”.
2. Case #2) If the allowed values specified in the filter are (a2, a4,
a6) --> the document should not be considered since user doesn’t have
access to “a1, a3, a5”.
3. Case #3) If the allowed values specified in the filter are (a1, a3,
a5) --> the document should be considered since user has access to all
values of the field.
4. Case #4) If the allowed values specified in the filter are (a1, a2,
a3, a4, a5, a6) --> the document should be considered since user has access
to all values of the field (and some more values also).
Thanks,
Vasu
|