Box Status

Metadata query for superset values of multiSelect field

Follow
New post
Alex Talis

I have a metadata template with a multiSelect field. I would like to use the metadata query API to find all entries where the value of this field is a superset of the specified set of options. I have tried using the '>=' and 'IN' operators, but neither seems to work.

Let's say my options are a,b,c,d,e. If I send a query like this:

"query": "myField >= :myField"
"query_params": {

        "myField": [

            "a", "b"

        ]

    }

 

I am trying to find all entries where myField contains "a" and "b", even if it contains other options that I have not specified.

A file where myField=['a',b','c'] should be included because it contains both "a" and "b"

A file where myField=['a', 'c'] should not be included because it is missing "b".

Is this type of metadata query supported or do I need to use the Search API instead of the Metadata Query API?

0

Comments

1 comment

Date Votes
  • Alex Novotny

    Hello, 

    Unfortunately this functionality doesn't exist at this time. It is a strict match. So, if myField=['a',b','c'] should be included, you'd have to include "a" "b" and "c" in the query. 

    The team is actively working on enhancements. 

    0
    Comment actions Permalink

Post is closed for comments.