Adding a SQL query

A query is a predefined search in the map. Infor Public Sector GIS includes a collection of standard queries that you can use, and you can also add your own queries. To define the selection parameters for a query you can use either SQL or an ad hoc report.

  1. In My Infor, click the Preferences button My Infor Preferences button to open the My Infor Preferences dialog box.
  2. Click the Infor GIS node.
  3. Click Add above the My Queries grid.
  4. Specify a name for the query in the Name field.
  5. Select SQL from the Type list.
  6. Specify the moniker of the component you want to query in the Component field. For example, for a work order query you would specify Hansen.WorkManagement.WorkOrder. You can click the popup button to browse through a tree that lists the available components.
  7. Specify the SQL statement for the query in the SQL field. The statement should select the primary key of the component being queried.
    The standard queries all use SQL, so you can refer to them for examples. You can't edit the SQL for a standard query, but you can click the Action button and select Duplicate Query to clone a standard query.
  8. To check your SQL statement, click the Action button and select Check Query.
  9. When you're finished defining your query, click Save.