When 1 then 'fa-check-circle-o u-success-text'
Warning: fa-exclamation-triangle u-warning-textįor each status column in my SELECT clause, I added a corresponding icon and description column:.Success: fa-check-circle-o u-success-text.Without the description column, this information will be inaccessible. This is very important, because we are changing from a discrete value in the report to an icon and a color. status_description - Description of the status icon, for accessibility purposes.status_icon - String representing the icon class and modifier class.To solve this specific problem for the dashboard, I selected two additional columns in the SELECT clause for each STATUS column: If you change the global success color in Theme Roller, the icon color will also be updated. What's nice about these colors is that they are coordinated with the Theme Roller in APEX. You can find these Universal Theme helper classes at -> Reference -> Color and Status Modifiers. The helper classes can be used to set the colors on any custom component. Shakeeb recommended I use Font APEX and the Universal Theme helper classes to solve this problem. You can learn more about the Universal Theme at, and you can learn more about Font APEX at. The Universal Theme in Oracle APEX 5.1 includes Font APEX, a drop-in replacement for Font Awesome, but with better graphics and more of them (courtesy of master graphic artist Bob Daly). Universal Theme is a responsive, versatile, and customizable user interface for your Application Express apps. In my example, 1 is a good condition, 0 is a warning, and -1 indicates that an action must be taken. The query of the Interactive Report was simply: I populated it with data, and then I created a new application with an Interactive Report on the table. Using a simple combination of SQL and Font APEX, this can be easily and elegantly solved!įor this example, I created a new table CITY_STATUSES But this time, I first solicited the opinion of Shakeeb Rahman, the Design Lead for Oracle APEX, and he provided me a better solution. I've implemented similar solutions in the past, selecting an image reference in the SELECT clause of my report query, and then referencing this image reference as the column value. While this example doesn't perfectly fit that description, it can be classified as a report that is summarized, and any elements which need attention are presented in a different color. Most people think of dashboards as a nice cockpit panel containing charts and graphics.
0 kommentar(er)
