MIMM 11.1.0 MQL
Winter 25 | Scheduled Update
Fall 25 | Released Update 09-15-2025
Summer 25 | Released Update 07/21/2025
Spring 24 | General Availability 03-27-2024
New Or Improved Features
-
Profile relationships, custom relationships, and related object relationships can be used in the SELECT list. Custom relationships can be used in the WHERE clause as well as the SELECT list.
-
Scope Filters in the FROM clause can be used to reduce the scope of a MQL query.
-
New system attributes are added: "Conditional Labels", "Created By", "Created Date", "Data Profiling", "Data Sampling", "Data Classifications", "Data Classifications Proposed", "Data Classifications Matched", "Data Classifications Approved", "Data Classifications Rejected", Editors, "Has Data Impact", "Has Data Lineage", "Has Semantic Definition", "Documentation", "Mapped Documentation", "Inferred Documentation", "Last Change Event", "Object Image", "Owner", "Sensitivity Label", "Sensitivity Label Approved", "Sensitivity Label Lineage Proposed", "Sensitivity Labels Data Proposed", "Sensitivity Labels Rejected", "Updated By", Viewers, Watchers, "Workflow Assignees", "Workflow State", "Workflow Deprecation Requested" and "Workflow Published".
Note that the original profile attribute Documentation of glossary terms has been renamed to "Long Description" to not conflict with the new "Documentation" attribute described above. The Documentation system attribute applies to imported objects. For more information refer to the Documentation system attribute.
Term's workflow "Status" and "State" attributes have been changed into the different and more generic system attributes "Workflow State", "Workflow Published", and "Workflow Deprecation Requested" that now apply to any object of a user model under workflow.
-
System attribute "My Workflow Tasks" is supported on all custom model objects which have workflow enabled.
-
Object-valued system attributes can be used in the WHERE clause with the EXISTS or NOT EXISTS operator.
-
Attribute notation marks #..#, [...], {...}, and <...> are no longer necessary. You can use the attribute name as is.
-
A new ExpandedMembersOfRole function can be used to filter users and groups of the object roles.
-
A new MembersOfRole function can be used to select users and groups of the object roles.
-
Data Profiling Attributes can be used in the SELECT or WHERE clause.
-
Inequality operator, <, <=, >, >= and BETWEEN, are supported on attributes with numeric data types, such as Integer, Long and Double.
-
Inequality operator, != and != ANY(...), are supported on the category filter and the system attributes "Model Id", "Object Type", "Object Type Id", "Object System Type", "Object Id", "Object Profile", and "Object Stable Id".
-
Order by "Updated Date" in descending order, i.e. the newest objects are at the top of the results.
-
The behavior of Multi-valued Attribute Filter in Where is better defined.
-
The system attributes "Certified By", "Endorsed By", "Commented By" and "Warned By" are now an array of Grantee objects instead of an array of strings that represents user names. The Grantee object provides more information than just the user name and is consistent with other system attributes which value represents an array of users or groups.
Deprecated Features
Deprecated features do not require any action before upgrading to MM 11.0.0. If any of these features are used in worksheets, dashboards, conditional labels and collections created in the previous release, they will be automatically upgraded. In order to use any of these features in MQL queries in the REST API functions, you need to set the mqlVersion parameter to 1 so that they can be automatically upgraded.
| Deprecation of features | Replacements | More information |
|---|---|---|
| Attribute notation marks | Improve the usability. Removal is considered for the next major release | |
| "Semantic Types" system attribute | "Data Classifications" system attribute | Rebranding. Removal is considered for the next major release |
| "Business Name Inferred" system attribute | The new Documentation system attributes | Rebranding. Removal is considered for the next major release |
| "Business Name Inferred Origin" system attribute | The new Documentation system attributes | Rebranding. Removal is considered for the next major release |
| "Business Description Inferred" system attribute | The new Documentation system attributes | Rebranding. Removal is considered for the next major release |
| "Business Description Inferred Origin" system attribute | The new Documentation system attributes | Rebranding. Removal is considered for the next major release |
| Used system attribute | "Has Semantic Usage" system attribute | Rebranding. Removal is considered for the next major release |
| Endorsements system attribute | "Endorsed By" system attribute | Rebranding. Removal is considered for the next major release |
| Comments system attribute | "Commented By" system attribute | Rebranding. Removal is considered for the next major release |
| Certifications system attribute | "Certified By" system attribute | Rebranding. Removal is considered for the next major release |
| Warnings system attribute | "Warned By" system attribute | Rebranding. Removal is considered for the next major release |
| "Workflow Actions" system attribute | "My Workflow Tasks" system attribute | Rebranding. Removal is considered for the next major release |
| "Last Modified Date" system attribute | "Updated Date" system attribute | Rebranding. Removal is considered for the next major release |
| Stewards system attribute in SELECT list | MembersOfRole function | Steward is replaced by object roles |
| Stewards system attribute in WHERE | ExpandedMembersOfRole function | Steward is replaced by object roles |
| steward filter | ExpandedMembersOfRole function filter | Steward is replaced by object roles |
| object_type filter | "Object Type" filter | Deprecated with MM 10.1.0 to reduce the number of reserved words |
| last_modified filter | "Updated Date" filter | Deprecated with MM 10.1.0 to reduce the number of reserved words |
| label filter | Labels filter | Deprecated with MM 10.1.0 to reduce the number of reserved words |
| semantic_type filter | "Data Classifications" filter | Deprecated with MM 10.1.0 to reduce the number of reserved words |
| endorsed_by filter | "Endorsed By" filter | Deprecated with MM 10.1.0 to reduce the number of reserved words |
| certified_by filter | "Certified By" filter | Deprecated with MM 10.1.0 to reduce the number of reserved words |
| commented_by filter | "Commented By" filter | Deprecated with MM 10.1.0 to reduce the number of reserved words |
| warned_by filter | "Warned By" filter | Deprecated with MM 10.1.0 to reduce the number of reserved words |
The Stewards system attribute used to be a related object type and related object property. For example, you could use #Stewards#.[Email] or #Term#.#Stewards# in the SELECT or WHERE clause. This feature is no longer available. You cannot use MembersOfRole('Steward') or ExpandedMembersOfRole('Steward') as a related object type or related object property. MembersOfRole('Steward').[Email] or Term.ExpandedMembersOfRole('Steward') etc. is not a valid syntax.