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 marky over 7 years ago

Thank you for the suggestion, but with 15,000 rows of data, selecting all will result in crashing the server. We had to delete and refresh the analytics engine after multiple queries were eating up a lot of CPU, slowing down the environment, and blocking the deletion of the processes that were being queried. We will need to just create separate task reports with only a single column, and also use paging when we need all columns, as I don't see another option to handle this much data.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 marky over 7 years ago

Thank you for the suggestion, but with 15,000 rows of data, selecting all will result in crashing the server. We had to delete and refresh the analytics engine after multiple queries were eating up a lot of CPU, slowing down the environment, and blocking the deletion of the processes that were being queried. We will need to just create separate task reports with only a single column, and also use paging when we need all columns, as I don't see another option to handle this much data.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data