Using Pick Lists
9 min
about pick lists docid\ m0dqgjwohw5tbwrbrjumjaccessing a pick list docid\ m0dqgjwohw5tbwrbrjumjcreating a pick list docid\ m0dqgjwohw5tbwrbrjumjmodifying a pick list docid\ m0dqgjwohw5tbwrbrjumjmodifying values in a pick list docid\ m0dqgjwohw5tbwrbrjumjtranslating a pick list docid\ m0dqgjwohw5tbwrbrjumjdeleting a pick list docid\ m0dqgjwohw5tbwrbrjumjusing validation business objects docid 0y8n6cncv7 uueg068u59adding values to a pick list docid 3o68m7vovkfjl w38ty2r about pick lists a pick list is a list of values shown on a drop down list or combo box pick lists supply other business objects with field values and are stored as child business objects in a relationship pick lists are used by validation business objects to filter data see using validation business objects docid 0y8n6cncv7 uueg068u59 pick lists can include business objects that are standalone records for example, the standarduserteam and employee business objects control the team and owner drop down lists in many business objects each value in a pick list is obtained from a table row in a business object for example, the active employee list by full name pick list derives its values from the full name table row in the employee business object when using a combo box in the service catalog that gets data from a pick list, ensure that the pick list is validated otherwise, you might see the red invalid value indicator in the field accessing a pick list from the configuration console, click build > pick lists to open the pick lists workspace the application displays a list of pick lists pick lists workspace click an item from the list to view specific details, including associated business objects and fields you can also access all pick lists for a business object by doing the following from the configuration console, click build > business objects to open the business objects workspace open a business object the application displays the workspace for that business object along the top, click pick lists the application lists all of the pick lists associated with that business object creating a pick list from the configuration console, click build > pick lists to open the pick lists workspace the application displays a list of pick lists click add new\ the application displays the pick list new record page pick list new record page enter information into the fields field description ignore constraints if constrained list is empty applies to pick lists with constraints only if you apply a constraint to a pick list and the resulting pick list is empty, then show all of the pick list values auto select if list has single value applies to pick lists with constraints only if you apply a constraint to a pick list and the resulting pick list has just one entry, then automatically select that value list name the name of the pick list display name the display name of the pick list get list data from specifies where to get the pick list data from business object select a business object, then select a value from the drop down list unicode text fields marked as validated only show named validation lists with stored fields which are also unicode text fields similarly, regular text fields can only by validated by named validation lists, with stored fields which are regular text fields for example, assume there is a named validation list defined against the loginid field in the employee business object that has been marked as unicode (such as displayname of employee with loginid value by team ) to use it as the pick list for a validated text field, the field must also be marked as unicode this enables the named validation list to show up in the list validation provider supported in the service catalog only, and used only for the dsm legacy integration for the dsm legacy integration, select an item from this list and the application generates a pick list based on the hard coded logic in the code display field the visible field name to be displayed in the pick list value field a stored field name select from the drop down list this entry frequently differs from the display field selection for example, the owner field in many business objects contain pick lists of displayname entries derived from the employee business object, such as bernard jeffries however, you can select a value field entry that is based on the corresponding login id of the employee business object, such as bjeffries this allows the value of the login id to be stored in the database when the pick list item is selected in this case, it is a practical choice because many business rules and application functions use login id values sort by field specifies the field to sort by choose how to sort the data ascending descending add constraints to the pick list to restrict the data presented a click the add new condition icon to activate a constraint formula this formula is based on the business object that you selected in the get list data from field b use constraints to restrict or filter the amount of values that the application shows, based on previously selected values to use such a pick list (such as within a request offering), enter a field in the first area, enter equals to in the second area, and enter in the third area pick list constraints as another example, to add a constraint to the active employee list by full name pick list to include all active employees, enter status in the first area, enter not equal to in the second area, and enter terminated in the third area you can select begin with , contains , and does not contain in the second area you can also enter an expression in the third area click the function icon to open the expression editor c click the remove this condition icon to delete a constraint (optional) click preview to see what the pick list looks like, before saving it click save modifying a pick list from the configuration console, click build > pick lists to open the pick lists workspace the application displays a list of pick lists click the pick list to modify (optional) click usage stats to view the business objects where the pick list is used and the name of its linked field (optional) click preview to view what the pick list looks like modify the information as needed click save modifying values in a pick list from the configuration console, click build > pick lists to open the pick lists workspace the application displays a list of pick lists click values next to the pick list to modify the list of values appears to add a value, do the following a click add b enter the new value c click save to modify a value, do the following a select the value row b click edit at the far right end of the row c edit the value d click save click close translating a pick list you can create translated values for each item in the pick list you can only translate pick lists that contain fields with localized values (to determine if a pick list has localized fields, go to the validation business objects workspace, select the validated business object, click the fields tab, click the field name, and see if localized is checked ) see about localization docid\ smiz2gbduytkviohxbdw6 for more information from the configuration console, click build > pick lists to open the pick lists workspace the application displays a list of pick lists click values next to the pick list to translate the list of values appears select the value row, then click edit at the far right end of the row pick list values the application displays the edit type dialog box click the translate icon edit type dialog box the application displays the translate dialog box translate dialog box enter the translation click save the application displays the value based on the locale that they choose see setting up languages docid\ lvpbgqv5z08mcuzy43ky3 deleting a pick list you cannot delete default pick lists, which the application displays with a lock icon use caution when deleting a pick list business objects using this pick list might no longer function as expected from the configuration console, click build > pick lists to open the pick lists workspace the application displays a list of pick lists open the pick list to delete click delete deleting a pick list the application displays the delete validation list dialog box click yes return to the list view and refresh the window the application no longer displays the pick list
