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
7554 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
Reports
Business Data from Process Variable required in Process Report
kumaraveln
over 8 years ago
We have a process report in the context of a single process model. This process model has around 20 - 25 nested sub processes with human task(s) in it. Our requirement is to show a task report from where a group of users can view the status of various tasks (active, assigned and completed) and do reassignment if necessary.
Now we have no issue in showing the task related metrics like taskName, status, assignedTo, etc. But we also need few business process data (such as requestId, requestType, businessUnit) to be shown in the report (and option to use filters on them). All these process data are present in one particular CDT which flows across all the process models.
But here the issue is the name of process variable used in each sub process are different (since they were created by different people for various purpose and later integrated for this workf...
OriginalPostID-241727
Discussion posts and replies are publicly visible
Parents
0
kumaraveln
over 8 years ago
Hi sikhinvahans. I have tried this approach but the data is not coming in report. Here is what I have done,
1. Added a column for pm!id and executed the report.
2. Extracted unique process models ids. Got a total of 21.
3. Defined 21 constants of type Number(Integer) to hold these values.
3. Found corresponding process model names by id. Inspected each process model and identified the variable name used in it.
4. Built the rule as attached (last two process models does not even have any process variable of expected data type defined hence mapped null)
I tried both pasting this content directly in report column definition (not sure if there is any character limit here) / calling a rule from there and passing process varaiables as parameter. Both did not give any result. Also tried replacing fn!property with index function but no luck.
Even if the process variable is single, return type of displayvalue function is list. Does it make any difference for property function?
Good thing is report timeout issue did not happen at any point so tweaking the code a bit may get us close. Any suggestion ?
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
kumaraveln
over 8 years ago
Hi sikhinvahans. I have tried this approach but the data is not coming in report. Here is what I have done,
1. Added a column for pm!id and executed the report.
2. Extracted unique process models ids. Got a total of 21.
3. Defined 21 constants of type Number(Integer) to hold these values.
3. Found corresponding process model names by id. Inspected each process model and identified the variable name used in it.
4. Built the rule as attached (last two process models does not even have any process variable of expected data type defined hence mapped null)
I tried both pasting this content directly in report column definition (not sure if there is any character limit here) / calling a rule from there and passing process varaiables as parameter. Both did not give any result. Also tried replacing fn!property with index function but no luck.
Even if the process variable is single, return type of displayvalue function is list. Does it make any difference for property function?
Good thing is report timeout issue did not happen at any point so tweaking the code a bit may get us close. Any suggestion ?
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data