Operators

Following is a list of operators defined by MQL:

Operator name

Symbol

Supported by Filter Types

EQUALS

= <value>

All

EQUALS WITHIN

= <value> WITHIN (search properties)

text, semantic_search_text

NOT EQUALS

!= <value> or <> <value>

Model, category, profile attribute, custom attribute, UDP, system attribute, data profiling attribute, source history attribute, related object property, ExpandedMembersOfRole

EQUALS ANY

= ANY (v1, v2, …, vn)

Model, category, profile attribute, custom attribute, custom relationship, UDP, system attribute, data profiling attribute, source history attribute, related object property, ExpandedMembersOfRole

NOT EQUALS ANY

!= ANY (v1, v2, …, vn)

Model, category, profile attribute, custom attribute, custom relationship, UDP, system attribute, data profiling attribute, source history attribute, related object property, ExpandedMembersOfRole

EQUALS ALL

= ALL (v1, v2, …, vn)

profile attribute, custom attribute, UDP, system attribute, "Data Profiling"."Inferred Data Types", related object property, ExpandedMembersOfRole

NOT EQUALS ALL

!= ALL (v1, v2, …, vn)

profile attribute, custom attribute, UDP, system attribute, "Data Profiling"."Inferred Data Types", related object property, ExpandedMembersOfRole

EQUALS WHERE

=WHERE (…)

System attribute Model, "Mentioned Objects" and custom relationship

NOT EQUALS WHERE

!=WHERE (…)

System attribute Model, "Mentioned Objects" and custom relationship

EXISTS

EXISTS

profile attribute, custom attribute, custom relationship, UDP, system attribute, data profiling attribute, source history attribute, related object property, ExpandedMembersOfRole

NOT EXISTS

NOT EXISTS

profile attribute, custom attribute, custom relationship, UDP, system attribute, data profiling attribute, source history attribute, related object property, ExpandedMembersOfRole

STARTS WITH

STARTS WITH <value>

profile attribute, custom attribute, UDP, system attribute, related object property

NOT STARTS WITH

NOT STARTS WITH <value>

profile attribute, custom attribute, UDP, system attribute, related object property

ENDS WITH

ENDS WITH <value>

profile attribute, custom attribute, UDP, system attribute, related object property

NOT ENDS WITH

NOT ENDS WITH <value>

profile attribute, custom attribute, UDP, system attribute, related object property

CONTAINS

CONTAINS <value>

profile attribute, custom attribute, UDP, system attribute, related object property

NOT CONTAINS

NOT CONTAINS <value>

profile attribute, custom attribute, UDP, system attribute, related object property

BEFORE

BEFORE <value> (exclusive)

"Created Date", "Updated Date", profile attribute, custom attribute, data profiling attribute, source history attribute, related object property with a date or datetime data type

AFTER

AFTER <value> (exclusive)

"Created Date", "Updated Date", profile attribute, custom attribute, data profiling attribute, source history attribute, related object property with a date or datetime data type

BETWEEN

BETWEEN <value> AND <value> (inclusive)

"Created Date", "Updated Date", data profiling attribute, source history attribute, profile attribute, custom attribute, system attribute, related object property with a date, datetime or numeric data type

LESS THAN

< <value>

Data profiling attribute, source history attribute, profiling attribute, custom attribute, system attribute, related object property with a numeric data type

LESS THAN OR EQUAL TO

<= <value>

Data profiling attribute, source history attribute, profiling attribute, custom attribute, system attribute, related object property with a numeric data type

GREATER THAN

> <value>

Data profiling attribute, source history attribute, profiling attribute, custom attribute, system attribute, related object property with a numeric data type

GREATER THAN OR EQUAL TO

>= <value>

Data profiling attribute, source history attribute, profiling attribute, custom attribute, system attribute, related object property with a numeric data type

 

Note:

When applied to a profile attribute, custom attribute, custom relationship, UDP, system attribute, data profiling attribute, or a related object property, a filter with the =, !=, <, <=, >, >=, = any (...), != any (...), = all (...), != all (...), [not] starts with, [not] ends with, [not] contains, before, after or between operator would only return any results if the profile attribute, custom attribute, custom relationship, UDP, system attribute, data profiling attribute, or related object property is applicable to the objects and the filter condition is satisfied. NOT EXISTS returns objects that the attribute is not applicable to.

In other words, if an object does not have any attribute Physical Name, any "Physical Name" filter with the operator =, !=, = ANY (...), != ANY (...), = ALL (...), != ALL (...), [NOT] STARTS WITH, [NOT] ENDS WITH, [NOT] CONTAINS, BEFORE, AFTER or BETWEEN will never return this object. But NOT EXISTS will return this object.