Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
Replies
4 replies
Subscribers
4 subscribers
Views
5378 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
Reports
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,
OriginalPostID-248800
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