How to use a!querySelection with a!queryProcessAnalytics

marky over 7 years ago

Hello:

selecting a column such as "c3" is not working and returning null.

Any idea how to use a selection field for a process task report query?

We need to have 15000+ tasks in the task report, so we need to get a count of the total and use paging to handle this much data.

Thank you,

Discussion posts and replies are publicly visible

Parents

0 vijaykumars282 over 7 years ago

Marky,
Please try to use it in following way :-

a!queryProcessAnalytics(
report: cons!PRT_DOC_PRICING_TASKS_REPORT,
contextProcessModels: cons!PRT_PM_SEND_QUOTE_REQUEST_TO_PRICING,
query: a!query(
logicalExpression: a!queryLogicalExpression(
operator: "AND",
filters: {
a!queryFilter(
field: "c1",
operator: "in",
value: {0,1}
),

a!queryFilter(
field: "c20",
operator: "=",
value: ri!processId
),
a!queryFilter(
field: "c19",
operator: "=",
value:ri!txtTaskStatus
)
}
),
pagingInfo: ri!pagingInfo
)
).data.c4
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 vijaykumars282 over 7 years ago

Marky,
Please try to use it in following way :-

a!queryProcessAnalytics(
report: cons!PRT_DOC_PRICING_TASKS_REPORT,
contextProcessModels: cons!PRT_PM_SEND_QUOTE_REQUEST_TO_PRICING,
query: a!query(
logicalExpression: a!queryLogicalExpression(
operator: "AND",
filters: {
a!queryFilter(
field: "c1",
operator: "in",
value: {0,1}
),

a!queryFilter(
field: "c20",
operator: "=",
value: ri!processId
),
a!queryFilter(
field: "c19",
operator: "=",
value:ri!txtTaskStatus
)
}
),
pagingInfo: ri!pagingInfo
)
).data.c4
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data