I'm trying to run the ' "Execute Report with multiple filter"

smcgill over 10 years ago

I'm trying to run the ' "Execute Report with multiple filter" smart service but I'm not getting the output I require.
I need to show the following outputs from the report -
1) process name (text) 2) ppid (numeric) 3) invoice status code(text) 4) status date (date time)
the report is set with one filter on the process name to include certain types. There are extra cols in the report but they are not shown.
When I run without extra filters I only get the process name back! Any ideas why?

When I try to add a filter of an invoice status code of PAID using the ReportTextColumnFilter with the values set by script task to [columnName=Invoice Status Code, operation==, value=PAID] the node does not complete at all.

Any help would be gratefully received....

Discussion posts and replies are publicly visible

0 Patty Isecke
Appian Employee
over 10 years ago

Have you added the additional data points (2) ppid (numeric) 3) invoice status code(text) 4) status date (date time) ) to your report? forum.appian.com/.../Adding_Report_Data
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 smcgill over 10 years ago

I did at one point have all three added with the exception that the date time was defined in the report as a text field but this didn't make any difference! I would like to know what I'm doing wrong for future refence but I have since amended my report and model to use the regular Execute Process Report node which seems to work with multiple filters anyway!
I did find that the plugin only seemed to work when the parms where coded in the node and not via the CDT!
If anyone has any simple examples they would be most welcome!
Thanks for you help and interest
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel