Filter Expressions in the Main API (2017/01)

9min

this page / section pertains to brightsign network (often abbreviated bsn ), our legacy cloud platform our latest cloud platform is bsn cloud which consists of the free bsn control tier and the paid bsn content tier development of bsn has largely ceased and the platform will eventually be deprecated and replaced with bsn cloud filter expressions get calls that return multiple items accept the "?filter" query string, which allows the client to filter list returns according to one or more entity values the query string can have multiple operators joined together with "and" or "or" example (single operator) get /2017/01/rest/content/?filter=\[mediatype]%20is%20'video' example (multiple operators) get /2017/01/rest/content/?filter=\[filename]%20begins%20with%20'ex'%20and%20\[mediatype]%20is%20'image' accepted expressions are described below string operators string operators are case insensitive \[entry] is '\<value>' returns items that contain the entry equalling \<value> this operation supports the " " and "?" wildcards \[entry] is not '\<value>' returns items that do not contain the entry equalling \<value> this operation supports the " " and "?" wildcards \[entry] begins with '\<value>' returns items that contain the entry starting with the \<value> substring \[entry] ends with '\<value>' returns items that contain the entry ending with the \<value> substring \[entry] contains '\<value>' returns items that contain the entry with the \<value> substring \[entry] does not contain '\<value>' returns items that do not contain the entry with the substring" \[entry] contains all ('\<value 1>', '\<value 2>', \[ ]) returns items that contain the entry with all of the specified substrings \[entry] contains any ('\<value 1>', '\<value 2>', \[ ]) returns items that contain the entry with any of the specified substrings \[entry] is in ('\<value 1>', '\<value 2>', \[ ]) returns items that contain the entry equalling any of the specified values \[entry] is not in ('\<value 1>', '\<value 2>', \[ ]) returns items that do not contain the entry equalling any of the specified values enumeration operators some string value entries are enumerations for example, the \[mediatype] entry on the content endpoint can only have "video", "image", "audio", "text", and "other" values the following operators can be used with enumeration entries \[entry] is '\<value>' returns items that contain the entry equalling \<value> \[entry] is not '\<value>' returns items that do not contain the entry equalling \<value> \[entry] is in ('\<value 1>', '\<value 2>', \[ ]) returns items that contain the entry equalling any of the specified values \[entry] is not in ('\<value 1>', '\<value 2>', \[ ]) returns items that do not contain the entry equalling any of the specified values number operators \[entry] is \<value> returns items that contain the entry equalling \<value> \[entry] is not \<value> returns items that do not contain the entry equalling \<value> \[entry] is greater than \<value> returns items that contain the entry with a value greater than \<value> \[entry] is less than \<value> returns items that contain the entry with a value less than \<value> \[entry] is in the range \<value> and \<value> returns items that contain the entry with a value between the specified range \[entry] is not in the range \<value> and \<value> returns items that do not contain the entry with a value between the specified range \[entry] is in (\<value 1>, \<value 2>, \[ ]) returns items that contain the entry equalling any of the specified values \[entry] is not in (\<value 1>, \<value 2>, \[ ]) returns items that do not contain the entry equalling any of the specified values gps location (\[latittude entry] and \[longitude entry]) in (\<latitude value>, \<longitude value>, \<distance value>) returns items that have coordinate entries within \<distance value> of the specified \<latitude value> and \<longitude value> gps location (\[latittude entity] and \[longitude entity]) not in (\<latitude value>, \<longitude value>, \<distance value>) returns items that do not have coordinate entries within \<distance value> of the specified \<latitude value> and \<longitude value> datetime operators datetime values are formatted as yyyy mm ddthh\ mm\ ss sssz \[entry] is '\<datetime>' returns items that contain the entry equalling \<datetime> \[entry] is not '\<datetime>' returns items that do not contain the entry equalling \<datetime> \[entry] is after '\<datetime>' returns items that contain the entry with a time before \<datetime> \[entry] is before '\<datetime>' returns items that contain the entry with a time after \<datetime> \[entry] in the last (\<units>, \<length>, '\<datetime>') returns items that have a time entry within \<length> before \<datetime> the time \<length> is quantified with the \<units> parameter, which can have one of the following values years , months , days \[entry] not in the last (\<units>, \<length>, '\<datetime>') returns items that do not have a time entry within \<length> before \<datetime> the time \<length> is quantified with the \<units> parameter, which can have one of the following values years , months , days \[entry] is in the range '\<datetime>' and '\<datetime>' returns items that have a time entry that falls between the two \<datetime> values \[entry] is not in the range '\<datetime>' and '\<datetime>' returns items that do not have a time entry that falls between the two \<datetime> values \[entry] is in ('\<datetime 1>', '\<datetime 2>', \[ ]) returns items that contain the entry equalling any of the specified values \[entry] is not in ('\<datetime 1>', '\<datetime 2>', \[ ]) returns items that do not contain the entry equalling any of the specified values boolean operators \[entity] is true returns items that contain the entry equalling a true value \[entity] is false returns items that contain the entry equalling a false value