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
7 replies
Subscribers
4 subscribers
Views
2291 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
Reports
155747 - no subject - I have created a process portal report i
zulfiqarp
over 9 years ago
I have created a process portal report in which I am displaying information about active process. How can I add current (unaccepted) task name, current (unaccepted) task assign to (users or group), and current task lag time information to the report? If this can be done in SAIL, please provide the sample code. Feel free to let me know if you have any questions in this regard. Thanks in advance...
OriginalPostID-155747
Discussion posts and replies are publicly visible
0
abhi.jana
Appian Employee
over 9 years ago
This is a list of data that you can display on your report
forum.appian.com/.../Process_and_Report_Data.html
I think you're looking for "tp!owner" "tp!assignees" and "Lag()"
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
abhi.jana
Appian Employee
over 9 years ago
and "tp!name" for the task name
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Poorna Guduri
A Score Level 1
over 9 years ago
Added to above, you need to save those detail in process variables. Because what ever the detail you want to show on process report, it must be available within the process instance. By giving "tp!owner/tp!assignees/etc" directly, you might not see the results in your report.
Make sure that you save the required values into process variables and configure them in your process report. That can solve your requirement.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Stefan Helzle
A Score Level 3
over 9 years ago
In a portal report with process context no task information is available. To get that data AFTER the task has been completed, save it to PVs. To get the data before that you need to use a portal report with task context like "Tasks per process model". In these reports you also have access to the process PVs.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
sikhivahans
over 9 years ago
@zulfiqarp The disadvantage of the PVs is that we can't observe the changes in the variables until and unless task submission takes place. I would like to suggest to strictly opt out of PVs as much as possible(atleast when we are making use of the dynamic metrics of task such as status, assignees etc). Also it requires addition of PVs as and when a new task is added, and deletion when a task is removed. Simply speaking it might not be a good idea to hold data in PVs which is already available to us in the form of Task metrics.
If I understand the question correctly, I would like to suggest to make a join on Process and its Tasks. You could identify all the tasks originating from the Process with the help of functionalities available in Appian as of now. The pseudo-code can be as follows:
Step - 1: Get the synchronous or asynchronous subprocess ids of the desired main process using the Shared Component 'Get Sub Process Details' available at https://forum.appian.com/suite/tempo/records/type/components/item/i8BCLGOdlMUpdGVqT-RV7oRg74uEGJO5yYYx2sxnURrc2O8fUDHwGC-JagCuOdubQ/view/summary and an array of process ids could be the resultant data. You can ignore this step if you don't want to get the task information from the subprocesses and the current process id is the only resultant data.
Step - 2: Using the process id(s) obtained in Step - 1, you can obtain the Tasks with the obtained process ids as filters(i.e. Tasks originated from the corresponding process ids) by querying the 'Current Tasks for Process' report with the help of a!queryProcessAnalytics() or getportalreportdatasubset(). (Note: a!queryProcessAnalytics() is highly recommended over getportalreportdatasubset())
The information obtained in Step - 2 is the resultant task information of the desired process(es) and this will always helps you to fetch dynamic data (in case of Active tasks) because we are only depending on the task metrics, and changes in the task metrics can be reflected as and when the SAIL interface is reloaded.
Coming to the implementation in SAIL, as the relationship between the process and task is not always one - one, you could provide a link to the process, and upon clicking a process, you could perform Step - 1 and Step - 2 and show the resultant data in a separate section.
I agree that this kind of approach consumes time to build, but to the best of my knowledge, it results you in a reusable and robust approach and will further doesn't create any work when a new user input task is added or removed in a process at any level.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
zulfiqarp
over 9 years ago
Thank you! How do you save the process variables of "tp!owner/tp!assignees/etc" of the active task that has not completed/accepted? Is there any tp! function that gives you current task/current owner/task assign date?
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
zulfiqarp
over 9 years ago
Thanks! @sikhivahans
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel