Creating a Query to Drill Around Data

You can use API Builder to create a query for Drill Around data in Lawson applications. When you do this, you are creating an API call to the Lawson Drill servlet.

Specifying a Drill call

From any screen of the Lawson Design Studio, select Tools from the main menu (menu that runs along the top left of the screen) and click API Builder.

From the API Builder main page, click Drill.. The Drill query page appears.

Form clip: Drill-Around query page

Make selections for these items:

  • Product line (data area)

  • System Code

  • Form: This is the form that you want to run your inquiry against.

At the next form, make selections for Drill Around Paths and Required Drill Keys.

When you are finished specifying the query, click Build Query or Test Query. The Build Query option creates the data query and prints it in the bottom of the browser window. The Test Query option tests the API and sends the resulting XML code to a browser window. If the code is what you expected, you can copy and paste it into another application, such as a VB application or Crystal report.