Create Setup to Display Records In an Order Calendar - Part 28
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
📅 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
💡Oracle Apex
💡Calendar Wizard
💡Order
💡Date Cells
💡Page 29
💡Order Wizard
💡Today Button
💡List View
💡SQL Query
💡Showtime Attribute
💡Create Page Button
💡Link Properties
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.
Transcripts
a very warm welcome to Tech mining
in this video we'll learn how to display
report orders in a calendar Oracle Apex
includes a built-in wizard for
generating a calendar
using these two buttons provided at top
left we can switch between months
the placed orders are displayed in
respective date cells clicking an order
in a cell takes us to page 29 to see its
detail
[Music]
foreign
clicking any blank date cell will start
the order wizard to take new order entry
foreign
this today button brings us back to the
current system date
this calendar also offers two options to
view orders in different views month and
list views
let's create this segment
this time we are creating a calendar
page instead of a blank page
[Music]
foreign
is provided in description of this video
by opening part 8 folder you'll get the
SQL query file used
in this query order value is
concatenated to each customer's name and
is presented in specified format U is an
individual can test this query in SQL
commands to see its output
foreign
[Music]
this display column specifies the column
to be displayed on the calendar while
the start date column attribute
specifies which column is to be used as
the date to place an entry on the
calendar
if this end date attribute is specified
the calendar displays duration-based
events this Showtime attribute specifies
whether the time portion of the date
should be displayed the week and day
views will be displayed on the calendar
only when Showtime is set to yes
click the create page button to finish
the wizard
click the order calendar region in the
attributes tab
click this view edit link attribute and
set the following properties to create a
link
this link will drill down to the order
Details page page 29 to show the details
when the user clicks an existing order
[Music]
foreign
[Music]
click this create link property and set
the following properties to create
another link this property is used to
create a link to call Page 11 to enter a
new order when the user clicks an empty
calendar cell
save your progress by clicking the save
page button
that's it let's test our work
run the application
open this reports page click this order
calendar card
if you don't see orders in the calendar
use these previous and next buttons to
switch back and forth switch to any
month for example May
click any name Link in the calendar
report to drill down to browse order
details in page 29.
[Music]
click any blank date cell this will
start the order wizard to take new order
entry note that a new order is created
in the current date irrespective of the
month and view or the date cell you
clicked by clicking this today button it
brings us back to the current system
date
by clicking this list view option we'll
see the current month order in list View
thanks for watching
[Music]
Weitere ähnliche Videos ansehen
5.0 / 5 (0 votes)