To use gantt on Xpoda platform, you can create gantt element in the form by drag and drop the icon which you can see on the left side of tha page from the tool box. It is the tool that enables the use of gantt scheme in the form.
Gantt tool icon at Toolbox
How it looks like on the Canvas
Compatibility
| Free Form | Responsive Form | Mobile |
 |
 |
 |
Properties
Properties of this tool;
-
Name: The name of the tool will be written here.
-
Edit Form: Select which form to open in the tool.
Completion %: This is the area to be defined to indicate how many percent of the task in the Gantt scheme is completed.
-
Heading: The title field is selected in the selected form.
-
Start: Start date is selected in the selected form.
-
Finish: The end date is selected in the selected form.
-
Main Task: This is the field where the field to be defined as the main task is defined in the task list in the Gantt diagram.
-
Connection Form: It is the field where the form in which the tasks in the Gant scheme will be linked with each other is selected.
-
Resource ID: If a task in the Gantt diagram is linked to another task, the source is the field where the task ID is defined.
-
Target ID: If a task in the Gantt diagram is linked to another task, this is the area where the target task id is defined.
-
Time Interval (h): It is the parameter that determines the time interval in which tasks are displayed in the Gantt diagram.
-
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 (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).
-
Connection Query: This is the SQL query field in which the links in the Gantt scheme will be determined.
-
Data Query: This is the SQL query field that specifies the tasks to be listed in the Gantt diagram.
-
Fit Horizontal: Fits the tool to the full screen on the user’s screen.
-
Display: Makes the tool l not appear on the screen.
Actions
There is no action for this tool.
Examples Used
To use the Gantt tool, you need two forms. Sample Gantt usage and areas to be considered are as follows. Fields drawn in sample code must be defined on forms. The following code should be written in the data query field.
SELECT * FROM
(
SELECT A.UserTableID,
A.FormTypeID,
A.ProjectID,
A.ProjectName AS [DefinitionOfTask], This section will be written in the title field.
A.StartDate, —Written in the start field.
A.FinishDate, —Written in the finish field.
A. Level, —Must be written in Completion % field and maximum value must be 100.
0 AS [MaınTaskID] – Written to main task field.
FROM MAIN_TABLE A –The form linked to this table must be selected in the Link Form field.
WHERE A.UserTableID = $PExternalValue
UNION ALL
SELECT B.UserTableID,
B.FormTypeID,
B.ProjectID,
B.DefinitionOfTask,
B.StartDate,
B.FinishDate,
B.Level,
B.MaınTaskID —UserTableID of table A must be entered in the main task field.
FROM CONNECTED_TABLE B –The form linked to this table must be selected in the Edit Form field.
WHERE B.MainTableID = $PExternalValue
) C
ORDER BY C.UserTableID
How it looks like on the Canvas