I am trying to query using Query Process Analytics to a task report containing all active task for a given process context.
And I am applying a query filter to fetch any null values from the report ( basically if a column field "c10" is null or not).
Considering c10 data is coming from a PV variable , if i try to filter using a non - blank data it is working. But while checking for null values , it does not retrieve the actual null values output.
So if anyone could help me on this issue would be great.
Do you have the ability to add a new column to the task report? You should be able to set the column definition to do the null check on the data from the original column, and pass back (for example) a Boolean - so you'd call that column "isNameNull" and when c10 is null, have it pass back a TRUE value. Then your QPA call should be able to just check for this.
It worked . I created a new column in the report and accordingly managed it in the QPA. Thanks a lot
Great, thanks for confirming.
Discussion posts and replies are publicly visible
© 2020 Appian. All rights reserved.