Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
Replies
18 replies
Subscribers
5 subscribers
Views
5201 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
Reports
63667 - no subject - Hi,\nI want a report that shows all task
moritzw
over 11 years ago
Hi,
I want a report that shows all tasks I am assigned to for specific process models.
I used the task per process modell report and added a column "assignees", which I set to tp!assignees.
On the dashboard I set the filter to "assignees like loggedinuser()".
However, this is always returning all the tasks of the process models.
Any better ideas how to get this report working?
Thanks, Moritz...
OriginalPostID-63667
Discussion posts and replies are publicly visible
0
edward
Certified Lead Developer
over 11 years ago
I used something simular on a report a little while ago but I had a string instead of assignees and I filtered to true() contains(assignees, loggedinuser())
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Jason Ruvinsky
Certified Senior Developer
over 10 years ago
isusermemberofgroup() cannot be called from a report, even though loggedInUser() works. Has anyone determined a way to check if the current user is a member of a group that is in a pv in a report?
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Jason Ruvinsky
Certified Senior Developer
over 10 years ago
I found a way to accomplish this if the report is placed on a portal page in the reports channel. You can use the isusermemberofgroup() function in the "additional filter" available on the channel.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
chandhinir
over 10 years ago
Hi Jason,
I tried "isusermemberofgroup" function in additiontal filter but it does not work.can you provide an example how did you use in the additional filter?
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Jason Ruvinsky
Certified Senior Developer
over 10 years ago
If you have a limited set of groups, and you know the user will only be in one of them (such as an office division), you can accomplish this. I couldn't find a good way to do it when a user could be in multiple groups.
Have a column that is the group. Create a constant for each group. Then create a rule that takes in a user, checks "isusermemberofgroup()" for each of the group constants, and returns the first group constant it finds (or return null).
Then in the additional filter, you can put "Group" = rule!whichGroupIsUserIn(loggedInUser())
Unfortunately, this is tailored to a fairly specific use case. It would be nice if there were a way to check group membership on a report. The alternative is having to store a list of all members of a group in a process variable, and checking the logged in user against that list - but that's not an ideal solution.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
chandhinir
over 10 years ago
Jason,
Thanks for the reply.
A column "group" has to be created in the report before using it in additional filter.
If I add a new column as "group" in report, then what would be the value for "Definition" in Data Tab?
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Jason Ruvinsky
Certified Senior Developer
over 10 years ago
The group type variable would be the definition.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
chandhinir
over 10 years ago
Thanks Jason!
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
<