164302 - no subject - How to get column data from portalreport

...s=[value=164, drilldown=]; [value=1, drilldown=]; [value=1, drilldown=]; [value=70, drilldown=]; [value=6, drilldown=]]; [cells=[value=164, drilldown=]; [value=1, drilldown=]; [value=1, drilldown=]; [value=70, drilldown=]; [value=6, drilldown=]]; [cells=[value=164, drilldown=]; [value=1, drilldown=]; [value=1, drilldown=]; [value=70, drilldown=]; [value=6, drilldown=]], identifiers=4530; 11779; 536884542; 4711; 5121, report=[name=Region Status, description=Total Active Contracts by Contract Analyst (Aggregated)], columns=[label=Region, field=3, alignment=LEFT]; [label=Cancelled, field=5, alignment=RIGHT]; [label=Not Started, field=6, alignment=RIGHT]; [label=On Hold, field=7, alignment=RIGHT]; [label=Under Review, field=8, alignment=RIGHT]; [label=Awaiting Final Approval, field=9, alignment=RIGHT]; [label=Sent to Relationship Manager, field=10, alignment=RIGHT]; [label=Contract Signed by Client, field=11, alignment=RIGHT]; [label=Completed, field=12, alignment=RIGHT...

...]]

@shaoyongw Hi, did you go through the documentation of this plugin? If not please find attached the documentation. This explains how you can obtain a column. If you want to get a row, you can be able to do it merging a cell from each column(using looping functions).

@shaoyongw If you are on Appian 7.8 or 7.8+, I would like suggest to make use of a!queryProcessAnalytics(), as getportalreportdatasubset() is deprecated.

The older version documentation has some good examples as well, you can find it here:
forum.appian.com/.../Task_Report_Tutorial