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
4218 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
Reports
163178 - no subject - Has anyone had trouble with getting resu
ashleyb
over 9 years ago
Has anyone had trouble with getting results from a getportalreportdatasubet[] within a process model?
We are using it to get the task id's for user reassignmnet, when ran independently we get the results as expected. When ran as the sub process (from the parent process) no results are found.
Thinking it was a timeout issue we placed the the report within an expression rule but saw no differences.
Another weird thing is if we restart the process -and change no variables- it will return the variables we want.
Any suggestions?
getportalreportdatasubset(
reportId: cons!CAC_DELEGATIONS_EXCEPTION_PROC_TASKS_REPORT,
pagingInfo: topaginginfo(1,-1),
contextIds: {},
filters: {
{field: "3", operator: "LIKE", value: pv!DelegationProcessSubType_Txt},
{field: "7", operator: "LIKE", value: pv!originalAssigneeUsername},
{field: "9", operator: "EQUAL", value: "RM Exception Submission"}
}
)
OriginalPostID-163178
Discussion posts and replies are publicly visible
0
sikhivahans
over 9 years ago
@ashleyb I am afraid that it's a security issue. Could you run the node (that has the getportalreportdatasubset() expression) in the process as a designer and confirm if you are able to obtain the results without any restart? FYI, I haven't seen an issue till date while using getportalreportdatasubset in the process.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
jorgea999
over 9 years ago
As a workaround, could you use the execute process report smart service? I'm only mentioning this since you said you're doing this within a sub-process and it doesn't mention the use of task.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
sikhivahans
over 9 years ago
Execute process report might compromise the functionality from the perspective of filters and operator on filters (queryProcessAnalytics has OR and AND operators as well) because we need 3 different filters where as Execute portal report has only one filter. Though we can configure the filters on portal report, I think it's elegant and convenient to modify from rules.
Further I think that the issue (which could be probably because of security) should be sorted rather than planning for a work around because so far from my experience what I have observed is, getportalreportdatasubset (now replaced by queryProcessAnalytics) has a upper hand over Execute portal report smart service in terms of usability or re-usability.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
aayusha
Certified Senior Developer
over 9 years ago
Encountered this error once but found a work around to use the a!queryProcessAnalytics.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
ashleyb
over 9 years ago
We are on version 7.6, is the a!queryProcessAnalytics available on our version? Or is there a plug in we can instal?
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
ashleyb
over 9 years ago
Also to note this process is working with the getReportDataSubset to retrieve the task id's when the process finding tasks in portal - however it is not working when trying to find the task id's in tempo.
I have opened the security to all but to note it was working with the portal task id's with the restricted security.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
sikhivahans
over 9 years ago
@ashleyb a!queryProcessAnalytics isn't available on your version. It has been introduced in Appian 7.8 (Reference: https://forum.appian.com/suite/help/7.8/Appian_Release_Notes.html) and it is an OOTB feature which doesn't require any hot deployments like plugins.
I will take a look at your last comment shortly.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
ashleyb
over 9 years ago
***correctin -- there are no process id's being found in portal - however process tasks are being found in a seperate part of the process and were successfully reassigning before the security change.
Could this still be security related?
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
ashleyb
over 9 years ago
Unfortunately the security changes did not work.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
sikhivahans
over 9 years ago
@ashleyb Hi, I have gone through your comments. Could you please elaborate some more as I wasn't able to understand. It might be better to provide a step-by-step description of your observations so that we can try to replicate the same or give a solution if we have already experienced it?
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
>