Report Definition Displays all the records
Hi
I am sourcing a report definition in a table layout. I am using report filter to display only particular records. whenever the filter condition fails all the records are fetched. i dont want to fetch anything if filter condition fails. Is there a way to attend this??
Accepted Solution
CA
Pegasystems Inc.
FR
Hello,
Well I guess the best approach would be to avoid failure of the filter condition. What sort of condition is it? On what Pega version?
Infomatics corp
IN
Hi
I am using pega 8.2.1
My Report Definition has a filter condition where Registration_no is equal to Temp_page.Registration_No. temp is a data page stored and sourced from the clipboad page.
Accepted Solution
CA
Append another condition with an "OR" so that it's always untrue. So whenever rest of the conditions fail only that untrue condition would be evaluated and it won't return any results. e.g.
Existing conditions: age < 56 OR/AND salary > 20000 OR/AND
Untrue conditions: address equals "MARS planet"
Final conditions: (age < 56 OR/AND salary > 20000 OR/AND) OR address equals "MARS planet".
Even though it's not optimal, since above untrue condition will be evaluated everytime you query, it's your way around at the moment.
Infomatics corp
IN
Hi Nikhil
Thanks for the reply. I tried this solution and luckily it works for me.
Thanks
Append another condition with an "OR" so that it's always untrue. So whenever rest of the conditions fail only that untrue condition would be evaluated and it won't return any results. e.g.
Existing conditions: age < 56 OR/AND salary > 20000 OR/AND
Untrue conditions: address equals "MARS planet"
Final conditions: (age < 56 OR/AND salary > 20000 OR/AND) OR address equals "MARS planet".
Even though it's not optimal, since above untrue condition will be evaluated everytime you query, it's your way around at the moment.