Source filter and Lookup queries when server is Ivanti (ISM)

If the server type is Ivanti (ISM) then the following restrictions apply to all queries (Source filter queries as well as Lookup queries ) :

1. Arithmetic operations ( +, -, *, /, MOD ) in queries are not permitted.
2. NOT and LIKE operators are also not permitted.
3. CONTAINS and STARTSWITH operators are enabled and available to use.
4. Server Queries are not permitted.
5. Bracketing of queries to build complex nested queries is also permitted.

Sample Precision Bridge query for Ivanti on the Incident# form: