Filter Types
The following is a list of supported filter types defined by MQL.
Filter type |
Description |
Supported operators |
Examples |
Text [WITHIN (search_properties)] |
Simple word, quoted phrase or advanced search text. See subsequent section on search text filter. An optional WITHIN search properties clause can be used to specify the search scope. |
=, = ... WITHIN (...)
|
text='+phone +number' WITHIN ('Name', 'Physical Name', 'Description') |
Semantic_search_text [WITHIN (search_properties)] |
Semantic search phrase. Refer to Meta Integration Search Help. An optional WITHIN search properties clause can be used to specify the search scope. |
=, = ... WITHIN (...)
|
semantic_search_text='customer tables' |
category |
Category of the search scope, such as 'Glossary.Term', or 'Database' |
=, !=, = ANY (...), != ANY (...) |
category='Glossary.Term' |
Profile attribute name |
A profile attribute name can be qualified by a profile name to prevent ambiguity. |
=, !=, = ANY (...), != ANY (...), = ALL (...), != ALL (...), [NOT] EXISTS, [NOT] STARTS WITH, [NOT] ENDS WITH, [NOT] CONTAINS, <, <=, >, >= and BETWEEN |
"Data Type"='int' OR "Data Modeling (Business)"."Data Type"='STRING' |
Custom attribute name |
Custom attributes of the BLOB data type cannot be used as filter types. |
=, !=, = ANY (...), != ANY (...), = ALL (...), != ALL (...), [NOT] EXISTS, [NOT] STARTS WITH, [NOT] ENDS WITH, [NOT] CONTAINS, <, <=, >, >= and BETWEEN |
"Custom Attribute Int" = ANY (2000, 2001) |
Custom relationship name |
Complex custom relationships or simple custom relationships. |
=, !=, = ANY (...), != ANY (...),= WHERE (...), != WHERE (...), |
"Is Defined By" = WHERE(Category='Glossary.Term' AND Name CONTAINS 'Account') |
UDP name |
|
=, !=, = ANY (...), != ANY (...), [NOT] EXISTS, [NOT] STARTS WITH, [NOT] ENDS WITH, [NOT] CONTAINS |
"2PC Option_1092616415"='N' AND "Schema prfx_1092616409" EXISTS |
System attribute name |
Not all system attributes can be used as filter types. |
Depends on the system attribute |
id='Customer ID' |
Data profiling attribute name |
A data profiling attribute is qualified by "Data Profiling". |
=, !=, = ANY (...), != ANY (...), [NOT] EXISTS, <, <=, >, >= and BETWEEN etc. |
"Data Profiling"."Min Length"=2 |
Related object type.Property |
Property can be profile attribute name, custom attribute name, UDP name or system attribute |
Depends on the property |
Children."Object Type"='Column' |
Function |
Currently only ExpandedMembersOfRole function is supported. |
=, !=, = ANY (...), != ANY (...), = ALL (...), != ALL (...), [NOT] EXISTS |
ExpandedMembersOfRole('Workflow Editor')=ANY(ME, 'John') |
Did this page help you?
If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!