We are encountering an issue where we are trying to fetch data through query rule and displaying the same in report.

Hi,

We are encountering an issue where we are trying to fetch data through query rule and displaying the same in report. In the expression rule it works fine and returns the correct output whereas in report, looks like the same expression doesn't work. Does anybody have any idea if the query rule works in report or not?

Currently, we are on 7.5 and the issue is consistent in both our test and prod environment.

Thank you in advance,
Varnika

OriginalPostID-192365

  Discussion posts and replies are publicly visible

Parents
  • We are trying to display a field called Minor Account type via query rule on Portal report. So in the report, if we use query rule - rule!ODR_Account(pv!AccountNumber).Minor_Account_Tp and pass Account Id to it, it returns no value and that particular column is showing all empty in the report but if we write the same expression in expression rule, it works and returns the desired output.
Reply
  • We are trying to display a field called Minor Account type via query rule on Portal report. So in the report, if we use query rule - rule!ODR_Account(pv!AccountNumber).Minor_Account_Tp and pass Account Id to it, it returns no value and that particular column is showing all empty in the report but if we write the same expression in expression rule, it works and returns the desired output.
Children
No Data