Create and Switching To Defferent Theme in APEX and Create CHART

In this topic, you create a different theme and then switch to the new theme to make it the current theme.


Run the Application you created in the previous lab. If you were unable to perform the entire lab (or would like to reset your environment for this lab), you can perform the following:


• Run the /home/oracle/Desktop/solutions/apexp1_lab/deinstall.sql to delete the supporting database objects.
• Import the application instead from the /home/oracle/Desktop/solutions/apexp1_lab/f100.sql. Make sure you install the supporting objects.

Review the look and feel of the tabs. You want to utilize another theme. Click the Application button in the developer toolbar.




Click Shared Components.




Under User Interface, select Themes.




Click Create.




Accept the default and click Next.




Scroll down and select Theme 22 box or select the Theme 22 radio button and click Next.




Click Create.




The theme was created in your application. To switch to the new theme, click Switch Theme.




Accept the default 22. Bluejay and click Next.




A theme compatability comparison is displayed. Accept the default and click Next.




Click Switch Theme.




You can run your application to see the next theme. Click Run Page 1 icon in the upper right of the window.




Notice the look and feel has changed to the new theme colors. Select the Application button in the Developer Toolbar. In the next topic, you create a chart.

 

Creating a Chart

In this topic, you create a 2D pie chart that shows the number of tasks per project. Then, you convert this 2D pie chart into a 3D pie chart and make a couple of display settng changes. 


From the Application page, click Create Page.




Select the Chart page type and click Next.




Make sure Flash Chart is selected and click Next.




Select the Pie & Doughnut chart type and click Next.




Select 2D Pie and click Next.




Enter Tasks per Project Chart for both Page and Region Name and click Next.




Select Use an existing tab set and create a new tab within the existing tab set, enter Chart for Tab Label and click Next.




Enter Tasks per Project Chart for Chart Title, select Side From Left for chart Animation, select Solid Color for Background Type, enter #FFFFFF for Background Color 1 and select Bottom for Show Legend and click Next.




Enter the following SQL Query or copy the query from the /home/oracle/Desktop/solutions/apexp2_lab/chart.txt file. Then click Next.


select null link,
       p.project_name label,
       t.task_count value
  from (select project_id,
               count(*) task_count
          from tasks
         group by project_id) t,
       projects p
 where t.project_id = p.project_id



Click Finish.




Click Run Page.




The chart is displayed. Notice when you place your cursor over one of the slices in the pie chart, a popup appears. Click one of the pie slices.




Notice the exploded slice you clicked. You want to make some additional changes. Click Edit Page button in the developer toolbar.




Under Page Rendering, double-click the region Tasks per Project Chart.




Click the Chart Attributes tab.




Change the Chart Type to 3D Pie and click the Display Settings subtab.




Select Diamond for Marker, enter yellow for Background Color 1 and click Apply Changes.




Click Run.




The changes to your chart are displayed. Click the Application button in your developer toolbar. In the next topic, you create and use a dynamic action.