...
Filtering and Sorting Expressions
This example describes the player entity, but the same solution is implemented for all other entities (for example, groups, feeds, playlists, etc.).
Example
The BSN.cloud Main API currently exposes the following player management methods which accept optional filter and sort expressions:
GET
...
~/
...
{{version}}/REST/Devices/[?marker={string}][&pageSize={byte}][&filter={expression}][&sort={expression}]
which retrieves the paged list including up to 100 '
...
Device' instances starting from specified marker, matching the specified filter expression and sorted in accordance to specified sort expression.
GET
...
~/
...
{{version}}/REST/Devices/Regions/{*locationPath}/[?filter={expression}]
which retrieves the list of '
...
DevicesRegion' providing the aggregated information of locations of '
...
Device' instances matching the specified location path and filter expression.
GET
...
~/
...
{{version}}/REST/Devices/Count/[?filter={expression}]
which retrieves the number of '
...
Device' instances matching the specified filter expression.
PATCH
...
~/
...
{{version}}/REST/Devices/[?filter={expression}]
(in development) which applies the specified changes to '
...
Device' instances matching the specified filter expression.
DELETE
...
~/
...
{{version}}/REST/Devices/[?filter={expression}]
which deletes the '
...
Device' instances matching the specified filter expression.
...
| borderColor | #3D3D3D |
|---|---|
| bgColor | #F4F4F4 |
| titleColor | #3D3D3D |
| borderWidth | 0 |
| titleBGColor | #3D3D3D |
| borderStyle | solid |
ON THIS PAGE
...
Filter Expression Criteria
Each filter expression may contain one or more criteria combined by AND/OR operators and optionally grouped by parentheses.
Each criteria may be based on property name, system tag, or custom tag.
All property names are based on data contract of the target Main API
...
version
...
According to initial business requirements the Main API must support filtering and sorting by all properties exposed in its data contracts. But due to syntax specifics the list of supported 'Player' entity properties in v2020/10 is currently limited to the following, as defined in 'BSN.WebServices.Main.v202010.DTO.Device' and referenced classes:
[Id] // integer
[Serial] // string
[Model] // string-enumeration
[Family] // string-enumeration
[RegistrationDate] // DateTime
[LastModifiedDate] // DateTime
[Settings] // object
[Settings].[Name] // string
[Settings].[Description] // string
[Settings].[ConcatUnitNameAndSerial] // boolean
[Settings].[SetupType] // string-enumeration
[Settings].[Group] // object
[Settings].[Group].[Id] // integer
[Settings].[Group].[Name] // string
[Settings].[BrightWall] // object
[Settings].[BrightWall].[Id] // integer
[Settings].[BrightWall].[Name] // string
[Settings].[BrightWall].[Screen] // byte
[Settings].[Timezone] // string
[Settings].[Screen] // object
[Settings].[Screen].[IdleColor] // string
[Settings].[Screen].[SplashUrl] // string-URL
[Settings].[Synchronization].[Status] // object
[Settings].[Synchronization].[Status].[Period] // TimeSpan
[Settings].[Synchronization].[Settings] // object
[Settings].[Synchronization].[Settings].[Period] // TimeSpan
[Settings].[Synchronization].[Schedule] // object
[Settings].[Synchronization].[Schedule].[Period] // TimeSpan
[Settings].[Synchronization].[Content] // object
[Settings].[Synchronization].[Content].[Start] // nullable TimeSpan
[Settings].[Synchronization].[Content].[End] // nullable TimeSpan
[Settings].[Network] // object
[Settings].[Network].[Hostname] // string
[Settings].[Network].[ProxyServer] // string
[Settings].[Network].[ProxyBypass] // string array
[Settings].[Network].[TimeServers] // string array
[Settings].[Network].[Interfaces] // object array
[Settings].[Beacons] // object array
[Settings].[Location] // object
[Settings].[Location].[PlaceId] // string
[Settings].[Location].[GPSLatitude] // nullable double
[Settings].[Location].[GPSLongitude] // nullable double
[Settings].[Location].[Country] // string
[Settings].[Location].[CountryLongName] // string
[Settings].[Location].[AdminAreaLevel1] // string
[Settings].[Location].[AdminAreaLevel1LongName] // string
[Settings].[Location].[AdminAreaLevel2] // string
[Settings].[Location].[AdminAreaLevel2LongName] // string
[Settings].[Location].[Locality] // string
[Settings].[Location].[LocalityLongName] // string
[Settings].[Location].[Path] // string
[Settings].[Location].[PathLongName] // string
[Settings].[Screenshots] // object
[Settings].[Screenshots].[Interval] // TimeSpan
[Settings].[Screenshots].[CountLimit] // unsigned short
[Settings].[Screenshots].[Quality] // byte
[Settings].[Screenshots].[Orientation] // string-enumeration
[Settings].[Logging] // object
[Settings].[Logging].[EnableDiagnosticLog] // boolean
[Settings].[Logging].[EnableEventLog] // boolean
[Settings].[Logging].[EnablePlaybackLog] // boolean
[Settings].[Logging].[EnableStateLog] // boolean
[Settings].[Logging].[EnableVariableLog] // boolean
[Settings].[Logging].[UploadAtBoot] // boolean
[Settings].[Logging].[UploadTime] // nullable TimeSpan
[Settings].[LWS] // object
[Settings].[LWS].[UserName] // string
[Settings].[LWS].[Password] // string
[Settings].[LWS].[EnableUpdateNotifications] // boolean
[Settings].[LDWS] // object
[Settings].[LDWS].[Password] // string
[Settings].[LastModifiedDate] // DateTime
[Status] // object
[Status].[Group] // object
[Status].[Group].[Id] // integer
[Status].[Group].[Name] // string
[Status].[BrightWall] // object
[Status].[BrightWall].[Id] // integer
[Status].[BrightWall].[Name] // string
[Status].[BrightWall].[Screen] // byte
[Status].[Presentation] // object
[Status].[Presentation].[Id] // integer
[Status].[Presentation].[Name] // string
[Status].[Presentation].[Type] // string-enumeration
[Status].[Timezone] // string
[Status].[Synchronization] // object
[Status].[Synchronization].[Settings] // object
[Status].[Synchronization].[Settings].[Enabled] // boolean
[Status].[Synchronization].[Schedule] // object
[Status].[Synchronization].[Schedule].[Enabled] // boolean
[Status].[Synchronization].[Content] // object
[Status].[Synchronization].[Content].[Enabled] // boolean
[Status].[Script] // object
[Status].[Script].[Type] // string-enumeration
[Status].[Script].[Version] // string
[Status].[Script].[Plugins] // object array
[Status].[Firmware] // object
[Status].[Firmware].[Version] // string
[Status].[Storage] // object array
[Status].[Network] // object
[Status].[Network].[ExternalIp] // string
[Status].[Network].[Interfaces] // object array
[Status].[Uptime] // TimeSpan
[Status].[CurrentSettingsTimestamp] // DateTime
[Status].[CurrentScheduleTimestamp] // DateTime
[Status].[Health] // string-enumeration
[Status].[LastModifiedDate] // DateTime
[Subscription] // object
[Subscription].[Id] // integer
[Subscription].[Device] // object
[Subscription].[Device].[Id] // nullable integer
[Subscription].[Device].[Serial] // string
[Subscription].[Type] // string-enumeration
[Subscription].[ActivityPeriod] // TimeSpan
[Subscription].[Status] // string-enumeration
[Subscription].[CreationDate] // DateTime
[Subscription].[ActivationDate] // nullable DateTime
[Subscription].[SuspensionDate] // nullable DateTime
[Subscription].[ExpirationDate] // nullable DateTime
[TaggedGroups] // object array
[Tags] // object
[Permissions] // object arraySystem and Custom Tags
In addition to properties each 'Player' entity instance may have a different set of system and custom tags specified by customer, exposed via the [Dictionary<string, object>] Tags property and managed via the following BSN.cloud Main API methods:
PUT
...
~/{version}/REST/Devices/{playerId:int}/
...
PUT
...
~/{version}/REST/Devices/{serial}/
...
PATCH
...
~/{version}/REST/Devices/{playerId:int}/
...
PATCH
...
~/{version}/REST/Devices/{serial}/
...
GET
...
~/{version}/REST/Devices/{playerId:int}/Tags/
...
GET
...
~/{version}/REST/Devices/{serial}/Tags/
...
POST
...
~/{version}/REST/Devices/{playerId:int}/Tags/
...
POST
...
~/{version}/REST/Devices/{serial}/Tags/
...
DELETE
...
~/{version}/REST/Devices/{playerId:int}/Tags/
...
DELETE
...
~/{version}/REST/Devices/{serial}/Tags/
Each system and custom tag must be explicitly specified for the target entity instance but the list of available system tags is
...
predefined by product owners and mapped to some properties so their values must be always in sync. For example, the system tag mapped to the
...
Player Health Status property is called:
string::[Device].<HealthStatus>
...
Property and Tag Mentions in Expressions
Property and tag mentions in expressions are different: properties are wrapped by square brackets and are separated by dots while tags are wrapped by angle brackets and may optionally be prepended by the target entity name in square brackets, and the data type is separated by double colon as you can see in the example above. Each property and tag has a strong data type, for properties and system tags it is defined in data contract of a target API version and for custom tags it is resolved either from fully qualified name or first assigned value. In addition, there is a request to support custom tags without values acting as labels. The data type defines which operators and functions are applicable to a given property or tag in conditions.
The properties and tags
...
of boolean
...
data type typically support the following operators:
IS
...
TRUE
...
IS
...
FALSE
The properties and tags
...
of numeric
...
data types typically support the following operators:
IS
...
{number}
...
IS
...
NOT
...
{number}
...
IS
...
GREATER
...
THAN
...
{number}
...
IS
...
LESS
...
THAN
...
{number}
...
IS
...
IN
...
THE
...
RANGE
...
{number}
...
AND
...
{number}
...
IS
...
NOT
...
IN
...
THE
...
RANGE
...
{number}
...
AND
...
{number}
...
IS
...
IN
...
({number},
...
{number},
...
...)
...
IS
...
NOT
...
IN
...
({number},
...
{number},
...
...)
...
The GPS coordinates also support expressions like:
GPS
...
LOCATION
...
([Latitude]
...
AND
...
[Longitude])
...
IN
...
({latitude},
...
{longitude},
...
{distance})
...
GPS
...
LOCATION
...
([Latitude]
...
AND
...
[Longitude])
...
NOT
...
IN
...
({latitude},
...
{longitude},
...
{distance})
The properties and tags
...
of string
...
data type typically support the following operators:
IS
...
NULL
...
IS
...
NOT
...
NULL
...
IS
...
'{expression}'
...
IS
...
NOT
...
'{expression}'
...
BEGINS
...
WITH
...
'{string}'
...
ENDS
...
WITH
...
'{string}'
...
CONTAINS
...
'{string}'
...
DOES
...
NOT
...
CONTAIN
...
'{string}'
...
CONTAINS
...
ALL
...
('{string}',
...
'{string}',
...
...)
...
CONTAINS
...
ANY
...
('{string}',
...
'{string}',
...
...)
...
IS
...
IN
...
('{string}',
...
'{string}',
...
...)
...
IS
...
NOT
...
IN
...
('{string}',
...
'{string}',
...
...)
The expressions used in IS and IS NOT operators may include '*', '?', '[' + ']' wildcards.
The properties and tags
...
of DateTime (timestamp) data type typically support the following operators:
IS
...
'{DateTime}'
...
IS
...
NOT
...
'{DateTime}'
...
IS
...
AFTER
...
'{DateTime}'
...
IS
...
BEFORE
...
'{DateTime}'
...
IN
...
THE
...
LAST
...
({interval},
...
{range},
...
'{DateTime}')
...
where
...
{interval}
...
is
...
one
...
of
...
{
...
"YEARS",
...
"MONTHS",
...
"DAYS"
...
}
...
enumeration
...
values
...
NOT
...
IN
...
THE
...
LAST
...
({interval},
...
{range},
...
'{DateTime}')
...
where
...
{interval}
...
is
...
one
...
of
...
{
...
"YEARS",
...
"MONTHS",
...
"DAYS"
...
}
...
enumeration
...
values
...
IS
...
IN
...
THE
...
RANGE
...
'{DateTime}'
...
AND
...
'{DateTime}'
...
IS
...
NOT
...
IN
...
THE
...
RANGE
...
'{DateTime}'
...
AND
...
'{DateTime}'
...
IS
...
IN
...
('{DateTime}',
...
'{DateTime}')
...
IS
...
NOT
...
IN
...
('{DateTime}',
...
'{DateTime}')
The '{DateTime}' value format must follow ISO 8601 and is typically like '2021-12-20T18:25:01.123Z'.
The properties and tags
...
of TimeSpan (time interval) data type typically support the following operators:
IS
...
'{TimeSpan}'
...
IS
...
NOT
...
'{TimeSpan}'
...
IS
...
GREATER
...
THAN
...
'{TimeSpan}'
...
IS
...
LESS
...
THAN
...
'{TimeSpan}'
...
IS
...
IN
...
('{TimeSpan}',
...
'{TimeSpan}')
...
IS
...
NOT
...
IN
...
('{TimeSpan}',
...
'{TimeSpan}')
The '{TimeSpan}' value format must follow ISO 8601 and is typically like '3.18:25:01'.
The properties and tags
...
of numeric array
...
data types typically support the following operators:
IS
...
NULL
...
IS
...
NOT
...
NULL
...
CONTAINS
...
ALL
...
('{number}',
...
'{number}',
...
...)
...
CONTAINS
...
ANY
...
('{number}',
...
'{number}',
...
...)
The properties and tags
...
of string array
...
data type typically support the following operators:
IS
...
NULL
...
IS
...
NOT
...
NULL
...
CONTAINS
...
ALL
...
('{string}',
...
'{string}',
...
...)
...
CONTAINS
...
ANY
...
('{string}',
...
'{string}',
...
...)
The properties and tags
...
of object
...
data type typically support the following operators:
IS
...
NULL
...
IS
...
NOT
...
NULL
Sort expressions may contain only one fully qualified property name or tag with optional ASC/DESC qualifier, but should support more in future.