• State Not Answered
  • Replies 9 replies
  • Subscribers 4 subscribers
  • Views 4610 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
    ...ngle user, then the filter (defined as above) works fine, but when the task is assigned to multiple users, it doesn't work - so I thought that I should change the way I defined the "Additional Filter" to:
    Assigned To LIKE pv!requestor

    But this way, I get all the data from the report (they are not filtered at all).
    Just to clarify, "pv!requestor" is the user that starts the process, and "Assigned To" is the column read from the report (the users to whom the task is assigned to).

    Do you have any idea how to solve my two problems - the one in my report (how to show users from a group in a filed), and the other one in my process model (with the proper definition of the additional filter)?

    Thank you in advance...
    BR, Bojan
Reply
  • 0
    ...ngle user, then the filter (defined as above) works fine, but when the task is assigned to multiple users, it doesn't work - so I thought that I should change the way I defined the "Additional Filter" to:
    Assigned To LIKE pv!requestor

    But this way, I get all the data from the report (they are not filtered at all).
    Just to clarify, "pv!requestor" is the user that starts the process, and "Assigned To" is the column read from the report (the users to whom the task is assigned to).

    Do you have any idea how to solve my two problems - the one in my report (how to show users from a group in a filed), and the other one in my process model (with the proper definition of the additional filter)?

    Thank you in advance...
    BR, Bojan
Children
No Data
© 2024 Appian. All rights reserved.
We want to hear from you! Submit a review on Gartner or G2.