• State Not Answered
  • Replies 9 replies
  • Subscribers 5 subscribers
  • Views 4442 views
  • Users 0 members are here
Related Discussions
Home » Discussions » Reports

I have a problem with showing the proper info in a portal report that shows all the active tasks.

bojanb

Hi,
I have a problem with showing the proper info in a portal report that shows all the active tasks. The problem is when the task is assigned to a group. At that point, the task is not shown to who it's assigned. A have created a rule to solve this issue:

=if(find("Group", tostring(ri!user)) <>0, getdistinctusers(ri!user), ri!user)

This rule works fine when tested as a rule (it expects an array of users or groups, and returns all the distinctive users that are specified + the users that are in the specified groups).
But when I use this rule in the report, it doesn't work - it shows a null value to whom the task is assigned.
That is my first problem.

My second problem is within my process model. I am trying to filter the report (from above) according to the user who started the process using the "Execute Process Report" node.
Here is how the "Additional Filter" is defined:
Assigned To =pv!requestor

When the task read from the report is assigned to a si...

OriginalPostID-204603

  Discussion posts and replies are publicly visible

Parents
  • 0
    @bojanb My solution is with regards to your first problem. You need to bear in mind that few categories of functions (namely Looping Functions, Scripting Functions and Evaluation Functions) won't work in Portal Reports. As per the expression you have been using, getdistinctusers() falls under Scripting Functions.

    At a high level, I understand that you are making use of 'Execute Process Report' smart service to retrieve the data in a process, so you may not need a Tempo Report. So what you can do here is, in the outputs of the smart service, format the data (You may use the rule at the post pointed out by @philb earlier) that is obtained from results of smart service via ACPs and store it in the target PVs.

    I will comment on your second problem shortly. Meanwhile it would be grateful if you can let us know the version of Appian you are working on and the category of Report (i.e. Tasks Per Process Model, Tasks Per Process) you have chosen.
Reply
  • 0
    @bojanb My solution is with regards to your first problem. You need to bear in mind that few categories of functions (namely Looping Functions, Scripting Functions and Evaluation Functions) won't work in Portal Reports. As per the expression you have been using, getdistinctusers() falls under Scripting Functions.

    At a high level, I understand that you are making use of 'Execute Process Report' smart service to retrieve the data in a process, so you may not need a Tempo Report. So what you can do here is, in the outputs of the smart service, format the data (You may use the rule at the post pointed out by @philb earlier) that is obtained from results of smart service via ACPs and store it in the target PVs.

    I will comment on your second problem shortly. Meanwhile it would be grateful if you can let us know the version of Appian you are working on and the category of Report (i.e. Tasks Per Process Model, Tasks Per Process) you have chosen.
Children
No Data
© 2024 Appian. All rights reserved.
We want to hear from you! Submit a review on Gartner or G2.