Editing lookup table type attribute values

You can edit lookup table type attribute values.

Before you begin

You must search for the categories or items that you want to edit. Ensure that you already have a lookup table type attribute that is defined in a spec.

About this task

When defining the File Spec, Primary Spec, Lookup Spec, Secondary Spec, Sub-Spec and Script Input Spec, there are specific fields where you can select the type of display for your lookup table attribute values.

To select the display of the lookup table attribute values, you can either select a specific format from the Lookup Table Value Display Format field or the Lookup Table Value Display Attribute field drop-down list. For relationship type attributes, you can select a value for the Relationship Value Display Format field.

The Lookup Table Value Display Format field enables you to choose the type of format. The Lookup Table Value Display Attribute field enables you to choose any attribute of the selected lookup table as the display attribute, attribute can be the primary key of the lookup table as well. The Relationship Value Display Format field enables you to display the different types of relationship values.

The single edit and multi-edit screens displays the lookup table and relationship attributes values in the specified format and also uses the specified display attribute.

The lookup table displays both the primary key of the lookup table attribute and the specified display attribute. The relationship attributes displays the destination catalog name, primary key, and the display attribute.

Procedure

  1. Expand the catalog module in the left pane navigation to view the list of categories or items.
  2. Click on a category or an item to open in the right pane.
  3. Edit a lookup table type attribute value.
    1. Modify the attribute value using the select lookup table entry window. This window opens as a pop-up when you focus on the look table type attribute field and click on the icon towards the right of the attribute field.
    2. Provide the primary key for the lookup table entry in the Key field. Alternatively, if a display attribute was identified in the spec definition of this lookup table attribute, provide the display name for the lookup table entry in the Display field.
    3. Alternatively, if you do not know what the primary key or the display value is, you can provide a search criteria under the Search for Entries section. Click on the green arrow to execute the search. Alternatively, if you want to look at all the entries in the lookup table without specifying a search criteria, then Click View All Rows. Choose a entry from the search results by clicking on it.
      Note: To make changes to a specified attribute across multiple items, do the following:
      1. Select the cell. Right-click and choose Copy Cell.
      2. Select the rows that you want to update the attributes with this data that you just copied. Use standard Windows multi-select options, for example, select a row, then press Shift and select the last row in the set.
      3. Right-click and choose Paste. The paste shows you what attribute will be pasted
    4. Click Ok.
    5. Click Save.
    To modify lookup table type attribute for multiple categories or items:
    1. Click the link next to the hierarchy or category that lists the number of categories or items.
    2. Select Edit All. The right pane displays the list of categories or items with its attributes.
    3. Modify the attribute value using the select lookup table entry window. This window opens as a pop-up when you focus on the look table type attribute field and click on the icon towards the right of the attribute field.
    4. Provide the primary key for the lookup table in the Key field. Alternatively, if a display attribute was identified in the spec definition of this lookup table attribute, provide the display name for the lookup table entry in the Display field.
    5. Alternatively, if you do not know what the primary key or the display value is, you can provide a search criteria under the Search for Entries section. Click on the green arrow to execute the search. Alternatively, if you want to look at all the entries in the lookup table without specifying a search criteria, then Click View All Rows. Choose a entry from the search results by clicking on it.
    6. Click Ok.
    7. Click Save all modified.