otrs ticket information sql query update back end?
Moderator: crythias
-
- 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?
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.
-
- 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?
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
Free Znuny add ons from the community: http://opar.perl-services.de
Commercial add ons: http://feature-addons.de
-
- 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?
hi reneeb,reneeb wrote:This is a caching issue. You shouldn't update the database directly, but use the API instead.
we are clear all caches but still showing old information. ur test new browser also but old information showing
-
- 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?
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
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
-
- 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?
hi crythiascrythias wrote:I don't see anything in the image that indicates what would be considered a dynamic field?
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.
-
- 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?
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
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
-
- 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?
we are tested querycrythias wrote:Check this and see if you can verify what you think you did.
viewtopic.php?f=53&t=16009#p77686
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 ?