27544 - no subject - On March 15th I reported having issues w

mjmallet over 12 years ago

On March 15th I reported having issues with a report and a having a definition (script) that wasn't being displayed if the "Include data from sub-processes" was set to Yes. I just found that the issue is being caused by the "isnull()" and sub-process set to "yes". This script is always returning "not null".

=if(isnull(pv!variablename),"null","not null")

As a work around I put the sub-process to "No" and added my sub-process name in the Report Context along with the main process. Then my isnull() is working....

Discussion posts and replies are publicly visible

Parents

0 Eduardo Fuentes
Appian Employee
over 12 years ago

When you enable the "Show data from sub-process" option, the data returned by the variable is an array. For instance, if you have pv!myColumnA on both, the parent and the child, the values from both the child and the parent for this pv, are returned as an array, for instance, valueFromParent;valueFromChild. Therefore, if there are no values, the returned result cannot be null; it's an empty list, therefore, when enabling this option the right check would be =if(length(pv!variablename)<1,"null","not null")
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Eduardo Fuentes
Appian Employee
over 12 years ago

When you enable the "Show data from sub-process" option, the data returned by the variable is an array. For instance, if you have pv!myColumnA on both, the parent and the child, the values from both the child and the parent for this pv, are returned as an array, for instance, valueFromParent;valueFromChild. Therefore, if there are no values, the returned result cannot be null; it's an empty list, therefore, when enabling this option the right check would be =if(length(pv!variablename)<1,"null","not null")
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data