Show Inline Data

This operation allows you to open a new list for each line in the related list. In the list that opens, a new list can be opened according to the transaction order.

Adding a New Detail List in the Property Panel

Features

Description: Write a description about the action.

Heading: Specifies the name in the action list when the form is added as Action.

Control Query: SQL query is written

Formatting (Field | Criteria | Value | Type | Colors | Cell(0-1)): The specified color is applied to the line according to the specified field information. For example; the text color of the lines with Quantity | == | 0 | 0 | 0 Red style and quantity 0 is painted red, or the background of the lines with Quantity | == | 0 | 1 | Red quantity 0 is painted red.

Sub Total ( Field|operation (count, total, min, average) I Text): The list allows you to see the total information one below the other. For example; subtotal of quantities, Quantity | Total | Amount Total transaction

Paging: The list will be paginated.

Hide Column Heading: Hides the column headings in the list.

File Menu: Adds a toolbar to the list header to download and view the files in the list.

Run Condition: If the value in the query entered in this field is “0”, the related action will not run.

Request Confirmation: Select whether to use request confirmation before running the action. If Request Confirmation is active, the Confirmation Message feature is opened and the message to be displayed when requesting confirmation is written.

In the example below, there are two separate screens, one where we enter projects and one where we enter project details. The information taken from the project detail table is opened as a sub-element above the list where we list the projects.

The screen and table where projects will be entered:

The screen and table where the details of the projects will be entered:

A new form of Report type is created and a list element is dragged. The query of the list is written to list the projects and the query is given in the image below. Then, Show Inline Data action was added by clicking on the list element and a query was written in the Control Query field that allows the details of the projects to be opened as a breakdown.

List Query:

SELECT 
UserTableID AS [|UID],
ProjectName AS [Project Name],
Status
FROM Projects WITH (NOLOCK)

It is mandatory to give a unique alias to UserTableID in the list query. The reason for this is to avoid confusion with the id field in the query we will write in the Show Inline Data action.

Control Query:

SELECT 
UserTableID,
TaskName,
Description,
Responsible,
StartDate,
EndDate 
FROM ProjectDetail WITH (NOLOCK) 
WHERE DetailID='$PUID$'

The project is saved, then the List element is triggered to display the operations performed on the Client screen. Go to the Client screen with the Run button.

Client view is as follows:

Click on the small triangle icon on the left side to see the detailed information of the row.