When creating a Meta data field element, the data, which the element does work on/with, is the item_metafield_value.value table and column.

For most scenarios, this is sufficient. However, a meta data field has much more information associated with it, eg. the meta field's label. If the label, instead of the value, is what is needed, then the field "item_metafield_label_label" can be added to the element. An addition of such a field changes the data from item_metafield_value.value to item_metafield_label.label. NB! Be aware that labels may have different values depending on the selected language.

There are 26 different fields.

value

The default value of a field, ie this is the value of a meta data field element's field if a field is not specified by the user.

Limited to 4000 chars.

smallValue

Holds the same value as value, but limited to 200 chars.

item_metafield_valueid

The primary key for the item_metafield_value table.

optionvalue

prevref

item_tree_valueid

item_combo_valueid

rowid

sortindex

item_metafield_item_datatypeid

item_metafield_label_is_public

item_metafield_label_sortindex

item_metafield_label_label

The language versioned label associated with a meta data field.

item_metafield_label_defaultvalue

item_metafield_label_nm_function

item_metafield_label_nm_search

item_metafield_label_nm_search_sortindex

item_metafield_label_manifest

item_metafield_label_errormessage

item_metafield_label_item_metafield_validationid

item_metafield_label_culture

The culture, which is applied to the item_metafield_label_label

metafieldid

The base ID/primary key of a meta data field.

ItemReferenceTitle

ItemReferenceBaseID

StandardGuid/ItemGuid

A GUID, which maps directly to a meta data field.