Show/Hide Toolbars

Filopto Help Manual

 

 

To select the Fields to display in the final result screen, you can select the result fields by clicking on the Result list icon beside the Display/Modify label.

 

AQFieldmodify

 

By clicking on the blue icons, the result Field Editor screen will appear.

 

AQResultfield2

 

Available fields tree shows fields available in data model. Fields are grouped as defined in the Structure Editor ; unclassified fields (i.e. not belonging to any group) are represented as the tree's root level.

 

To add a field,select it in the list and press AQAdd button. From the appearing menu select how would you like to add the field.

 

AQAdd2

Variants are:

as is:   the field is added as is; no formulas are applied

MIN, MAX, AVERAGE, COUNT, SUM:   the field is included as argument of the corresponding SQL aggregate function.

 

Calculated Fields

 

To create a calculated field, follow the next steps:

 

1.        Choose first field from the tree and add it to the list

 

2.        Choose second field form the tree; select the field you just added in the Result fields list

 

3.        Press appropriate menu option - depending on what you need.

 

4.        Using steps 2 & 3, you can add another field to the expression, like: field1+field2*field3-field4.

 

5.        To insert brackets, select the result field and click Expression cell. In the edited expression, fields are shown

as @1, @2,...,@n.

 

To remove a field, select it in the Result field list and press the appropriate option on the pop-up menu which appears when right clicking your mouse over the list of selected fields.

 

Sorting Fields

 

To add the field to sorting order, select it in the Result field list and right click your mouse button and choose the appropriate option from the pop-up menu.

 

You can change the sort order by right clicking on the sort grid and selecting the appropriate selection.

 

 

You can change name of the appearing field:  just select it and click Field Name cell.