ServiceNow Filter
To use the complex filters in ServiceNow, you must know the encoded query for the filter conditions that you can get from any list view in ServiceNow.
To retrieve a list view in ServiceNow complete the following:
-
Create a filter on the ServiceNow managed system.
-
Right-click the filter link and select the copy query option. Mention the copied query only in Aggregation Filter Settings on the UI and select Save.
-
For an AND operator use: ^
-
For an OR operator use: ^OR
For example, the following query will fetch all the active records with their respective locations, as mentioned in the encoded query:
active=true^location=dbf3b4790a0a0a6501a7673fb1b28f7f^ORlocation=dbf440100a0a0a65006618f752ee74b5
-