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.
mysql - update dynamic field value
Moderator: crythias
Re: mysql - update dynamic field value
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
"Testing": ((OTRS Community Edition)) and git Master
Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com
-
- 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
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
Free Znuny add ons from the community: http://opar.perl-services.de
Commercial add ons: http://feature-addons.de
Re: mysql - update dynamic field value
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.
Again, thank you.