List

To use List, drag and drop it onto the canvas from the toolbox.

List tool icon at Toolbox

 

How it looks like on the Canvas

 

How it looks like on the Canvas (Expanded view)

 

Remarks

This tool is triggered with Update Value operation.

 

Properties

Properties of the form tool;

 

• Name: The name of the tool is written here.

• Text Size: Sets the size of the tool.

• Help Text: It is the text that is entered for comment when the mouse is placed on the tool.

• Number of locked columns: It is possible to fix (lock) the columns in the list to the left. (Later, during the use, the Show column list option in the list is activated and the desired columns can be locked or unlocked.)

• Height/Width: Adjusts the height and width of the tool.

• From Left/Top: Adjusts the distance of the tool from the left and top.

• SQL Query: The data to be listed is written to the SQL query. In the SQL query of the field you want to hide in the list, the beginning of the field name | mark should be added. For example; [| Name]. To make a modifiable field in a list, a $ sign must be added to the field name in the SQL query. For example, [$ Name]

• Color Style (Area | Criteria | Value | Type | Colors | Cell (0-1)): The specified color is applied to the line or area according to the specified area information.

• Sub Total (Field | Operation (count, sum, min, average) | Text): List makes gold subtotal information visible.  For example; Quantity | sum | Quantity Total is the subtotal of quantities.

• Hide column heading: Hides the column headers in the report

• Fit horizontal: Fits the tool to the full screen on the user’s screen.

• Pin Right: Pins the tool to the right.

• Display: Makes the tool not appear on the screen.

• Detail Button: Adds a detail button to the lines in the report.

• Column Width Auto: Columns are automatically fitted if this feature is active and the user has not registered a view.

• Auto Extension: Allows the list to expand as data arrives.

• Paging: Allows fast loading of multi-line data.

• File Menu: Allows downloading and viewing of files to be listed in the list. The data in the XPODA_FILES table needs to be fetched in the list and the FileID field must be present.

Events

• When the row is changed: Assign an “Action” as on row value changes handler. For more information please click here.
• When double-clicked on row: Assign an “Action” as a double click handler. For more information please click here.
• Detail is opened: Assign an “Action” as on detail opens handler. For more information please click here.

 

 

Example Used

To use the list tool, an update value is required. This operation on a button; clicked an area; when the value changes or the form we want; we can add when the form is opened. As in the above screen, the operation indicates which operation will take place after the operation has taken place. To display the values ​​of the list as an operation, we need to select the update value operation. The list should be selected as the value field so that the operation will update. After selecting and saving the properties of the operation, the list will be displayed when the form is opened.

Let’s write a query with staff names and company names as an example of list usage.

 

 

Another example;

Firstly, list tool is triggered with Update Value operation.

 

Create a query with the aid of SQL Wizard, here “ UserTableID “ does not seem in the List.

 

     

Client view on screen

 

If you want to see “ UserTableID “on the List, you must give an alias.

Client view on screen

 

If you want to give a color according to criteria, you must use Color Style property. Here (in below);

The first field represents the area name in your query. If  the area has an alias, you must use it. Second field represents a criteria as <, ==, > , != .

The third field represents the criterion value. Fourth field represents the color area, that 1 is the background, and 0 is text color.

The fifth field represents the color as HEX or RGB or RGBA or Color  Name formats.

Client view on screen

 

If you want a calculation for Count, Sum, Min, or Average, a numeric value is calculated in Sub Total property.

The first field represents the area name in your query. If the area has an alias, you must use it.

The second field represents the operation for the calculation.

The third field represents visible text, you can write anything here.

 

This calculation seems at the bottom of the list.

Client view on screen