Used to report. The requested information can be seen as the desired list card.
List Card tool icon at Toolbox
How it looks like on the Canvas
This toolbox is triggered when the form is opened.
Name: The name of the tool will be written here.
Help Text: It is the text that is entered for comment when the mouse is placed on the tool.
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: SQL query will be written here.
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.
Paging: Multi-line data can be loaded quickly.
When the row is Changed: Assign an “Action” as on row value changes handler. For more information please click here.
Record is Added: Assign an “Action” as on record adds handler. For more information please click here.
Firstly, this tool is triggered when the form is opened with an update value operation.
To use the list card, a label must be added to the list card. The name added to the label should be written as $PTagName$ as in the screen below. After the list card query is written, the areas in this query is added to Group Box of the List Card with $P. If there are aliases in the query, you must use them.
This List Card tool is used to assign tasks, for announcements, to show each row in the table separately.
All tasks which is status "New" will be shown off in this list. In order to do that a List (Card) is needed to from the toolbox and is named it as “ListCard_1”. In query box the following query is entered;
TM_VARIABLE.Name AS TaskType,
XPODA_CLIENT_USERS.UserFullName AS Responsible,
FROM dbo.TM_TASKS WITH (NOLOCK)
LEFT OUTER JOIN dbo.TM_VARIABLE WITH (NOLOCK)
on TM_TASKS.Task_Type = TM_VARIABLE.UserTableID
LEFT OUTER JOIN dbo.XPODA_CLIENT_USERS WITH (NOLOCK)
on TM_TASKS.Responsible = XPODA_CLIENT_USERS.UserID
How it looks like on Canvas
After that “groupbox_1” heading will be changed as “$PResponsible$”. And labels will be added as "$PTask_Title$", "$PComments$" “$PTaskType$”. The last group item will be a button. these labels and heading will show off every one of task card. Button will be used for edit to the selected task card. Please notice label names and query (in ListCard_1) name must be the same. The color of the List Card tool is chosen from the Property Panel.
To display the data on List Card, Event should be " When the form is opened" and operation will be " Update value" for the ListCard_1.