Hi Team,
I am trying to generate reports on processHQ. But due to the processHQ limitation on using one to many relationship records, I am unable to structure the report the way i wanted to do.
Actual Idea:
There is an approval flow, where one form will have multiple reviewers. From process HQ, I am expecting to prepare a report (record grid) where I show the formId and its multiple reviewers names.
Limitation:
Process HQ doesn't support using one to many relationship records.
Any Idea, if there is any work around here, to accommodate the actual Idea. Acc to Appian Documentation, it suggested to use backward relation to turn one to many -> many to one, but this will not fit into my case as i have many other records to deal with ( few are one to many while few are many to one).
I just want to know if anyone came across similar situation. If yes, may I your approach in solving this.
Thankyou!
Discussion posts and replies are publicly visible
Geethasri said:There is an approval flow, where one form will have multiple reviewers. From process HQ, I am expecting to prepare a report (record grid) where I show the formId and its multiple reviewers names.
In my mind, this is a process, where each reviewer has a task assigned. Then, I use a process report to show users a task list.
I do not see a use case for process HQ here.
No, I am not referring anything from developer's perspective for showing tasks list. I need to generate a report in processHQ to display all records information at one place which is helpful for the business users to understand and deal with their data.