Creating a query using the Infor Lawson Process Query Builder

The Infor Lawson Process Query Builder walks you through the process of setting up your query.

  1. Specify this information:
    Product Line

    Select the product line where the data will be retrieved from.

    Module Name

    Select the module that you want to use in your query.

    Table

    Select the table where the data will be retrieved from.

  2. On the Fields tab, specify the fields that you want to retrieve values for. Click the right arrow (>) to select fields.

    The Fields pane shows the fields from the table you selected in step 1. The values of the fields you selected will appear in the query.

    The Related Tables & Fields pane shows the related tables.

  3. On the Index & Condition tab, specify the index and condition to narrow down the data.

    • Indexes: Select an index you want to specify criteria for. A check mark appears beside the index when it is selected.

      Each index is pre-built with specific fields. To specify a value for a key, select the key first then click on the Value column corresponding to that key. (The cursor should appear.) Values should be defined in the same order as the keys. You cannot skip a key and move to the next one. Doing so will result to an error message during testing or when closing the builder.

    • Conditions: Select a pre-defined condition. A check mark appears beside the condition when it is selected. If a condition is selected, only the records meeting the condition will be retrieved.

    • Delimiter: Specify the delimiter to separate each column in the retrieved data. If not specified, the default delimiter is tilde (~). However, other delimiters can be used, with the exception of ampersand (&), comma (,), and question mark (?). The delimiter that you select cannot be included in the query results. For example, if the tilde (~) appears in the query result data, then an error will occur. You must use a different delimiter that is not included in the results.

  4. On the Criteria tab, specify the filtering criteria. Criteria can be specified even on related tables.

    To group multiple criteria, select all at once the criteria to be included and then click the Group Criteria button. (The grouped criteria will be enclosed in parentheses.) To ungroup, select any one of the criteria in the group and click Ungroup Criteria.

    Click the Delete button to remove a criteria, or click Delete All to remove all criteria.

  5. On the Test tab, test the query by clicking Test API.

    Alternatively, go to the URL link to test your query from a Web browser. Specify your login credentials when prompted.

    If any of the indexes or criteria values were defined as variables, the Variable-Value table allows you to specify the values for those variables for testing purposes. To specify a value, select the variable first then click on the Value column corresponding to that variable. (The cursor should appear.)

    The result of the query is displayed in the Test Results box.