Create a Leave Application List

AVEVA Work Tasks allows you to create a list and store the data inside the list. You have the provision to map your list to a single table or multiple tables and also to map to a generic table which is provided by AVEVA Work Tasks.

In this scenario, you will create a typical Leave Application list and map to a generic table. Our sample leave application list will have the following fields.

• Employee Name

• Employee No: A unique number that identifies the Employee

• Absence Type: The type of absence (whether Sick Leave, Casual Leave, or Privileged Leave)

• Starting date of leave

• Ending date of leave

• And whether the leave is for a complete day or half a day

You will design a leave application list with the above mentioned fields. This can be created and designed from the Manage List page.

To create the application list

1. In the Enterprise Console, click the Menu button, click Tools, and then click Manage List. The Manage List page appears.

2. On the Ribbon Bar, click New. The Create List window is displayed.

3. Enter the Title as Leave Application.

4. Enter the description to identify your list.

5. Select Yes for Is Folder Supported? option to make your list folder supported. Then, you can organize your list in folders.

   Note: If the Title field is removed from the base List, Folder is not supported for the list.

6. Click Save and Continue.

7. In this case, you will map your list to the Generic table which is provided by AVEVA Work Tasks. So select Generic Table option, which is selected by default.

8. Click Next. The List Designer page is displayed.

9. The Title field is displayed automatically. The first field in your sample list is Name of Employee. So drag and drop a TextInput control in to the orange bar in the list name area, from the Tool Box. The property window of the TextInput Control Property window is displayed.

   Field	Description
   Tag name	Enter a tag name as Name of Employee.
   Description	Enter the description for the control. This is not mandatory.
   Mapped XML Node	Click anywhere after entering the tag name. The Mapped XML Node field is filled automatically.
   Bound to DB Column	This field specifies to which database column you want to map this field.
   Mandatory	Select Yes radio button to make this field mandatory.
   Allow Sorting	Selecting Yes will enable sorting by this field.

10. Enter the details and then click Save.

    Note: Since, you are in a beginning stage; you will not go in to the settings like, Appearance, Validation, Advanced and Scripts.

11. Next, you need to design the Employee Number field. Drag and drop TextInput control in to the orange bar in the list name area from the Tool Box.

    Field	Description
    Tag name	Enter a tag name as Employee No.
    Description	Enter the description for the control. This is not mandatory.
    Mapped XML Node	Click anywhere after entering the tag name. The Mapped XML Node field is filled automatically.
    Bound to DB Column	Specifies to which database column you want to map this field.
    Mandatory	Select Yes radio button to make this field mandatory.
    Allow Sorting	Selecting Yes will enable sorting by this field.

12. Enter the details as explained in the field description table, then click Save.

13. Next field in your leave form is Absence Type (Leave Type). You need to include the options like Casual Leave, Sick Leave and Privileged Leave. Here, we do not have a drop-down control. So select any control and name it as Leave Type. Later when designing the form for the list, you can replace this control with a Dropdown control. In this case you will drag and drop a TextInput control. The TextInput Control property window is displayed.

14. Enter the Tag name as Leave Type and enter the description for the control. This is not mandatory.

15. Click anywhere after entering the tag name. The Mapped XML Node field is filled automatically.

16. Select Yes radio button to make this field mandatory.

17. After entering all the necessary details, click Save.

18. An applicant should mention the leave duration in his/her leave application form. For that there should be the leave starting date and ending date fields in the list. So, next, you will create leave starting date field. For that drag and drop DateInput in to the orange bar in the list name area from the Tool Box options. The Date Input Properties window is displayed.

    Field	Description
    Tag name	Enter a tag name as Leave Start Date.
    Description	Enter the description for the control. This field is not mandatory.
    Mapped XML Node	Click anywhere after entering the tag name. The Mapped XML Node field is filled automatically.
    Bound to DB Column	Specify to which database column you want to map this field. This field is not mandatory. Type LeaveStartDate.
    Mandatory	Select Yes radio button to make this field mandatory.
    Allow Sorting	Selecting Yes will enable sorting by this field.

19. After entering all the required information as mentioned in the field description, click Save.

20. Next, you will design an end date for the leave. For that drag and drop the DateInput control in to the orange bar in the list name area. The Date Input Properties window is displayed.

    Field	Description
    Tag name	Enter a tag name as Leave End Date.
    Description	Enter the description for the control. This field is not mandatory.
    Mapped XML Node	Click anywhere after entering the tag name. The Mapped XML Node field is filled automatically.
    Bound to DB Column	Specify to which database column you want to map this field. This field is not mandatory. Type LeaveEndDate.
    Mandatory	Select Yes radio button to make this field mandatory.
    Allow Sorting	Selecting Yes will enable sorting by this field.

21. After entering all the needed information as mentioned in the field description, click Save.

22. Next, you need to design a field to mention whether the leave is for a complete day or a half day. For that drag and drop BooleanInput control in to the orange bar in the list area. The Boolean Input Property window is displayed.

    Field	Description
    Tag name	Enter a tag name as Half day?.
    Description	Enter the description for the control. This field is not mandatory.
    Mapped XML Node	Click anywhere after entering the tag name. The Mapped XML Node field is filled automatically. You need to delete the ‘?’ mark from the node as XML Node should not have any space or special characters.
    Bound to DB Column	Specify to which database column you want to map this field. This field is not mandatory. Type Halfday.
    Mandatory	Select Yes radio button to make this field mandatory.
    Allow Sorting	Selecting Yes will enable sorting by this field.

23. Enter the essential data in the respective fields as explained in the field description table. Then click Save.

24. Now, you have designed all the fields required for your leave application. Click Submit to save the list.

25. A form for your list is auto generated. Click Yes if you want to edit the auto generated list form. Clicking No will take you to the List Manage page, There you can see the Leave Application list.

    Note: When you submit a list, a form is automatically created for the list. You can customize the control properties or modify the properties in the forms designer page.

26. Next, you will see how to create items for the Leave Application list that you have created now.

To create Leave Application list items:

27. In the Enterprise Console, click the Menu button, click Tools, and then click Manage List. The Manage List page appears.

28. When you click Leave Application, the corresponding list item window is displayed.

29. Since, this list is just created now, you will not find any items. You will notice that the column headings are same of your Leave Application list. On the Ribbon bar, click New to create new item. The New List Item window is displayed.

30. Enter the details. Ensure that all the mandatory fields are entered correctly.

31. After entering all the mandatory fields, click Submit.

Now, you can see that a Leave Application list item is added. In the same way, you can create any number of list items for any list that you have created.