Conditional Search (Productivity Kit)

This workflow uses a configurable schema to build a complex SQL conditional query. It allows an administrator to configure specific searches for their use cases, by tailoring SQL queries to their needs.

Requirements

• VertiGIS Studio Productivity Kit with active service subscription
• Activity Pack Deployment
  The deployment of Activity Packs is described in this section.

Inputs

1. layer: string

   The name of the layer to be queried. If not found the model uri of the layer to be queried. (ex. "layer": "0b7c62a2-2bdd-46e2-b82a-9e6bbaa749c9"). Feature Layers and Map Image Layers are supported.

2. queryTemplate: string (optional)

   Template SQL query with tokens. Tokens are configured within each field and are replaced in the query with the user selection. Required if dynamicOrQuery is FALSE

3. dynamicOrQuery: boolean (optional)

   Allows for an automatically query to be created using any of the configured fields user's input. The query will be comprised of only "OR" clauses.

4. formTitle: string

   Title for the search form.

5. formDescription: string

   Description for the search form.

6. fields: object array

   An array of definitions for each field. The following properties are
   included:

   1. token: string (optional)

      Token that must be included in the queryTemplate to be replaced. Required if dynamicOrQuery is FALSE.

   2. id: string

      Field name in the layer.

   3. title: string

      Label for the field in the workflow.

   4. autoComplete: boolean

      Indicates if it's an autocomplete (true) or a dropdown (false).

   5. minLength: boolean (optional)

      The minimum length for user input to show AutoComplete suggestions. Default is 3.

   6. type: string

      Type of the field in the ArcGIS layer - Currently "string" and "number" are supported.

   7. prefixText: string (optional)

      If configured, displays text above the field.

   8. suffixText: string (optional)

      If configured, displays text below the field.

Behaviour

1. The search form will display all configured fields.
2. The administrator should configure the formTitle and formDescription to instruct the user on the type of search and conditions of the search.
3. By using prefixText and suffixText, the administrator can add more context and information for the queries, given the querie's complexity.

Configuration Example