Oracle Magazine, September/October 2017
Database Developer LOW CODE 5 In the tree view on the left side of Page Designer select New under Series 6 In the properties on the far right change Name to Average Employment 7 For SQL Query enter select avg employees state from employment group by state order by state 8 In the Column Mapping section choose STATE for Label and AVG EMPLOYEES for Value In the Label section set Show to Yes 9 In the component gallery at the bottom of Page Designer drag a Static Content region above the Employment region in the Page Layout area and drop it 10 In the properties on the right change Title to Legend in the Appearance section set Template to Buttons Container and in Source enter ORACLE MAGAZINE SEPTEMBER OCTOBER 2017 68 div id legend aria controls piechart linechart style height 25px div 11 In the left hand tree click Page 2 Chart at the top 12 In the properties on the right side of Page Designer in the JavaScript region for the property Execute when Page Loads include the contents of the apex_ lowcode_ legend js file which is part of the zip file for this article that you downloaded earlier 13 Click the Run icon in the upper right Your application should look similar to Figure 3 You now have an application with two charts and a custom legend Click the states in the legend to show and
You must have JavaScript enabled to view digital editions.