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
11 replies
Subscribers
4 subscribers
Views
8850 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
Reports
All Tasks Report
rishub
over 7 years ago
Hi All,
I need a report containing all active tasks. Right the report that gives all the tasks is either based on process model or User Context. Is there any way I can get all the Active tasks in a report?
Thanks
Rishu
OriginalPostID-259929
Discussion posts and replies are publicly visible
0
ashokv
A Score Level 1
over 7 years ago
You can create a process report by selecting 'Active' as default filter in the 'Filters' tab. You can then use a!queryprocessanalytics() function to display the data in a grid. You can use the below tutorial given in the Appian documentation
forum.appian.com/.../Task_Report_Tutorial.html
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Raviteja Varma Jampana
A Score Level 2
over 7 years ago
Hi Rishu,
You can create a task report for all tasks as shown in attachment. After creating report just filter it to Active tasks.
However to see all tasks you need to make sure that this report is being executed as Admin. Otherwise you cannot see all tasks if user who is running this report dont have security to processes in system. Let me know if you need help on this further.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
rishub
over 7 years ago
@ashokv, I need Active tasks Ashok , not Active processes.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
rishub
over 7 years ago
@ravitejavj, we need Users to be able to see that report & select tasks for any User so it can not be for Admin only.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Raviteja Varma Jampana
A Score Level 2
over 7 years ago
You can make task details visible to all users by executing queryAnalytics in script task and running it with user who ever designed process security. But selecting and opening tasks is not possible unless they have security to process.
So if you want to make them accessible to everyone you may have to provide manager level privileges to all users for all processes and also need to handle reassignment restrictions at task level, which is not recommended in all cases
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
rishub
over 7 years ago
Yeah, we don't want to go for this Approach. The use case is to enable the Users to be able to reassign the tasks in bulk.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
rishub
over 7 years ago
We need to know a simple way where we can get a report with all the tasks so that Users can filter a report by User & reassign the tasks.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Lakshmi Meyyappan
over 7 years ago
I would recommend using the user or process model context and passing in multiple values. That would mean either passing as context all users in your application's All Users group, or passing in a list of process models from your application that have assigned tasks. I'd recommend the second option of passing in process models, as the list of users could grow very large and reduce performance.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
rishub
over 7 years ago
@Lashmim, I did try to add all Users Group but the report takes conetxt of User only not Group. Also, if I use context of All the Users , the report saves it for all the Users once but then it modifies itself & takes only the default User.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Lakshmi Meyyappan
over 7 years ago
I would still suggest using the process models as context, but if you'd like to use users as context then try getting all users from the group with a function such as getdistinctusers(). Also, you can specify context in the report, but you can also specify when you perform the a!queryprocessanalytics() call. You'll want to pass in the getdistinctusers() as context inside the a!queryprocessanalytics() call in order to use that context in SAIL.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
>