Create Setup to Display Records In an Order Calendar - Part 28

Tech Mining

23 Nov 202204:21

Summary

TLDRThis Tech mining video tutorial showcases how to create and utilize a calendar in Oracle Apex for displaying and managing orders. The calendar allows users to navigate between months, view orders on specific dates, and click to access order details on page 29. It also initiates a new order entry process when clicking on empty cells. The tutorial guides through setting up the calendar page, configuring SQL queries, and creating links for order details and new order entries. The video concludes with a test run of the application, demonstrating the calendar's functionality in month and list views.

Takeaways

📅 Oracle Apex features a built-in wizard for creating a calendar to display and report orders.
🔄 Users can navigate between months using the provided buttons at the top left of the calendar.
🔍 Clicking an order in a date cell directs users to page 29 to view the order's details.
📝 Clicking a blank date cell initiates the order wizard for new order entry.
🔄 The 'Today' button resets the view to the current system date.
📊 The calendar offers two views for orders: month and list views.
🛠️ A calendar page can be created instead of starting with a blank page, using the provided SQL query.
🔑 The 'Display Column' specifies which column's data is shown on the calendar.
📅 The 'Start Date Column' attribute determines the date used for placing calendar entries.
🕒 The 'Showtime' attribute controls whether the time portion of the date is displayed.
🔗 Creating links allows users to drill down to order details or enter new orders from the calendar.
📝 The 'Save Page' button is essential for saving progress in the application.

Q & A

What is the main topic of the 'Tech mining' video?
-The main topic is learning how to display and report orders in a calendar using Oracle Apex.
How can users switch between different months in the calendar?
-Users can switch between months using the two buttons provided at the top left of the calendar.
What happens when an order is clicked in a date cell?
-Clicking an order in a date cell takes the user to page 29 to see the order's detail.
What action is initiated by clicking a blank date cell?
-Clicking a blank date cell starts the order wizard for new order entry.
What does the 'today' button in the calendar do?
-The 'today' button brings the calendar back to the current system date.
What are the two view options available to view orders in the calendar?
-The two view options are month view and list view.
How can an individual test the provided SQL query?
-An individual can test the SQL query using SQL commands to see its output.
What does the 'display column' specify in the calendar configuration?
-The 'display column' specifies which column's data to be displayed on the calendar.
What is the purpose of the 'start date column' attribute in the calendar?
-The 'start date column' attribute specifies which column is used as the date for placing an entry on the calendar.
What does the 'Showtime' attribute determine in the calendar display?
-The 'Showtime' attribute determines whether the time portion of the date should be displayed, affecting the week and day views on the calendar.
How can a link be created to drill down to the order details page when an existing order is clicked?
-A link can be created by setting properties in the 'view edit link' attribute, which will drill down to page 29 to show the order details when clicked.
What is the purpose of the 'create link' property mentioned in the script?
-The 'create link' property is used to create a link that calls Page 11 to enter a new order when a user clicks an empty calendar cell.
How can users ensure their progress is saved while working with the calendar page?
-Users can save their progress by clicking the 'save page' button.
What should users do if they do not see orders in the calendar when they open the reports page?
-If orders are not visible, users should use the previous and next buttons to switch back and forth between months.
How can users view the current month's orders in list view?
-Users can click the 'list view' option to see the current month's orders in a list format.

Outlines

00:00

📅 Introduction to Calendar in Oracle Apex

This paragraph introduces the viewers to the Oracle Apex feature for displaying and reporting orders in a calendar format. It explains the use of two buttons for navigating between months and how orders are displayed in date cells. Clicking an order leads to page 29 for detailed views. Blank date cells initiate the order wizard for new entries. The 'today' button is highlighted for quick navigation to the current system date, and the calendar offers different views for order display: month and list views. The paragraph also mentions creating a calendar page and provides a link to an SQL query file for further exploration.

🛠️ Setting Up the Calendar Page in Oracle Apex

This section details the process of creating a calendar page in Oracle Apex. It describes setting the display column for the calendar and the start date column for placing entries. The paragraph explains the use of the 'end date' attribute for duration-based events and the 'Showtime' attribute for time display. The creation of a page is finalized with the 'create page' button, and the attributes tab is used to set up links for order details on page 29 and for initiating new orders on page 11 through clicking empty calendar cells. The importance of saving progress is emphasized.

🔍 Testing the Order Calendar Functionality

The final paragraph focuses on testing the newly created order calendar functionality. It guides the user to run the application and navigate to the reports page to interact with the order calendar card. The paragraph instructs on using the previous and next buttons to switch months and clicking name links to drill down into order details on page 29. It also explains how clicking a blank date cell starts the order wizard for new entries, noting that the new order's date is set to the current system date regardless of the clicked cell. The paragraph concludes with instructions on viewing orders in list view and thanks the viewers for watching.

Mindmap

Keywords

💡Tech mining

Tech mining refers to the process of extracting valuable insights from technological data, often using software tools and techniques. In the context of the video, it likely refers to the educational channel or series that focuses on teaching technical skills, such as using Oracle Apex to create calendar applications.

💡Oracle Apex

Oracle Apex is a low-code development platform that enables developers to build scalable and secure enterprise apps. It's integral to the video's theme as it is the platform used to create a calendar for displaying and reporting orders.

💡Calendar Wizard

The Calendar Wizard in Oracle Apex is a feature that assists users in generating a calendar interface. In the video, it is used to create a calendar page that displays orders on specific dates.

💡Order

An order in this context refers to a request or instruction for goods or services. The video explains how to display and manage these orders within a calendar view in Oracle Apex.

💡Date Cells

Date cells are individual units within a calendar grid that represent specific dates. In the video, placed orders are shown in their respective date cells, and clicking on these cells allows users to view order details.

💡Page 29

Page 29 is a specific page within the Oracle Apex application that is mentioned in the script. It is the destination page for detailed views of orders when a user clicks on an order in a date cell.

💡Order Wizard

The Order Wizard is a tool or process within Oracle Apex that guides users through the steps of creating a new order. In the video, clicking a blank date cell initiates the Order Wizard for new order entry.

💡Today Button

The 'Today' button is a feature in the calendar that allows users to quickly navigate back to the current system date. It is used in the video to demonstrate how to reset the view to the present day.

💡List View

List View is one of the options to view orders in the calendar, presenting them in a list format rather than a calendar layout. The video mentions this as an alternative view to the month view.

💡SQL Query

An SQL query is a statement used to manipulate or retrieve data from a database. In the video, a specific SQL query is used to concatenate order values to customer names and present them in a specified format.

💡Showtime Attribute

The Showtime attribute in Oracle Apex determines whether the time portion of the date should be displayed. In the context of the calendar, setting this attribute to 'yes' allows for week and day views to be shown.

💡Create Page Button

The 'Create Page' button in Oracle Apex is used to finalize the creation of a new page in the application. In the video, it is clicked to complete the wizard for creating the order calendar page.

💡Link Properties

Link properties in Oracle Apex are used to define how links behave within the application. The video describes setting these properties to create links that either drill down to order details or initiate new order entries.

Highlights

Introduction to displaying and reporting orders in a calendar using Oracle Apex.

Oracle Apex has a built-in wizard for generating a calendar.

Calendar navigation with buttons to switch between months.

Orders are displayed in respective date cells on the calendar.

Clicking an order in a cell leads to page 29 for order details.

Blank date cells initiate the order wizard for new order entries.

The 'today' button resets the calendar to the current system date.

Calendar offers two views: month and list views for order display.

Creating a calendar page instead of a blank page in Oracle Apex.

SQL query file provided for testing in SQL commands.

Order value is concatenated to each customer's name in the SQL query.

Specifying the display column for the calendar.

Defining the start date column attribute for calendar entry placement.

End date attribute for displaying duration-based events.

Showtime attribute to display the time portion of the date.

Creating a link to drill down to the order details page.

Creating another link to call Page 11 for new order entry.

Testing the application and navigating the order calendar.

Using the list view option to see orders in a list format.