otrs ticket information sql query update back end?

Moderator: crythias

Post Reply
kalyana1315
Znuny expert
Posts: 171
Joined: 24 Apr 2013, 12:29
Znuny Version: OTRS3.3
Real Name: kalyanachakravarthy M P
Company: TATA Technologies
Location: Pune,India
Contact:

otrs ticket information sql query update back end?

Post by kalyana1315 »

Ticket_information.JPG
Hi,

any one know how to update database back-end
.

we have done some back-end up date datebase

1.dynamic_field_value table update new value_text
2 . ticket history table update dynamic_field_value new one name(same as update dynamic_field_value table)

But we are checking AgentTicketZoom in ticket information dynamic_field_value values is showing old data


any one help how to change ticket information
You do not have the required permissions to view the files attached to this post.
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: otrs ticket information sql query update back end?

Post by reneeb »

This is a caching issue. You shouldn't update the database directly, but use the API instead.
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
kalyana1315
Znuny expert
Posts: 171
Joined: 24 Apr 2013, 12:29
Znuny Version: OTRS3.3
Real Name: kalyanachakravarthy M P
Company: TATA Technologies
Location: Pune,India
Contact:

Re: otrs ticket information sql query update back end?

Post by kalyana1315 »

reneeb wrote:This is a caching issue. You shouldn't update the database directly, but use the API instead.
hi reneeb,

we are clear all caches but still showing old information. ur test new browser also but old information showing
crythias
Moderator
Posts: 10169
Joined: 04 May 2010, 18:38
Znuny Version: 5.0.x
Location: SouthWest Florida, USA
Contact:

Re: otrs ticket information sql query update back end?

Post by crythias »

I don't see anything in the image that indicates what would be considered a dynamic field?
OTRS 6.0.x (private/testing/public) on Linux with MySQL database.
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask
kalyana1315
Znuny expert
Posts: 171
Joined: 24 Apr 2013, 12:29
Znuny Version: OTRS3.3
Real Name: kalyanachakravarthy M P
Company: TATA Technologies
Location: Pune,India
Contact:

Re: otrs ticket information sql query update back end?

Post by kalyana1315 »

Infom_ticket.JPG
crythias wrote:I don't see anything in the image that indicates what would be considered a dynamic field?
hi crythias

we are using two dynamic Ticket text filed.

Additional Contact Information:
SLA Remark :

Ur are updated (some wrong text date corrected) backend database table .
otrs.dynamic_field_value, ticket_history tables,

But still old data showing in AgentTicketZoom view Ticket informations
You do not have the required permissions to view the files attached to this post.
crythias
Moderator
Posts: 10169
Joined: 04 May 2010, 18:38
Znuny Version: 5.0.x
Location: SouthWest Florida, USA
Contact:

Re: otrs ticket information sql query update back end?

Post by crythias »

Check this and see if you can verify what you think you did.

viewtopic.php?f=53&t=16009#p77686
OTRS 6.0.x (private/testing/public) on Linux with MySQL database.
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask
kalyana1315
Znuny expert
Posts: 171
Joined: 24 Apr 2013, 12:29
Znuny Version: OTRS3.3
Real Name: kalyanachakravarthy M P
Company: TATA Technologies
Location: Pune,India
Contact:

Re: otrs ticket information sql query update back end?

Post by kalyana1315 »

crythias wrote:Check this and see if you can verify what you think you did.

viewtopic.php?f=53&t=16009#p77686
we are tested query

SELECT ticket.*, dynamic_field.name, dynamic_field.label, dynamic_field_value.value_text
from ticket
left join dynamic_field_value on (dynamic_field_value.object_id=ticket.id)
left join dynamic_field on (dynamic_field_value.field_id = dynamic_field.id)
where dynamic_field.object_type="Ticket"

query showing correct data(update data) , but agent ticket zoom view Ticket information showing still old data ?
Post Reply