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

varnikam over 8 years ago

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

Discussion posts and replies are publicly visible

Parents

0 Amitkumar over 8 years ago

If you are dealing with portal reports, your expression rule containing calls to database might not work. If that is not the case, and you are using Tempo report. I suggest you create a report using Report Builder by supplying the concerned data store entity in your case and see if data shows up. You can make use of Query Entity instead of Query Rule unless you need to show all columns data from that entity on report.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Amitkumar over 8 years ago

If you are dealing with portal reports, your expression rule containing calls to database might not work. If that is not the case, and you are using Tempo report. I suggest you create a report using Report Builder by supplying the concerned data store entity in your case and see if data shows up. You can make use of Query Entity instead of Query Rule unless you need to show all columns data from that entity on report.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data