The operators supported for String or Text attributes are described in the following table:
|
Operator |
Description |
|
eq |
Equal |
|
ne |
Not equal |
|
substringof |
Contains substring |
|
startswith |
Starts with |
|
endswith |
Ends with |
EXAMPLES:
Filter by assets with name equal to "Computer":
{RMUrl}/api/Organization/assets?$filter=Name eq 'Computer'
Filter by events that are not of the "Risk Event" type:
{WSUrl}/api/events?$filter=EventType ne 'Risk Event'
Filter by people who have "Doe" in their names:
{RMUrl}/api/Organization/people?$filter=substringof('Doe',Name)
Filter by people who have "Doe" as a last name:
{RMUrl}/api/Organization/people?$filter=endswith(Name,'Doe')
Filter by people who have "John" as a first name:
{RMUrl}/api/Organization/people?$filter=startswith(Name,'John')