QueryDefinition

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"
    }
  }
]