Hi everyone. I'm with a problem with a property returned from a a!queryProcessAnalytics from a Report.
The Report returns this data:
And I have a problem with a dp0 field that is mentioned on the column configs as the task details:
I get that field in this way:
And I put all that data in a grid on an interface, but sometimes I get this error:
And I show it like this on the interface:
Thanks for everyone who can help me with this problem!
Discussion posts and replies are publicly visible
Can you share the full code?
May be, before applying data to grid, just observe queryProcessAnalytics's results. In that result itself if you see a duplicates then find which columns it take its as identifiers, if its task id it should not duplicate but if its a process id it can be duplicate(assuming in same process you have two active task) so make sure you have something unique or else construct your unique identifiers manually by constructing the data subset structure from the results!
As the error message indicates, one of the IDs in the list indicated is duplicated. I suggest you do some further debugging of your queryProcessAnalytics call in an Expression Rule editor in order to do the necessary refinements to your report.
I inspected everything that was returned from the report and found that there is only one repeated Id, the problem is that I don't know where that Id belongs to
May be remove all links from process report keep one by one and see which column id is taken as identifier?
We need a bit more information about your report. Is it a Task report or Process report? Does any particular process instance have two simultaneous active tasks? What exactly does the duplicated ID map to in terms of a process instance? (process ID? task ID? something else?)
Task id should not get duplicate. is this happening always? can you find actual process which is causing a duplicates?
I'm not sure what the issue will be, but you need to double check your report configuration and your queryProcessAnalytics call. Can you post your queryProcessAnalytics code, in a Code Box, here? Can you confirm that your Report is not set to "include data from sub-processes"?
Another thing to check is what context you are using - is it querying tasks for users, processes, process models, etc?
Yes the report is not set to "include data from sub-processes"
© 2021 Appian. All rights reserved.