...
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 5 different fields.
sortindex
Maps to the table item_combo_value
...
The default value of a field, ie this is the value of and column sortindex.
A sort index determines how various values are displayed in a combo box. It works exactly like a compare function, in that values with sortindex of 0 will be placed next to each other in no particular order; a higher sort index places a value lower in the combo; a lower sort index places the value higher in the combo.
Only works if a meta data field element's field if a field is not specified by the user.
Limited to 4000 chars.
sortindex
enten meta field lable eller meta field (check selv)'s data type is a combo. If in doubt, whether a meta data field is a combo data type, find out or do not use this field.
item_metafield_label_label
The language versioned label associated with a meta data field.
ItemReferenceTitle
if If a meta data field is associated with item this is an item, this field will map to that item's title.
ItemReferenceBaseID
same but with base IDIf a meta data field is associated with an item, this field will map to that item's base ID (primary key).
ItemGuid
A GUID, which maps directly to a meta data field.
...