Question
Closed
Passing Parameter Conditionally from section to report definition
Hi All,
Below Scenario
- Calling a Report definition from a Table. Report definition have filter condition which takes parameter passed from the Table
- In Parameter from that table tried following code @if(A == "","B","C") . if A is empty i need pass parameter as B else C. But I am getting syntax error.
- I have tried (A == "") ? "B": "C"
- I don't want to use Data Page and call activity to achieve this. Let me know if i can pass parameter conditionally. Please help with syntax
Thanks
***Edited by Moderator Marissa to update Platform Capability tags****
Posted: 3 years ago
Pegasystems Inc.
IN
Hi,
You can try using 2 tables with visibility conditions. In the first table, you can pass the parameter as B and can use the visibility condition as A==".In the second table, you can pass the parameter as C and can use the visibility condition as A!==".
Posted: 3 years ago
Updated: 2 years ago
Updated: 14 Jun 2021 7:38 EDT
Pegasystems Inc.
IN
Is it possible to set the property based on condition in the pre-processing Data transform of the sections' Flow action and use that property to pass as a parameter to the Report Definition?
Posted: 3 years ago
Pegasystems Inc.
US
If nothing else works, you can do this with a function alias. Set up a SQL CASE structure that checks if A is equal to "" and proceed accordingly. Use this FA in your filter condition.