SQL Update not visible in UI

Moderator: crythias

Post Reply
andy1967
Znuny newbie
Posts: 15
Joined: 13 Jun 2012, 08:42
Znuny Version: 3.1.7
Real Name: Andy Grootens

SQL Update not visible in UI

Post by andy1967 »

Hi,

We have OTRS working together with SAP Business One, and have a synchronisation tool that sends OTRS Tickets to SAP Servicecalls. The synchronisation updates a Dynamic Field on the ticket with an UPDATE sql statement. In the database it is visible that this has been executed fine, but in th UI the data is not visible in the Dynamic Field. When waiting like 24 hours, it suddenly does appear in the ticket. Is there a mechanism that wil force the data changes in the UI?

Regards,
Andy
jojo
Znuny guru
Posts: 15019
Joined: 26 Jan 2007, 14:50
Znuny Version: Git Master
Contact:

Re: SQL Update not visible in UI

Post by jojo »

Never update via SQL directly!

Use the API or the Webservices instead.

Caching is used and must be used for several reasons.
"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
Post Reply