Hi,
We are using dinamyc fields in the closing part of the ticket. Now I want to get that information with sql, but I can not understand how is the relation between the tables. I found that in this forum:
viewtopic.php?t=19452
But is from otrs 3.3 and the valid table is now now linked to the ticket, so I am a bit lost.
I also checked the admin and developer manual, but still could not find the answer.
Could you giveme any clue about this?
Thanks!
The database relation between Dynamic Fields and tickets in OTRS 6
Moderator: crythias
Re: The database relation between Dynamic Fields and tickets in OTRS 6
OTRS 8 SILVER (Prod)
OTRS 8 auf Debian 11 (Test)
Znuny 7.x latest version testing auf Debian 11
-- Ich beantworte keine Forums-Fragen PN - No PN please
I won't answer to unfriendly users any more. A greeting and regards are just polite.
OTRS 8 auf Debian 11 (Test)
Znuny 7.x latest version testing auf Debian 11
-- Ich beantworte keine Forums-Fragen PN - No PN please
I won't answer to unfriendly users any more. A greeting and regards are just polite.
Re: The database relation between Dynamic Fields and tickets in OTRS 6
I already checked it, but dynamic fields are only relate between them, and the valid, is alone.
-
- Moderator
- Posts: 10169
- Joined: 04 May 2010, 18:38
- Znuny Version: 5.0.x
- Location: SouthWest Florida, USA
- Contact:
Re: The database relation between Dynamic Fields and tickets in OTRS 6
dynamic_field_value.object_id is the ticket id or the article id
dynamic_field_value.value_text, value_date or value_int is the value of the field related to the dynamic_field.field_type
dynamic_field.name is the shortname/fieldname (DynamicField_name)
dynamic_field_value.field_id is the link to dynamic_field.id
dynamic_field.label is the long name
dynamic_field.object_type determines whether this is a Ticket or Article (or Change or ...) field
Hope that helps.
You do not have the required permissions to view the files attached to this post.
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
Re: The database relation between Dynamic Fields and tickets in OTRS 6
It helps. I will try with that. Thanks!