Updating osTicket Database by external program

aeren

Hi,

We have set up version "osTicket 1.15.x (Stable) " in our server, and we added some new fields our database table "ost_ticket_cdata". We can see this field in osTicket screen. Also we enter any data to this field from osTicket screen , our table "ost_ticket_cdata" is correctly updating and we can see new updated value. But We are trying to update this field with SQL command like this "update ost_ticket__cdata set additionalfield= 111 where ticketid= 123".
This Command is updating the table "ost_ticket_cdata" but we can't see updated value on osTicket Screen.
Is it possible to update by external program? İf it is possible, how should we do it?

We use mySQL as Database.

best regards.

ertuncb

+1 from rookie OsTicketer.
I have the same situation. I want to write some of the values I calculate into custom fileds on ticket and tasks records.
I also wrote the values in the table like @aeren , but I couldn't manage to get these values on the screen.
If anyone knows how to do it, would be grateful if someone could help. Thx.

ntozier

ost_ticket_cdata is a temporary table used for caching data to speed up performance. This table gets dropped from time to time and re-generated as needed. You should not be writing data directly to it.

ertuncb

ntozier Thanks @ntozier. Is there a way to write the data to the custom fields available on the task/ticket? Any suggestions ?

ntozier

You would have to reverse engineer the task thread to the tasks (or ticket thread to tickets) and add the data to the individual tables that it needs to be added to.

Sorry i can't really be more help on this right now. I'm not near my main workstation or servers(s) for another week and a half.