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
Click the Closed Caption icon (CC) under the video to turn it on. The turned on CC has a red underline.
Click the Settings icon beside the CC icon, and click the Subtitle/CC option.
Select the Auto-translate option and then select the language of your choice.
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
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.
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
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 calendarbased 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 querywith 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.
CSSClass
– 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.
The word hacking has a bad reputation in the computing world. This term is generally used to break into computer systems and create havoc. Among developers, though, the term hack refers to a quick solution to a problem, or an intelligent way to get something done. And the term hacker is used for someone who is creative, and possesses technical chops to get things done. This book is an attempt to reclaim the word, and pass creative stuff on to the inexperienced. It exhibits professional approach to various problems you face while developing applications in Oracle APEX and provides quick ways to learn new things about the technology.
Oracle APEX is evolving and you get exciting new features with every new release to develop latest, data-centric web apps fast. The main objective of this book is to help you practically evaluate these features to polish your development skills. The topics covered in this book are not documented in APEX manuals. Not only the book provides pro tricks to develop professional-looking web apps, but it also saves the time you spend on the Internet to search these solutions.
This book is meant to provide a new way of perceiving Oracle APEX. Whether you are looking for a new technique to include in your application, a solution to a common problem, or just some insight into Oracle APEX, I am sure you will find the stuff provided in this book helpful and exciting.
Contents:
Advisor
Authentication
Authorization
Background Image
Button Styling Calendar
Camera Integration
Carousel Container Template
Cascading Style Sheet
Debugging
Drag ‘n’ Drop
Email – Sending from APEX app
Global Page
Google Maps Integration
Image Preview
Image Scaling in Interactive Report
Interactive Grid Looping
Logo
ORDS – Oracle REST Data Services
Page Templates – Universal Theme
Password Tricks
Quick Response (QR) Code
Report Templates – Classic Reports
Reporting in JasperReports
REST Enabled SQL
Search Content Interactively
Session, Session ID, and Session State Management
Single Sign-On and Social Sign-On (SSO)
Theme Roller – Style Your Application
Themes and Theme Styles
Tree with Checkboxes
Universal Theme – Upgrade
URL – Incorporating External Content
Web Source Modules
