Portlet Factory, Version 6.1.2

---

 

Lookup Table builder

Use the Lookup Table builder to perform a database query that returns results you can include in a page control, for example, a select control or a radio button group.

This builder can also be used to integrate arbitrary name and value pairs into a result set. This enables you to populate a list with a choice not included in the results returned from the database. You might want to do this to include an "any" or a blank option in the list of choices.

This builder is particularly useful when you are building a search form that will query a database. You can use this builder, in conjunction with the Data Field Modifier builder, to create a form that presents the user with list choices based on elements in the database the form is querying.

You can also use the Service Operation and Lookup Table builders when you want to add caching to your Model.

 

Quick tips

Build a quick working database

During development, use an XML list structure to represent the query results you expect this builder to return. This will allow you to develop forms without requiring a live connection to the database.

Avoid Escape Characters

Do not use an escape character in front of quotes in SQL statements. For example, do not use:

select count(*) \"Count\" from mytable

Instead use:

select count(*) "Count" from mytable 

 

Using the Database Explorer

Use the Database Explorer if you need assistance in creating an SQL statement. You can browse the database and construct the SQL statement on-the-fly. This is particularly useful if you are not an expert in using SQL. As you specify various inputs to the Explorer, you build a statement that can then be edited or directly applied to the SQL Statement input.

• About using the builder call editor

  The builder call editor allows you to specify all the input values to a builder call.

• Lookup Table builder inputs

  This topic describes the types of sources from which the Lookup Table builder can access data.

• Using lookup tables with other builders

  A lookup table created by the Lookup Table builder can be used by other builders.

• Using resource bundle data

  There are two techniques you can use to incorporate resource data as a Lookup Table. The technique you choose depends on your data formats and on the availability in the model of a Localized Resource builder.

• Lookup Table builder data formats

  This topic describes the data formats used with the Lookup Table builder.

• Objects created by the Lookup Table builder

  This topic describes the methods created by the Lookup Table builder in the WebApp.

• Populating controls on a query form

  This topic describes the steps to follow when you create a form that includes a select list populated with relevant database choices.

• Data Field Modifier builder

  Use the Data Field Modifier builder to modify one or more fields created by a Data Page builder call.

• Radio Button Group builder

  Use the Radio Button Group builder to create a set of radio buttons on a page.

• Select builder

  The Select builder adds a <input type=select/> tag to one or more pages in the model.

Parent topic: Builder help

---

Library | Support |