Using date filtering in a map query

You will often want to filter the results of a query by date, such as looking up service requests that were submitted between certain dates. If a query supports date filtering, the map includes Date From and Date To fields where users can specify a date range.

You must also define a date filter for the query, which indicates which properties are used to filter records. The date filter for a SQL query is a WHERE clause that is added to the main SQL statement. You can use @DateFrom and @DateTo as parameters to represent the Date From and Date To fields in the WHERE clause. For an ad hoc report query, the date filter is one of the filters defined for the selected report.

  1. In My Infor Preferences, click the Infor GIS node.
  2. Enable editing in the My Queries grid and select the desired query.
  3. Select the Allow Date Filtering check box.
  4. Specify the filter in the Date Filter field under either SQL Query or Ad Hoc Report Query.
  5. Click Save.