Oracle APEX 23 Course For Beginners

Oracle APEX 23 Course For Beginners
Oracle APEX 23 Course For Beginners

Tuesday 31 December 2019

Creating Kanban Board in Oracle APEX using HTML5 Drag n Drop Features



This Kanban Board is created in Oracle APEX and it allows you to drag and drop cards between different system development lifecycle (SDLC) tasks. This is not a plugin. It is built using HTML5 Drag n Drop standard features. The icons and pictures on the cards are fetched from database tables. When you drag a card from one SDLC step and drop it on another, an Ajax Callback process comes into action and immediately updates the shuffling in a backend table. Each task is provided as a link on the card that, when clicked, calls a modal page to update task details. Similarly, the plus sign that appears under each SDLC pane, lets you create a new tasks.


See Step-by-Step Tutorial on YouTube


SEE TRANSLATION OF THIS VIDEO IN YOUTUBE IN YOUR NATIVE LANGUAGE
  1. Click the Closed Caption icon (CC) under the video to turn it on. The turned on CC has a red underline.  
  2. Click the Settings icon beside the CC icon, and click the Subtitle/CC option.
  3. Select the Auto-translate option and then select the language of your choice.



2-Steps Authentication via SMS in Oracle APEX

The smart authentication enables application access using dual authentication methods. The first method is the conventional username and password combination. The second one is smart code authentication in which your smartphone is used. The second method is added to the first one to add an extra layer of protection to your app. Even if your username and password falls into wrong hands, they can't access the app, because they don't have your smartphone.  

When you run your application, it presents the conventional username and password for initial authentication. Once you are authenticated, a message containing 6 digit code is sent to your registered smartphone. A small text box pops up on the login page at the same time to receive the 6 digit code. Once this code is verified, you are landed on the home page. 

Try Live Demo: https://apex.oracle.com/pls/apex/f?p=2869







Shopping Cart in Oracle APEX With Drag N Drop and Click N Drop Functionality



Drag a product picture from the Products Catalog and drop it on the Shopping Cart interactive report. If you drop the same item again, its quantity and value are summed up. Clicking the delete icon in the Remove column removes the product from the shopping cart. Alternatively, just click the product image.






SEE TRANSLATION OF THIS VIDEO IN YOUTUBE IN YOUR NATIVE LANGUAGE
  1. Click the Closed Caption icon (CC) under the video to turn it on. The turned on CC has a red underline.  
  2. Click the Settings icon beside the CC icon, and click the Subtitle/CC option.
  3. Select the Auto-translate option and then select the language of your choice.


Customized Faceted Search in Oracle APEX

Oracle APEX 19.2 introduced Faceted Search, which allows you to apply filters to a classic report. The built-in faceted search page consists of a classic report region, showing search results, and a region of the new Faceted Search type, which holds the facets. The Faceted Search region is linked to the Classic Report region, and each Facet is linked to one of the Classic Report result columns.

I created this custom faceted search utility which contains different facets including a date range facet and is linked to an interactive report, which allows you to apply control breaks, aggregates, chart and group views, and pivot table.  

Try Live Demo: https://apex.oracle.com/pls/apex/f?p=2869:5








Monday 30 December 2019

Using Calendar in Oracle APEX to Manage Events


Oracle APEX allows you to add calendars to your application with monthly, weekly, daily, and list views. Calendar is based on the FullCalendar jQuery library and can only be customized through CSS. You can create a calendar based on a table or SQL query. During the creation process, you are prompted to select date and display columns. Once you specify the table on which the calendar is based, you can create drill-down links to information stored in specific columns and enable drag and drop capability.

Using the Calendar component you can:


  • Display calendar events on multiple views (Month, Week, Day, or List).
  • Render duration and non-duration based events.
  • Render events from external sources using web service calls or Google Calendar feeds.
  • Modify the start and end dates by dragging and dropping events on different dates. Drag and drop is only supported for local data sources, that is, database objects in the referenced database schema and not on external data sources such as a Google calendar.
  • Edit or add new events on calendar using forms by clicking either on events or empty calendar cell.
  • Use different CSS classes, developer can choose different styles for different types of events.
  • Share events using multiple formats (iCal, CSV, XML).
  • Enable tooltip to make it easier for users to have a quick look at details of each event.


To use the calendar, you need to prepare a SQL query with the following columns:

Start Date – the start date for events displayed on a calendar. It can include the starting time.

End Date – the column which holds the end date for events displayed on a calendar. If this attribute is specified, then the calendar displays duration based events.

Display – Holds the text displayed for events on a calendar.

CSS Class – the CSS class name to style the events displayed on a calendar. This column is optional.

Primary Key – primary key for the event. The column becomes necessary if you want to enable drag and drop feature.

Supplemental Information – additional information which is displayed in the List View and Tooltip. Use &COLUMN. syntax to show column values in HTML. Show Tooltip must be set to Yes in order for this supplemental information to be displayed in the Month, Week and Day views.






Try Live Demo: https://apex.oracle.com/pls/apex/f?p=2869:13







Display Data Dynamically In A Gauge Chart

In this tutorial, we will learn how to display customer's ordered data in a gauge chart dynamically. As you choose a customer name from ...