mysql - update dynamic field value

Moderator: crythias

Locked
FelipeIP
Znuny newbie
Posts: 3
Joined: 13 Jan 2016, 20:54
Znuny Version: otrs-3.3

mysql - update dynamic field value

Post by FelipeIP »

Hi, I would like to know if someone knows which tables I need to update/insert to fill the dynamic values. I tried the tables "dynamic_field_value" and "ticket_history". There are values now for the ticket that i am trying, but looking on the web page the dynamic values are empty and in the reports the values came blank.

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

Re: mysql - update dynamic field value

Post by jojo »

Never manually insert or delete anything in the database!
"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
reneeb
Znuny guru
Posts: 5018
Joined: 13 Mar 2011, 09:54
Znuny Version: 6.0.x
Real Name: Renée Bäcker
Company: Perl-Services.de
Contact:

Re: mysql - update dynamic field value

Post by reneeb »

You should not update the db directly. This can lead to inconsistencies. Furthermore OTRS uses caching, so database changes will show up when the caches expired. You should use the API: http://otrs.perl-services.de/docs/otrs/ ... ckend.html -> ValueSet()
Perl / Znuny development: http://perl-services.de
Free Znuny add ons from the community: http://opar.perl-services.de
Commercial add ons: http://feature-addons.de
FelipeIP
Znuny newbie
Posts: 3
Joined: 13 Jan 2016, 20:54
Znuny Version: otrs-3.3

Re: mysql - update dynamic field value

Post by FelipeIP »

Thank you for the advice guys. Like [reneeb] says, the problem was the caching. When it expired the dynamic values were update. Now problem solved.

Again, thank you.
Locked