Choosing Fields for the Query

The display on the fields tab is different depending on which data source you selected.

  • If your data source is an Infor Lawson application form, you see a list of field names in the format shortfieldname:LONGFIELDNAME. If the form contains detail line fields, a D: precedes the field name.

    Note: You can look up field names in Infor Lawson. The long and short field names appear at the lower left corner of the screen.
  • If your data source is the database tables, you see a list of all the fields in the database table you selected. You can select any field in a table. If you plan to search on a specific value in a field, ensure that you add the field to the Selected Fields list.

  • The Table Prefix Translation feature is designed to assist you in locating database tables and system codes. Specify any 3-character string into the Prefix field and press Tab. If there is a table name corresponding to the string, it will appear in the Translation field along with the system code the table belongs to.

Choosing Relations

You can also include fields in related tables by choosing the Relations button. Select any related table to display a list of related fields. When you select related fields, they appear in the Selected Fields list with a prefix that indicates which table they belong to.

Keep this information in mind when you select related fields:

  • To return any data from related tables, the primary table field on which the related fields are based must contain data. If the primary field is null, no related records are returned.

  • If you plan to use a specific value in a related field as a search criteria, the related field must appear in this Selected Fields list.

  • When you select related fields, it's a good idea to group fields from the same table together in the Selected Fields list. If you save your query and re-run it, it runs much faster if all related fields from the same table are grouped.

Note: All relationships that are defined in the database appear on the Related Tables window. You cannot use this feature to define your own relationships.