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
16 replies
Subscribers
4 subscribers
Views
17015 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
Reports
we want to display a grid report with task ID as task link and business data associated with each task.but we are able to get task id separately using queryprocessanalytics ,
suganyasrip
over 8 years ago
we want to display a grid report with task ID as task link and business data associated with each task.but we are able to get task id separately using queryprocessanalytics , my question is how to get the business data of that particular task or available task in grid report?
Any solution will be appreciated and Thank in advance.
OriginalPostID-235287
Discussion posts and replies are publicly visible
0
chetany
A Score Level 1
over 8 years ago
What do you exactly mean by Business Data of the Task? Do you mean the data submitted by the user on that task? If you mean that, such data is usually stored in a CDT or simple PVs. You can design your process report and include extra columns for specific PVs or CDTs. Then use the queryProcessAnalytics function to get that data.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
suganyasrip
over 8 years ago
Business Data means that whatever data populated from CDT to that Task form.Can you please provide me guidance on how to build own process report by adding extra columns from CDT(ie: Batch number,ID,Name) ? Because for my knowledge i think queryprocessanlalytics is having specific attribute related to the report. can i get any sample report or steps do that.(we are using 16.2 version)
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
abhinavg712
Certified Lead Developer
over 8 years ago
You can build a Task report ( Tasks per Process Model ) & select the required process model as the report context. Business data can be added to the same report using Data tab, adding new data and browsing to the required CDT fields to show up on report.
Please go over the below documentation and look for Configure the Report Options section for more details
forum.appian.com/.../Process_Reports.html
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
sikhivahans
over 8 years ago
@suganyasrip When you say that you need to access the business data associated with the task, please bear in mind that you would be able to access PVs(and the link mentioned by @abhinavg should help you) but not the ACPs associated with the User Input Task nodes.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
rajatm
over 8 years ago
If you have requirement to show business data which is stored in DB and not in PVs then you may create a CDT for all the data you wish to display which comes from queryAnalytics and queryEntity (DB table) . You will have to populate this CDT in the SAIL code and then display in the report grid / chart .
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
suganyasrip
over 8 years ago
@Abhinav and @sikhivahans As per your suggestion i got the customized report but when using the constant in queryprocessanalytics am not getting any data into that data subset .
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
sikhivahans
over 8 years ago
@suganyasrip Would you be able to provide the implementation details? That would quickly help us to identify the issue.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
suganyasrip
over 8 years ago
Sorry @sikhivahans cannot expose full implementation,for testing am using code in this format
with(
local!report: a!queryProcessAnalytics(
report: cons!demo_report,
contextProcessModels:"MyModel"
),
a!textField(readOnly: true, value: local!report)
)
Am getting the Result as :startIndex=1, batchSize=25, sort=[field=c0, ascending=true], totalCount=0, data=, identifiers=, name=demoreport, description=, columnConfigs={--List of fields in that report--}
My Question: How to Populate the Data from Report?Through ExpressionRule we need to convert to Data subset?
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Navajith K
over 8 years ago
@suganyasrip, Do you see data in the portal report when the process model in cons!demo_report is configured as the context?
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Navajith K
over 8 years ago
* Please read as process model with name "My Model" is configured as the context.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
>