creating lovs and editors
Download
Skip this Video
Download Presentation
Creating LOVs and Editors

Loading in 2 Seconds...

play fullscreen
1 / 20

Creating LOVs and Editors - PowerPoint PPT Presentation


  • 61 Views
  • Uploaded on

Creating LOVs and Editors. Objectives. After completing this lesson, you should be able to do the following: Describe LOVs and editors Design, create, and associate LOVs with text items in a form module Create editors and associate them with text items in a form module. LOVs and Editors.

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'Creating LOVs and Editors' - kalei


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
objectives
Objectives

After completing this lesson, you should be able to

do the following:

  • Describe LOVs and editors
  • Design, create, and associate LOVs with text items in a form module
  • Create editors and associate them with text items in a form module
lovs and editors
LOVs and Editors

Editor

Text item

Text item

Text item

LOV

Supporting data

record group

lovs and editors1
LOVs and Editors
  • LOVs
    • List of values for text items
    • Dynamic or static list
    • Independent of single text items
    • Flexible and efficient
  • Editors
    • Override default editor
    • Used for special requirements such as larger editing window, position, color, and title
    • System editor available as an option
lovs and record groups
LOVs and Record Groups

Text item

Text item

LOV

LOV

Record group

Record group

based on

static data

Query-based

record

group

Record group

OR

SQL

Database

slide6
Customers

LOV

name

id

phone

city

Customers

record group

LOVs

S_CUSTOMERtable

SELECT name, id, phone, city

FROM s_customer

ORDER BY name

lov queries
LOV Queries
  • Avoid very large queries—use restrictions.
  • Use column in LOV to validate user input—place this column first in SELECT list.
  • Define return items later, or use optional INTO clause.
  • Use optional WHERE, GROUP BY, and ORDER BY clauses.
lov properties
LOV Properties

Width

(X,Y)

LOV

Automatic

Select

Height

Column Mapping

FilterBefore

Display

?

Automatic

Skip

Return Items

Automatic Display

lov properties1
LOV Properties

Automatic

Column Width

LOV

Automatic

Position

Column Mapping

Return Items

lov column mapping
customer.name

customer.id

customer.phone

customer.city

Phone City

809-352689 San Pedro De

1-415-555-6281 San Francisco

91-1031 New Delhi

52-404562 Nogales

Customers

LOV

Hidden columns

name

id

phone

city

Customers

record group

LOV Column Mapping

S_CUSTOMER table

SELECT name, id, phone, city

FROM s_customer

ORDER BY name

editors1
Editors
  • Associate one of three types of editors with a text item.
  • Set text item’s Editor property to one of the following:
    • Null (default Form Builder editor)
    • editor_name (customized editor)
    • SYSTEM_EDITOR (external editor)
summary
Summary
  • LOVs and editors are form objects.
  • LOVs and editors can be shared across text items.
  • There are three steps to implement an LOV.
  • Text items can use the default editor, a custom editor, or a system editor.
practice 7 overview
Practice 7 Overview

This practice covers the following topics:

  • Creating an LOV and attaching the LOV

to a text item

  • Creating an editor and attaching the editor

to a text item

ad