Query

Name

• Can be set any name

• Name will not be visible in Clearion Web

Target Container

• Determines where the query widget will retrieve data

  • Main - the query widget will search for values on the Feature Table

  • Slider - the query widget will search for values on the sliders

Parameters

• Parameters represent Query modal fields

• Parameters can be added manually via Add Column

• Parameters can be added automatically via Generate Columns:

  • select an appropriate table

  • select all the necessary fields

Settings:

• Header Text - can be added any text which represents a column name

• Field - should correspond to a field in a table

• Width - can be set to any appropriate width. If set to 0 then width will be automatically adjusted

• Type - field type should be specified

• Lookup Key - lookup should be added if this is a lookup field

• Numeric Format - allows user to choose a specific way to display values of numeric fields. There are 3 available numeric formats:

  • Integer - X (a rounded number)

  • Float - X.X (for example- 1.2, 11.5, 10.0)

  • Double Precision - X.XX (for example- 3.30, 0.01, 5.50)

• Is Multi - determines if the field allows to select one or multiple options

• Is Async Search Field - if the checkbox is enabled, the associated input field will not display any dropdown options until the user begins typing. As the user types, options dynamically corresponding to the entered text will be presented in a dropdown list.

  Important Considerations:

  • This option is not applicable to static lookups or number type fields.

  • For table lookups, the values displayed in the dropdown will be drawn from the "Value" field as configured in the Table Lookup settings, rather than from the currently active input field.

  • Enabling this feature significantly optimizes lookup performance, especially when dealing with large datasets.

• Parameter - if specified displays an additional parameter for a field to make a query more specific:

  • contains

  • does not contain

  • equals

  • doe not equal

  • less

  • greater

  • less or equal

  • greater or equal

  • is null

  • is not null

  • between

• Is Active - determines if field is visible or hidden by default. If hidden, it can be selected in the Parameters tab

Query Tabs Order

• Enables customization of the order of the Query widget tabs

• The Query, Parameters, and Favorites tabs can be rearranged by dragging and dropping them in the left-side menu

• By default, the order is: Query, Parameters, Favorites

Chunk Count

• A configurable chunking system to enhance performance and scalability

• The chunks count system determines how many data chunks are loaded from the server, reducing client-side load

• The number of features per chunk is controlled by server settings

• This option is configurable via the widget settings form:

  • -1 >> loads all available data (unrestricted)

  • 1 or higher >> loads data in a defined number of chunks

  • 0 >> not valid

Favorites

• When the widget is configured, the studio user can create sets of favorite parameters that the Clearion Web user can use

Save

• Saves the configuration