Metadata Query Language and Query Filters
MQL allows users to define powerful and complex metadata queries with a familiar SQL syntax.
The MQL is available through the REST API and constitutes the foundation of the search / worksheet page. For syntax details, refer to the Developer Guide.
You may use the worksheet Preferences to toggle showing or hiding the metadata query language (MQL) query.
Anything you do in the Filters is reflected in the MQL. You may also edit the Filters from the perspective of the MQL directly by using the Advanced model.
Steps
- Open a worksheet by any of the create methods detailed, or go to
- WORKSHEETS > Manage,
- WORKSHEETS > RECENT >,
- WORKSHEETS > FAVORITES >
- In the Results panel, click Preferences > SHOW CURRENT QUERY in the worksheet Preferences.
- Click +FILTER and +QUERY to add MQL directly as additional filters.
You may add any number of query filters. You may toggle them on and off. They become a saved part of any worksheet you save.
Example
Go to WORKSHEETS > Manage > Certified Terms.
Click SHOW CURRENT QUERY in the Worksheet results preferences.
Click +FILTER and +QUERY.
Click EDIT under the MQL FILTER, and build the query for Comment Count greater than or equal to 1.
Click OK.
Name the filter “Highly Commented”.
You now have a quick filter that you may enable or disable with the switch control.
If you wish to maintain a quick filter, you should save it as a part of a worksheet.