IP Designer Series – Lawson Query Node

The Lawson query node can be used to query Lawson data using the DME format.  In the properties of the node, click “Build” to build your query.  Select the product line from which you are trying to get the data.  Select the module and the table name where the data resides.  Choose the fields that you want to see.  You will also have an opportunity to choose related fields from other tables (i.e. a description from a parent table).  You can also use an index and provide keys for your query, using either hard-coded values or an IPA variable.  On the Criteria tab, you can select other fields besides key index fields to narrow your results.  You can use the Test tab if you don’t have any variables in your query.