Table of Contents

User Defined Query

UserDefinedQueryId : int64Code : stringDescription : stringNotes : stringEntity : stringAddPermissionFilter : booleanSequenceNumber : int32CreatedOn : datetimeModifiedOn : datetimeVersion : int32UserDefinedQuerySqlSql : stringUserDefinedQueryColumnColumnName : stringPropertyName : stringPropertyPath : stringOutput : booleanPermissionColumn : booleanPrimaryPermissionColumn : booleanPermissionColumns : string arrayUserDefinedQueryParameterParameterName : stringInjectCurrentUser : booleanPrimaryPermissionParameter : booleanPermissionTreeUseruser rightscreated bymodified byquery definitioncolumns1..*parameters1..*

Learn more about Alarms from the following resources:

Operations

Operation Operation Id Summary Detail
GET GetUserDefinedQuery

Get a User Defined Query resource.

View

PATCH UpdateUserDefinedQuery

Update an existing User Defined Query resource.

View

DELETE DeleteUserDefinedQuery

Delete an existing User Defined Query resource.

View

GET ExecuteUserDefinedQuery

Execute the custom User Defined Query to get the query results

View

GET GetUserDefinedQueryCollection

Get a collection of User Defined Query resources.

View

POST CreateUserDefinedQuery

Create a new User Defined Query resource.

View

GET LookupUserDefinedQueryChangePermissionTree

Lookup the permission set for changing the User Defined Query.

View

GET LookupUserDefinedQueryInsertPermissionTree

Lookup the permission set for creating the User Defined Query.

View

DELETE BatchDeleteUserDefinedQuery

Delete a collection of existing User Defined Query resources.

View

PATCH ChangeUserDefinedQueryPermissionTree

Change the PermissionTree for an existing User Defined Query resource.

View

POST VerifyAllUserDefinedQueries

Verify the SQL of all the User Defined Query resources

View

POST VerifyUserDefinedQuery

Verify the SQL of the User Defined Query resource

View

PATCH BatchChangeUserDefinedQueryPermissionTree

Change the PermissionTree status for a collection of existing User Defined Query resources.

View

POST BatchVerifyUserDefinedQuery

Verify the SQL for the collection of User Defined Query resources

View