I am using a!queryProcessAnalytics to fetch data from a portal report with a group context.

mattj over 8 years ago

#queryProcessAnalytics I am using a!queryProcessAnalytics to fetch data from a portal report with a group context. I am wondering if there is a way to add a user context (and a process model context) to the report after it has already been created? In the last query filter below marked "HERE", I am returning all users in a selected group using fn!distictusers, and trying to filter the data within the a!queryProcessAnalytics based on the users in that group. It is not working because it throws an error "All “data” arrays must not contain more items than the specified “batchSize”, but “batchSize” was 25 and the largest column data array had 26 items". It works in some lower environments but not all, which makes me think its a data issue. Does anyone have any ideas on how to fix this?

a!queryProcessAnalytics(
report: local!portalReportId,
contextGroups: local!selectedDepartment,
query: a!query(
...

Discussion posts and replies are publicly visible

0 mattj over 8 years ago

Thank you! I am using queryProcessAnalytics to query a portal report for reassigning tasks to multiple users through a process. The process is working correctly and the new assignee does reflect in the portal report. However, The data on the SAIL screen doesnt seem to update with the new assignee. It still shows the old assignee. The grid and datasubest are inside a with().
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 sikhivahans over 8 years ago

@mattj Where is the actual query to analytics located? I guess it might have resided in load() as of now. It might be better moving the query inside with() or inside the 'saveInto' of a component with which you actually interact with to refresh the interface.

Also please do bear in mind that the interface should be refreshed by some or the other means to see the new data, that is for instance, a button click or an interaction with a component should trigger the query again and thereby refresh the datasubset.

Also if you are able to upload the code snippet, the practitioners here, would be able to guide you by suggesting the changes.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 mattj over 8 years ago

Thanks, Yes the query is in a with. If I execute the a!queryprocessanalytics in a dummy expression with no filters and only the portal report constant and the context group, It still returns the old datasubset. The assignee still shows as "Me" when it should say someone elses name.

a!queryProcessAnalytics(
report: cons!BW_CMPO_REPORT_TASKS_FOR_BOTW_GROUP,
contextGroups:local!selectedGroup
)

where local!selectedGroup is a selected group from a dropdown.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 mattj over 8 years ago

Again, the data is updated in the portal report, but not when i use the queryProcessAnalytics.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 mattj over 8 years ago

I figured it out! The column index that I was using was the inccorect one. I was using "c1" when it should have been "c6".
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel