ExecuteSuperTenantQueryActionHandler

Description

This actionhandler can be used by a super admin because it requires super admin rights.

Super admins can create queries and store them in the database table called loom_DBQUERY. The workflow designer can call queries from that table via this actionhandler.

Class

com.dooris.bpm.actionhandler.ExecuteSuperTenantQueryActionHandler

Parameter	Default value	Description

Parameter	Default value	Description
`nameOfQuery`	n/a	This parameter is used to set the query name which is in the table of queries that are created and stored before.
`parametersForQuery`	n/a	This parameter is used to set parameters that are created and stored for the query.
`nameOfResponseVariable`	n/a	This parameter is used to set the name of the response which will contain the result of the executed query.

Admin page:

Example:

We have a simple workflow to get total number of process instances. In this example, the query named getNumberOfInstances which is created in the super admin account is used.

If you set the tenant as super admin, only the super admin can access this query via the actionhandler. In order to access this query without super admin rights, desired tenant should be set here.

Parameter	Description	Valid Examples

Parameter	Description	Valid Examples
`nameOfQuery`	The name of the query from the query table.	`getNumberOfInstances`
`parametersForQuery`
`nameOfResponseVariable`	Name of the variable can be set here ´.	`instanceNum`

The result of the query which is stored in the instanceNum variable can be seen via the instance report of the ‘Number of Process Instances':