This action allows you to display the values entered in the SQL Query field in list format. Thanks to the action types added to the form, the values in your query are opened directly as a new form page. A separate form page is not needed for this operation.
Open Form List Action in Property Panel
Features
Condition:Specifies how to open the new form.
In the same tab: Opens in the same tab,
In new tab: It opens in a new tab,
In new window: Opens in new window
Description: Description of the action is written. This description is used to give reference to the developer.
List Heading: The form title of the list to be opened is entered in this field. You can give your form a title of your choice.
Value Area: Select the value areas where the listed data will be loaded. When the list is double clicked, the related data is loaded into this field. If you want all fields in the form to be filled according to this row when you double click on a row from the list, you need to select All Forms from the value field.
SQL Query: Write the SQL query of the data to be listed. The wizard can be used to write the query.
Selection Filter (Field|Criteria|Value): Prevents adding rows to the table or list according to the specified field and value information. For example; With Quantity |! = | 0 filter, you cannot select from the list for records with quantity 0.
Sub Total (Field|Operation(count, sum, min, average)|Text): This is the field where the total operation is performed according to the specified field information. In this field, operations such as quantity, sum, min value and average value can be performed.
List Value Area : After the selection is made from the list, the information about which field will be taken in the list is written.
List-ID Field: The ID information in the main form matches the ID information of the list to be opened.
List Type Field: The form type information in the main form matches the form type information of the list to be opened.
Text Size: Edit the text size of the form to be opened.
Mapping: The list on the form is mapped with the field information of the form to be opened.
Closing Action: When the opened form is closed, the action on the form is selected for the action to be taken.
Fullscreen: Select whether to open the linked form in fullscreen or not.
Paging: Open Pages Parametrically Form for lists opened with a list action.
Record Selection List: Used to open lists faster. The drop-down form is only available for lists with record selection
Line Looking: Allows navigation between lines.
Run Condition: If the value in the query entered in this field is '0', the related action will not run.
Request Confirmation: Select whether you want to ask for confirmation before running the action. If Request Approval is active, the Approval Message feature is opened and the message to be displayed when requesting approval is written.
Example Used
First, let's enter an Xpoda development screen and open a new form. Let this form be a form indicating which product our customers ordered and when they ordered it. For this, let's add Text Box for Customer names, Drop Down Box for Product names, Figures Box for unit price and unit quantity of the product and Date tool for Order Time. After making the necessary naming, let's add a button to use our Open Form List action. The final studio view of our form will be as follows.
Let's click on our button and switch to the action tab from the properties area on the right side. Then let's add our action as follows.
Operation: Open Form- List
Condition: In New Window
Description: The list Show the Data
Value Area: All Forms
SQL Query:
SELECT
XPD_OPEN_FORM_LIST.UserTableID,
XPD_OPEN_FORM_LIST.Customer,
XPD_OPEN_FORM_LIST.Product,
XPD_OPEN_FORM_LIST.UnitQuantity,
XPD_OPEN_FORM_LIST.UnitPrice,
XPD_OPEN_FORM_LIST.OrderDate
FROM
dbo.XPD_OPEN_FORM_LIST WITH (NOLOCK)
After filling in the fields, the final image of our action will be as follows. Let's save our action by clicking the save button.
| When you click the save button on the Studio screen, the changes you make in the action are not saved. For this reason, you should save the changes made in the actions with their own save buttons. |
After adding data on the Client screen, when the relevant button is clicked, the following screen will open in a new window according to the properties of this action. With the Add button on the right, the relevant form fields of the related data on the Client screen are filled in. (Double click feature works in the same way.)
New window opened for the action on the Client screen
| The important points here are Value Area and UserTableID in the SQL Query field. If you select all forms for the Value Area, this will show all information about the UserTableID on the Client screen. Therefore, the UserTableID field has to be in the query. |
After double clicking on any record, the relevant information will come to our form on the Client screen as in the image below.
Sub Total: It allows us to show subtotal information according to the desired column under the list. The requested parameters must be sent in the correct order. The correct sequence is as follows,
- (Field|operation (count, sum, min, average) I Text)
Let's click on our Open Form- List action in our form we made in the previous example and write our structure where we can see the total amount of products ordered in the Sub Total section. This field will be as follows;
UnitQuantitiy|sum|Sum=
| By summing all the data in the Unit Quantity field with the sum operation, it will write the result at the bottom of the list opened by the Open Form List action immediately after the Sum= text we set. |
NOTE: The mapping feature is not used in the current version. When the improvement process is completed, a document arrangement will be made regarding its use.