Where DynamicField value, store ?

[eterjack]

Good morning,

Where the OTRS stores the data of field dynamics? When the field is dropdown in dynamic_field_value table, it stores the key value that matches the value. Where is this value stored?

[crythias]

in the table dynamic_field_value

[eterjack]

Humm

Look,

table: dynamic_field ->

'20', 'categoria1', 'Categoria 1', '1', 'Dropdown', 'Ticket', ?, '1', '2012-10-04 16:44:28', '2', '2012-10-15 12:17:04', '2'
'21', 'categoria2', 'Categoria 2', '2', 'Dropdown', 'Ticket', ?, '1', '2012-10-04 17:22:23', '2', '2012-10-05 11:29:40', '5'

table dynamic_field_value
id, field_id, object_id,value_text,value_date,value_int
'1563', '21', '430', '1', NULL, NULL
'1562', '20', '430', '1', NULL, NULL

In the categoria1, the value 1 for dropdown is string '1.1 Acesso'. Where is this string is store ?

[crythias]

I believe that "dynamic_field.config" as a blob holds the values you seek, while dynamic_field_value.value_text would hold the key/index of the entry.

[eterjack]

Thx, crythias..

You rigth..