Getting started with Value Lists
Overview
A grid is displayed, listing all existing value lists:
![](../__attachments/3904935249/att_1_for_3861250141.png?inst-v=c3007bf4-8f91-43d3-9633-90859273c945)
Within the grid, the following read-only columns are displayed:
Name: the unique name that identifies a value list.
Type: one of Database or Local.
State: one of Added, Edited, Deleted, or Unchanged.
When no value lists have been configured, an advisory message is displayed.
Selected Value List Details
This section displays the details of the value list selected currently in the list. If no value lists have been configured, an advisory message is displayed.
The section contains the following properties:
Name: the unique name used to identify the value list. Name is mandatory, can be a maximum of 100 characters in length, and must be unique across all value lists.
Description: an optional property that can be a maximum of 1000 characters in length.
The following properties are shown if a local value list is selected:
![](../__attachments/3904935249/att_2_for_3861250141.png?inst-v=c3007bf4-8f91-43d3-9633-90859273c945)
Value data type: this dropdown field exposes the following values:
DateTime
Decimal
Integer
String (the default)
String field length: this property is only displayed when Value data type is set to String. An integer field, it defaults to 100, and accepts a minimum value of 1 and a maximum value of 1000.
List items: this property consists of a toolbar and a list.
Toolbar: exposing the following:
Add new List Item: invocation of this option adds a new list item to the list. Its default Label is “Label” (this value can be incremented to ensure uniqueness), and its default Value blank.
Move selected List Item up: this button is available when a single list item other than the first in the list is selected. Selecting it moves the list item up one position in the list.
Move selected List Item down: this button is available when a single list item other than the last in the list is selected. Selecting it moves the list item down position in the list.
Remove selected List Items: selecting this button removes the currently-selected list items from the list. An “Are You Sure?” dialog is not shown.
Copy List Items to clipboard: this button is available when one or more list items is present in the list. Invocation copies the list items to the clipboard. Names and values are tab-delimited.
Paste List Items from clipboard: this button is available when the clipboard is populated with text. Selecting it displays a submenu:
Replace existing values
Append to existing values
If the clipboard values are of the correct tab-delimited structure, names and values are pasted into the list in accordance with the selected option. If the clipboard contents are not of the correct tab-delimited structure, a warning message is displayed.
List: containing updateable Label and Value columns. On creating a new local list, a single list item is present therein. Its Label property is set to “Label” (this can be incremented to ensure uniqueness). Its Value is blank. At least one list item must be defined.
Label: this column is optional. All supplied labels must be unique within a list. If blank, the text Blank label is displayed.
Value: this column is also optional. If a String list, Value is set automatically to the same string as its corresponding Label, and the length of the Value provided must not exceed the list's String field length.
Note that, when using a value list at an audience definition metadata attribute, Value will be displayed if a Label is not provided.
![](../__attachments/3904935249/att_3_for_3861250141.png?inst-v=c3007bf4-8f91-43d3-9633-90859273c945)
The following properties are shown if a database value list is selected:
Source table: this property represents the table from which values and labels are to be selected. A database table must be selected using the Choose Database Item dialog. Selection of a table makes the the Value and Label column properties available. Changing Source table clears any existing column properties.
Value column: this property represents the column from which list values are to be selected. It is unavailable until a Source table is selected. The property must be set to a database column from the Source table, using the Choose Database Item dialog. You can Clear the property once selected.
Label column: this optional property represents a label to be shown instead of the corresponding value. If a label column is not supplied, the selected value column is displayed instead. It is unavailable until a Source table has been selected. The property can set to a database column from the Source table, using the Choose Database Item dialog. You can Clear the property once selected. A Validation error is raised when saving value lists if the Value and Label columns are set to the same column.
Filter: this property represents an optional selection rule used to limit the records selected from the source table. You can browse for a selection rule, or populate the property using drag and drop. Having populated the Filter, you can open its latest version in the Rule Designer. You can also Clear your selection. Note that the selection rule you choose must be compatible with the selected Source table; if not, a Failed to load values message will be displayed at a metadata attribute based on the list (hovering over the same displays the error details in a tooltip).