Retrieving records by using the record list method

The record list is a standard feature for accessing records in a database. You will use it most frequently at prompts where a form or file name is required. You enter the necessary information in the form and Database Manager processes the query by looking for similar records based on the values you entered. Search values from record lists can be made more efficient through the use of relational operators. Database Manager displays the records it finds in a record list.

Retrieve all records in a table

Example: Retrieve all records in the Manage CI form.

In this example, we execute a true query, which returns all records contained in the device.g form.

To retrieve all records in a table:

1. Click Tailoring > Database Manager.
2. Type =device in the Form field, and then click Search.
3. On the Manage CI form, click Search.
4. Click any record in the list of returned records to view the details.

Retrieve records within a range

Example: Retrieve all device records where the value of the Part Number field is greater than a character value of 500 and less than a character value of 1000.

In this example we execute a greater than (>) and less than (<) search on the device.g form to search part numbers where the value is greater than the number 500 and less than the number 1000.

Note: For a range query on numeric fields, use the Query window.

To retrieve records within a range:

1. Click Tailoring > Database Manager.
2. Type =device in the Form field, and then click Search.
3. On the Manage CI form, type >500 AND <1000 in the Part Number field.
4. Click Find.
5. Click any record in the list of returned records to view the details

Note: A device is also referred to as a Configuration Item (CI).

Related topics

When should I use the Query Window instead of the record list query method?
Record retrieval