Create a List Mapped to Multiple Tables

AVEVA Work Tasks allows you to create a list and to map your list to multiple tables. You can select a generic table which is provided by AVEVA Work Tasks to map the table.

In this scenario, you will create a Purchase Order list and map to multiple tables. You will map to custom tables Purchase Order and Purchase Order Details which are created in your database server. Our sample Purchase Orders list will have the following fields.

• Reference Number

• Purchase Order Date

• Raised By User

• Deliver To User

• Status

• Purchase Order Details

  • Item Name

  • Quantity

  • Unit Price

  • Item Total

• Total Amount

  Note: Both the parent and child should have the standard columns apart from those listed above.

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

Before starting with the scenario, you need to have Purchase Order and Purchase Order Details tables in your database.

To create the Purchase Order:

1. On the Ribbon bar, click New. The Create List window is displayed.

2. Enter the Title as Purchase Orders.

3. Enter any description to identify your list.

4. 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.

5. Click Save and Continue.

6. 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.

7. Click the Refresh button. The default tables are displayed in the Generic Table field.

8. Select Purchase Orders table from the list and then click Next. The List Designer page appears.

   All the fields that you have created in your database are displayed in the list. Now you want to add one child item i.e. Purchase Order Details to the list. Assume that you want to add the grid just before the Total Purchase Amount field.

9. Drag and drop List Table from the Tool Box to the green area of the Total Amount field..

10. Click the Refresh button. The default tables are displayed in the Generic Table field.

11. Select Purchase Order Details table from the list and then click Next. The ListTableForm property window is displayed.

12. Enter the Tag name as Purchase Order Details.

13. Click Save.

14. Now, you have designed all the fields required for your Purchase Order list. In this case you have two lists -parent list and child list- and both are mapped to different tables. Click Submit to save the list.

15. A form for your list is auto generated. Select Yes, if you want to edit the auto generated list form. Selecting No will take you to the Manage List page, There you can see the Purchase Order 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.

    Through Forms Designer the child table can be replaced with Grid. Refer to the scenario Modify the Default List Form.

    Next, you will create Purchase Order list items.

To create Purchase Order list items

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

17. Click Purchase Order. The corresponding list item window is displayed.

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

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

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

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