Report definition - list where parameter value contains the column value
For a report defnition, if we have a parameter pA and column source Col1, we can check if column value contains the parameter value as the substring by using filter condition
.Col1 contains param.pA
Now, we have a requirement to check if the parameter contains the column value, how to write the filter condition for this?
Thanks
Posted: 4 years ago
Posted: 4 years ago
Hi, I want to check if param.pA contains .Col1 value
Accepted Solution
Posted: 4 years ago
If you want to do that, you can use the pxFind function on the LHS to get the index of col1 in param.pA and check if it returns a positive integer or not.
Posted: 4 years ago
Many thanks, this worked!
I am not sure I understand. What you are trying to check with
.Col1 contains param.pA
is if value in Col1, in the database, contains the value in parameter pA. So we are checking the column's value with the parameter value.
Are you trying to check if the parameter contains a different column name?