Creating lovs and editors
Download
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


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







Editors
Editors Page


Editors1
Editors Page

  • 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 Page

  • 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 Page

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