The QueryDefinition table contains tenant specific queries.

Column	Type	Description
ID	String	Query's `UUID` (primary key).
Name	Localized String	Query's name.
Description	Localized String	Query's description.
Category	String	Category assigned to the query (reports, etc.).
Owner	String	User who owns the query.
Rank	Integer	Query ranking.
Query	String	Query text (sql, stored procedure reference, etc.).

Example Query

The following query returns the results from the designated columns that fullfill the LIKE requirement:

{
Script: "select Name, Description, Query, Owner, Category from QueryDefinition 
    WHERE category LIKE '%#[email protected]|null%'"}

The query returns all users with "test" in their login name.

SQueryDefinition table query response:

...
"FullCount": 1,
 "Results": [
  {
    "Entities": [],
    "Row": {
      "Query": "select NormalizedUser, whenoccurred from Event
      where eventtype=\"Cloud.Saas.Application.AppLaunch\" and Applicationname like 'Linked%'\n",
      "Name": "Linkedin Launches",
      "Owner": "[email protected]",
       "Description": "",
      "Category": "Report#[email protected]|null"
    }
  }
]