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.
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
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.
Parent topic: Builder help
About using the builder call editor
Data Field Modifier builder
Radio Button Group builder