Is there a way to have a cell or row of a BAQ change colors if it meets specific criteria? For example, if a row contains a value that is below zero, it automatically fills red with white text. Would be great to get some tips on how to do this. Thanks!
That’s typically what a dashboard is for. It’s the user interface intended to sit on top of a BAQ to make it more user friendly/interactive. You can perform highlighting of cells or rows using View Rules.
Make some bad queries and you get fun colors in your BAQ’s.
3 Likes
Thanks Chad. Are you referring to a dashboard in Data Discovery or in Kinetic itself?
I was referring to just a regular dashboard within Kinetic itself, but Data Discovery would be the same idea I suppose. You’re layering a UI on top of a query so that the user has more “finished” experience than the raw data.
If you deploy the dashboard and put it on a menu (as Dashboard-Assembly), you can then go into Customization Mode on the dashboard. That gives you the full set of Customization Tools. Use the Row Rules Wizard in the Customization to change the field. I believe you’ll have to use Epicor’s pre-set formats, there are four to my knowledge, that highlights the cell (or row) in RED (Error), YELLOW (Warning), GREEN (OK) or BLUE (Highlight).
It’s probably possible to get more detailed than that using code, but you can pretty simply use the wizards for a simple solution.
You don’t even need to deploy and then go into customize, you can set this all directly in the dashboard developer screen prior to deployment, that way you don’t have to apply a customization in menu maintenance.
1 Like
Good catch. I know the customization tools from Dashboard Maintenance is a subset of what’s available when working from the program itself (the assembled dashboard). I assumed Row Rules wasn’t there. Thanks for catching that!