This control provides querying for relational databases. When this control is selected, there appears an floating menu above or below it. Click Edit button from that menu to open the Query Designer.
Parameters
Will be updated.
Target Schema
Select one of the newly created or imported database schemas listed in this dropdown menu.
Target Table
Will be updated.
Include All Fields?
- Yes, include all fields always.
Fields
Will be updated.
Field
Will be updated.
Caption
Will be updated.
Formula
Will be updated.
Mapped XPath
Will be updated.
Order
Field
Will be updated.
Order Type
Will be updated.
- Ascending
- Descending
Criteria
Will be updated.
Field
Will be updated.
Formula
Will be updated.
- Count
- Sum
- Average
- Minimum
- Maksimum
- Average of distinct values
- Sum of distinct values
- Count of distinct values
Comparison
Will be updated.
- Equals
- Different
- Like
- Less than
- Greater than
- Less than or equals
- Greater than or equals
Value
Will be updated.
Condition
Will be updated.
- And
- Or
Ignore Values
Will be updated.
- Value,
Blocks
Will be updated.
Condition
Will be updated.
Sub Queries
Will be updated.
Data
Will be updated.
Row Id XPath
Will be updated.
Hierarchy Column
Will be updated.
Hierarchy XPath
Will be updated.