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)

 

Compatibility

Free Form	Responsive Form	Mobile

 

 

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 (The width field has been removed from Responsive Forms).

• From Left/Top: Adjusts the distance of the tool from the left and top (This field has been removed from responsive forms).

• 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.

• Number of List Rows: How many rows of data will be returned in the list is controlled from this field. When this value field is left blank, the list returns 100 rows of data by default. This value can be changed again on the Client screen.

• 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

You can submit an object's purpose or a targeted form at the list scope.

In this usage, we can get the information '$POctopodGridActiveColName$' by clicking (colon). This option will give us the domain name of the column that was clicked on in the list.

Let's examine Example Usages:

On the form page, we have a list and a field with the name of the selected value to which the column header selected in the list will be sent.

First of all, the action is added on the list by coming to the Studio screen. Added action When Row Selected - Value Update selected value field is updated with action.

By coming to the query field, SELECT '$POctopodGridActiveColName$' is written.

The action details are as follows.

The action is saved and the client screen is entered. Clicking on any cell on the list, after clicking, the cell's title will be displayed in the selected form field.

The Project Name cell was selected on the list and updated the Selected Value field to ProjectName.

The Project Code cell is selected on the list and the Selected Value field is updated to ProjectCode.

As a different usage, instead of getting the column heading of the selected cell, the value information in the cell can also be retrieved.

For this example, let's change the example we just made a little bit.

The name of the table used is WEB_YERELVERI table and the desired columns are brought into the list, especially UserTableID from the WEB_YERELVERI table.

When the row added to the list is selected, the "Update Value" action is selected and the query in it is changed.

SELECT 
'$POctopodGridActiveColName$'
FROM 
WEB_YERELVERI 
WHERE UserTableID='$PUserTableID$'

After the written action is saved, the client screen is displayed, the cell is selected and the field is updated. In this query process, the header name will continue to come, not the cell information. Action for this

Removing quotes in '$POctopodGridActiveColName$'.

As a result, the final state of the query is as follows.

SELECT 
 $POctopodGridActiveColName$
FROM 
  WEB_YERELVERI 
WHERE UserTableID='$PUserTableID$'

The query is saved again and the client screen is switched. When a row is selected in the list, the information inside the selected cell will be filled into the Selected Value field.

Note: In this example, the names of the fields in your list query should not be given ALIAS, and the field names should be used exactly.