Query Builder

The Query Builder page is used to build the query for a conversion object.

From the pane in the left, select the tables and fields to be included in the select clause.

Fields | Description
Columns | All the table fields are listed here for the selected table. Select the column for which the criteria is specified. The data types can be displayed along with each table name. Example, if you select the table dbo.Orders.CustomerID then the data type is Bit.
Criterion
Operators | The operators used in the select query are listed here. Select the operator according to the requirement. The Values field is enable or disabled, based on the selected operator.
Values | Specify the value for the criteria. You can specify the field name from the list.
Aggregate
Aggregate | The aggregate functions used in a select query are listed here. Select the function according to the requirement.
Order By
Order By | Specify the order in which the data must be sorted. The order can be in ascending or descending order.
Select Do
Select Do | Specify the dump code to be included for the selectdo clause in the query.

Commands | Description
Done | Saves changes to the query.
Cancel | Click Cancel to return to the Source page.

| Send Us Your Feedback About this Help Page