In this video, you’ll create the home page of the sample database application, which is a dashboard that users see when they successfully access the application after providing valid credentials. The Home page contains six regions to display different summarized information. It uses a 12 columns layout to place these regions accordingly. Besides the application name and logo, the page carries the main navigation menu, which is used to move to other application segments. The navigation bar on the top right side allows you to log out of the application. By default, it displays the id of the currently logged-in user, along with a Sign Out link. The Feedback option on the Navigation bar provides a mechanism for end users to post general comments for application administrators and developers. You can add more options to this bar. The body of a page can have multiple regions that act as containers to display information from database tables. You can place buttons in regions that act as links and allow you to access other application pages to get further details. In addition to buttons, the page also contains text links to dig into the details of the summarized information. Using the options provided in the Developers Toolbar, you can switch to the Page Designer instantly and perform various other development tasks. The Install App option appears when you choose Progressive Web App (PWA) option while creating a new application. When users tap the Install App option, the application is opened in a standalone window, which is free of the browser's UI. You can also add a banner to your application.
What You’ll Learn
===============
- How to create dashboards in Oracle APEX web applications
- Adding multiple regions to a page to segregate content
- Use of 12 columns grid layout to arrange multiple regions on a page
- Create links to drill down into details
- Badge List, Pie Chart, and Bar Chart to display data in different graphical formats
- Summarized text information
- Using buttons to navigate to other application pages
Topics covered in this video
=======================
- Transform the default blank Home page into a dashboard to display summarized data
- Create bar charts
- Create a Pie chart
- Set chart labels and values
- Show and hide chart legends
- Define links on charts using link builder to access information on other application pages
- Create a badge list
- Create text links to access information on other Oracle APEX application pages
- Adding multiple regions to show different information on a single page
- Set region position on a page using "column" and "column span" attributes
- Specify data source for a chart using SQL query
- Show region icon and set region height and width
- Create a hidden item to store some value - for example, the first day of the current month
- Use of PL/SQL Expression
- Transform the column text field into a link
- Apply numeric format mask
- Specify parameters and pass on values to a target page using Set Items
- Use substitution string to access the value of a page item
- Reset pagination of an interactive report using RIR
- Change a chart's appearance using different types of colors
- Add buttons to regions to access other application pages
- Apply CSS at the user interface level
- Add a CSS file to an Oracle APEX application with APP_FILES
- Apply styling to a region using a class rule specified in the CSS file
- Hide page components with the Never Server-Side Condition
Download Source Code From Here:-
drive.google.c...
Create Free Workspace in Oracle APEX:-
• How To Create Free Wor...
The content of this video is taken from my book "Create Rapid Low-Code Web Applications in Oracle APEX"
www.amazon.com...
Негізгі бет Create Application Dashboard in Oracle APEX - Part 4
Пікірлер: 11