207571 - no subject - \n\nHello !\n\nWe are using a!queryProce

Hello !

We are using a!queryProcessAnalytics in an expression rule with a rule input of type number(integer)- ri!instancesList, to check if some instance ids are active.


The code of the expression rule is below:

= load(
local!result: a!queryProcessAnalytics(
report: cons!CON_CL_ACTIVE_PROCESS_BY_PROCESS_MODEL,
contextProcessModels: cons!CON_CL_CORPORATE_LENDING_PROCESS_MODELS,
query: a!query(
pagingInfo: a!pagingInfo(
startIndex: 1,
batchSize: - 1
),
logicalExpression: a!queryLogicalExpression(
operator: "AND",
filters: {
a!queryFilter(
field: "c0",
operator: "in",
value: ri!instancesList
)
}
)
)
),
if(
local!result.totalCount = 0,
tointeger(
{}
),
local!result.data.c0
)
)

This expression rule is called on the output of a script task in several processes in our application
From time to t...

OriginalPostID-207571

Viewing Report Calculation Times and Metrics.xlsx