You are here: Configuration > Attributes and Arrays > Single Select Pick Lists

Single Select Pick Lists

OVERVIEW

The Single Select Pick List attribute type can be created in Configuration for Text, Integer, and Float data types. While similar to a Single Select Menu attribute on the user side, a Single Select Pick List attribute’s menu options are managed within a defined resource.

The only resources that can be referenced by a Single Select Pick List are CPQ Cloud Data Tables.

Single Select Pick Lists have several advantages:

Single Select Pick Lists can be created as stand-alone attributes or as array-type attributes.

ADMINISTRATION

ClosedAccessing the Menu Attribute Editor Page

  1. ClosedNavigate to the Configurable Attributes Administration List page.

    1. Click Admin to go to the Admin Home Page.

    2. Click Catalog Definition in the Products section.

      The Supported Products page appears.

    3. In the Navigation column, select Configurable Attribute and then click List.

      The Configurable Attributes Administration List page appears.

  2. Click the name of an attribute that has Single Select Pick List in the Attribute Type column, or create a new attribute.

    The Menu Attribute Editor page appears.


ClosedUsing the Top of the Menu Attribute Editor Page

The Menu Attribute Editor page for the Single Select Pick List attribute type has the following sections at the top of the General tab: Main Information, Properties, and, if you select Yes for Image Menu, Image Menus Properties.

The Image Menu Properties section appears when you click Yes for Image Menu.

The Image Menu option does not appear in an attribute while it is being created. It only appears in an attribute that has been saved during creation, or has been re-opened.

For more information about the Image Menu Properties section, see the Image Menu Properties Section and the External Image Support section in this topic, and the topic Using Images with Attributes.

At the bottom of the General tab, there is a Single Select Pick List section for you to populate your menu. For more information, see Single Select Pick List Section.


ClosedMain Information Section

  1. Edit the Name of the attribute.
  2. Enter a Description.

    If Help Icon is checked for the attribute in the Configuration Flow Editor, the description appears when the user hovers over the help icon.

    For more information, see Configuration Flows.

  1. Select Yes to enable Image Menus, if desired. See Image Menus Properties Section for more details.

    The Image Menu Properties section appears when you click Yes for Image Menu.

    The Image Menu option does not appear in an attribute while it is being created. It only appears in an attribute that has been saved during creation, or has been re-opened.

ClosedProperties Section

  1.  Choose the Set Type:
    • None The user can input any value without encountering an error message.
    • Set A recommendation rule can change the value entered by the user unless the attribute is locked by the user.
    • Forced Set A recommendation rule will change the value of the attributes regardless of what the user enters and if the attribute is locked or not.
  1. Select the appropriate checkbox for:
    • Required This will require the user to enter a value before proceeding to a commerce transaction.
    • Hidden This attribute will not appear to the user. It can be used in rules.
    • Auto Update This will by updated by the system without the user invoking an action.
    • Hide In Transaction This attribute is hidden within a commerce document.
  1. Choose the Status of the attribute:
    • Active An attribute that is active will appear to the buyer and/or be included in rules.

      All attributes are active by default.

    • Inactive An inactive attribute cannot appear in a rule to the user.
    • Internal An internal attribute will only appear to FullAccess users.
  1. Click Show Start/End Dates to specify how long the attribute will remain in the chosen status.

      If no duration is specified, the attribute maintains its status until the admin changes it.

ClosedImage Menu Properties Section

Enter the following values in the Image Menu Properties section:

ClosedSingle Select Pick List Section


ClosedUsing the Domain, Variable, and Display Drop-Downs

ClosedExternal Image Support

ClosedFilters

ClosedFilter Syntax

ClosedColumn Syntax

ClosedComparison Value Syntax

ClosedFilter Examples

ClosedFilter Use Case

ClosedType To Filter Functionality

ClosedPick Maps

Pick Maps allow admins to set one or more Configuration attribute values to a value defined within a column of the Single Select Pick List’s Domain, without creating any Recommendation rules that would require BMQL.

Pick Maps are optional.

The Picker Attribute and Model Attribute menus determine Pick Map relationships. When a value is given to a Single Select Pick List, the Model Attribute is force set to the value of the Picker Attribute value in the same row as the selected Single Select Pick List value.

Field Description
Picker Attribute

The column in the Domain that contains the value that will be force set on a Configuration Attribute. The row with the menu option that is selected in the Single Select Pick List on the user side will be used to determine the Picker Attribute value that contains the force set value.

Note: The Picker Attribute menu lists all of the selected Domain's columns.

Model Attribute

The Configuration attribute that will be force set with the Picker Attribute value.

Notes:

  • The Model Attribute menu will only contain Configuration attributes that are on the same level or a higher level of the Product Hierarchy as the Single Select Pick List attribute, and whose data type matches the data type of the Picker Attribute column in the Domain.
  • Only one Pick Map can be created per Model Attribute (Configuration attribute).
  • In a non-array type Single Select Pick List, you cannot select array-type attributes as Model Attributes in Pick Maps.
  • In an array-type Single Select Pick List, you can only select array-type attributes that share the same Array Control attribute with the Single Select Pick List as Model Attributes in Pick Maps.

In a Single Select Pick List attribute that will contain Picks Maps, the Variable column in the Domain should not contain duplicate values. In this scenario, the system will use the Picker Attribute column value within the same row as the selected menu option in the Variable column.

If there are duplicate values in the Variable column, the user could select either identical menu option, and there is no way to guarantee that the intended Picker Attribute value will be used.

When a Pick Map relationship has been established using the Picker Attribute and Model Attribute drop-downs, the Pick Map can be added to the Single Select Pick List by clicking Add.

Active Pick Maps are shown in the Pick Maps list.

An active Pick Map can be removed from the Pick Maps list (and therefore be deactivated) by selecting the Pick Map within the list and then clicking Delete.

For example, an Address Single Select Pick List could contain a Pick Map to set the value of a Phone attribute based on the value of the Address attribute.

In this example, within the Domain that the Address attribute draws its menu options from, there should be a column with Phone values for each Address menu option, as in Image 10.

Within the Single Select Pick List, the admin can define a Pick Map to set the value of the Phone attribute to the PhoneCode value in the same row as the selected Address menu option of the Single Select Pick List on the user side, as shown below.

On the user side (shown below), the Phone attribute is force set based on the value of the Address attribute.

Attributes are force set by Pick Maps using AJAX. As with all Configuration attributes affected by AJAX, when the attribute is force set, all Configuration rules that use the attribute in their conditions will be invoked.

ClosedNew System User for Authentication

A new system user, system_user_cpq_server_as_client, has been added to the User Administration List of the Host Company.

The system_user_cpq_server_as_client user is used for OAuth authentication within CPQ Cloud to enable Single Select Pick List functionality. The system_user_cpq_server_as_client user cannot be inactivated or modified—errors will occur when an admin attempts to inactivate the user and when an admin attempts to save changes made to the user.


NOTES

RELATED TOPICS

Related Topics Link IconSee Also