Skip to main content
andrp0001
July 19, 2021
Question

Problems with an unknown Report Property

  • July 19, 2021
  • 12 replies
  • 0 views

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!

12 replies

gayathris111098
July 19, 2021

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!

mikes0011
Brainy
July 19, 2021

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.

andrp0001
andrp0001Author
July 20, 2021

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

gayathris111098
July 20, 2021

May be remove all links from process report keep one by one and see which column id is taken as identifier?

andrp0001
andrp0001Author
July 29, 2021

Thank you all for your answers but it was just a bug with an a!refreshVariable and a .data on the a!queryProcessAnalytics. [emoticon:9d27520b879541edb4dc3688e695ae44]‍