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
5214 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
shelzle
over 11 years ago
You could try to use the report "Tasks for User", add a column with the process model name and filter on this.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Michael.S
over 11 years ago
moritzw, this will work if you add a column of boolean(yes/no) and insert an expression of if(assignee=logginuser(), true(),false()) then filter that column for true.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
moritzw
over 11 years ago
I thought loggedinuser() doesn't work in reports?!
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
shelzle
over 11 years ago
The expression "if(assignee=logginuser(), true(),false())" can be reduced to "assignee=logginuser()" as the comparison already returns true() or false().
This may fail if the task is assigned to a group you are in.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
moritzw
over 11 years ago
unfortunately this also doesn't work if it's assigned to more than one user.
I guess the best solution is to filter the user report by process model name.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Michael.S
over 11 years ago
Folks, gotta think outside the box a bit. There are many ways to do this... you can create a rule for more complex expression evaluation. You can look at the array of assigned user to see if the logged in user is part of that array, you can look at the group membership (if assigned to a group) and ask if the logged in user is part of that group. Further, you could do this for just the task owner. Many, many ways to do what you're looking for.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
dales1454
Certified Associate Developer
over 11 years ago
Will be nice once the base product includes the ability to filter on array type fields like asignee. Until then, try this "=find(tostring(loggedinuser()),joinarray(touser(task_assignee_owner()),";"))>0" Works for me.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
moritzw
over 11 years ago
This works fine. I always thought loggedinuser() wouldn't work in report columns, but apparently it does.
One issue I still have though is if the task is assigned to a group the expression returns false even if I am a member of that group.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
moritzw
over 11 years ago
PS.: getdistinctusers() doesn't seem to work in reports
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
revat.anandsongkit
Appian Employee
over 11 years ago
Have you tried using the isusermemberofgroup() function?
forum.appian.com/.../Appian_Scripting_Functions
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
>