Please ensure Javascript is enabled for purposes of website accessibility
Powered by Zoomin Software. For more details please contactZoomin

AVEVA™ Work Tasks

TABLE OF CONTENTS

Create List

Save PDF
Save selected topicSave selected topic and subtopicsSave all topics
Share
Share to emailCopy topic URL
  • Last UpdatedNov 15, 2023
  • 3 minute read

Create a list to use with forms and workflows.

To create a 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 action bar, click New, and then click List. The New List wizard appears.

  3. In the Title box, type a name for the list, and in the Description box, type a description for the list.

  4. Do one of the following:

    Task

    Action

    • Enable folder support for the list to group and organize the list.

    • Under Enable folder support?, click Yes.

    • Disable folder support for the list.

    • Under Enable folder support?, click No.

5. Click Save & Continue. The list is created, and the Select Table wizard appears.

6. Do one of the following:

Task

Action

  • Store the list data in generic table.

  • Select Generic Table.

Note: The list fields are automatically mapped to the fields in the generic table.

  • Store the list data in an existing table.

  1. Select CustomList Table.

  2. Select a table from the list of existing tables.

    Note:
    - Table name and column name must not contain any spaces or special characters.
    - Click the Refresh icon to refresh the list of existing tables.

    • Create a new table and add columns to it.

    1. Select CustomList Table.

    2. Click icon.

      The Create Table properties dialog box opens.

    3. In the Table Name box, enter the name for the table.

    4. To add column, in the Column Name box, enter the name for the column. The column name should not be the Reserved list column name.

    5. Select the Data Type and the corresponding Length and Scale if applicable.

    6. For Allow Nulls option, select Yes if you want to pass null values or else select No.

    7. Click Save. The table gets saved to the database.

      Note:
      - Table name and column name must not contain any spaces or special characters.
      - Table should not have Reserved list column names.
      - Table can have maximum 64 columns apart from Reserved List columns.
      - You cannot create a new Folder in Custom List, which is mapped to a table with Allow Nulls option set to No for column(s).

      • Edit an existing table to add the columns.

      1. Select CustomList Table.

      2. Select a table from the list of existing tables.

      3. Click icon to add the columns in the table.

      4. Click Save after adding new column(s).

        Note:
        - Table name and column name must not contain any spaces or special characters.
        - Column name should not start with the number.
        - Table should not have Reserved list column names.
        - Table can have maximum 64 columns apart from Reserved List columns.
        - You cannot delete the existing column in a table.
        - You can edit the Existing table for a newly created list before clicking Submit button from the List designer.
        - Click Refresh icon to refresh the list of existing tables.
        - You cannot create a new Folder in Custom List, which is mapped to a table with Allow Nulls option set to No for column(s).

        7. Click Save & Continue. The list is created, the New List wizard is closed, and the Table wizard appears.

        8. Design the list, and then click Submit. The list is saved and the Form Settings dialog box appears.

        9. Follow the steps for To auto generate the form in Auto Generating Forms.

        Note:
        - If an existing custom table from the repository is deleted from the database, the table name still appears in CustomList table List Box. Mapping table entry in SKListTables must be deleted to delist from CustomList table List box.

        Related Links
        TitleResults for “How to create a CRG?”Also Available in