I’m currently trying to create a dashboard in Application Studio that summarizes metrics in a grid given a time frame and an ID. To do this, I’m passing three parameters to a subquery in a BAQ to filter out the necessary data, including the start date, end date, and ID. A top level query is then used to aggregate the data for each ID.
However, I believe I’m having issues passing the parameters to the BAQ, as the grid populates, but with unexpected/unfiltered results.
I’ve read quite a few great posts on this, and have tried to follow their methods, but I’m not sure if maybe they’re not working because the BAQ parameters are being used in a subquery instead of the top level.
Please let me know if anyone has any advice, or maybe an alternative method to accomplish this! Thank you!
You’re definitely going to have to post more details of what you are doing for anyone to really help you I think. Passing in parameters should work just fine (although it is possible you’ve uncovered a bug), so I’m going to assume that you’re just missing something in your setup. Did you test the BAQ first? And does it give you want you expect? If you make a classic dashboard, does that give you what you expect?
The issue was myself and not Epicor at all, in the BAQ, I forgot to re-add the ID parameter to filter out IDs in a table after switching the table I was using . Thank you for your advice and I’ll try to include more info next time I make a post!
. Thank you for your advice and I’ll try to include more info next time I make a post!