Task ID not showing in Tasks Report

Hi Rishub,

Have you used 'tp!id' which will give task id. In that documentation link also they mentioned about it.

@rishu, Does the task report, on which you have applied a!queryProcessAnalytics(), contain the Task Id as a column?? If so, it will be in the result set that comes out of a!queryProcessAnalytics() as data and then you can make use of it in your Tempo Task Report

I don't think there isn't a need to add the tp!id(task id) explicitly in the report. If it's a task report, the task ids are already available as identifiers in the PortalReportDataSubset(results of analytics query) and the same can be used if needed.

*is a need

@Sikhivahans, When I am looking at data from report, I get field c0-c6,which are represented as Name, Received, Priority, Process, Status, Deadline, Assigned To. Can you please tell how can I add task ID to that?

@rishub Let's say the result of analytics query is stored in a variable by name report_ds. Then using the index(local!report_ds,"identifiers",{}) as value of the gridTextColumn should list out all the task ids. Use the same if you would like to utilise the task ids in the drill down or for a debugging purpose.

In case if you want to surface these ids to the end users and allow them to sort based on it, you can opt for the approach mentioned by @rajasekharp / @poornah.