Dynamic field doesn't appear in DB

Moderator: crythias

Locked
paddew
Znuny newbie
Posts: 21
Joined: 16 Dec 2011, 12:37
Znuny Version: 3

Dynamic field doesn't appear in DB

Post by paddew »

Hallo everyone,

i run in a lot of trouble after upgrading from OTRS 3.0.10 to 3.1.4.

Previously we had free text fields defined. For example freekey2 (Error Cause) and freetext2 (dropdown menu with serveral error causes as value).
The automatic conversion to dynamic fields failed.
So i defined a new dynamic field for our purposes. The field appears when closing a ticket (configured at Frontend::Agent::Ticket::ViewClose).

Now my problem: the data of the dynamic field doesn't appear in the database record of a closed ticket. When i look into the DB with a MySQL browser i can't see any error cause. Previously we had the error cause under freekey2 and the corresponding value under freetext2.

Do i have to configure anything further to get the dynamic field key and value saved in the database record of closed tickets?


greeting

paddew
jojo
Znuny guru
Posts: 15020
Joined: 26 Jan 2007, 14:50
Znuny Version: Git Master
Contact:

Re: Dynamic field doesn't appear in DB

Post by jojo »

there is a special table for the fields, the are not stored in ticket table. Have a look at the database scheme
"Production": OTRS™ 8, OTRS™ 7, STORM powered by OTRS
"Testing": ((OTRS Community Edition)) and git Master

Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com
paddew
Znuny newbie
Posts: 21
Joined: 16 Dec 2011, 12:37
Znuny Version: 3

Re: Dynamic field doesn't appear in DB

Post by paddew »

got it, thanks alot!
Locked