The database relation between Dynamic Fields and tickets in OTRS 6

Moderator: crythias

Post Reply
fcasal
Znuny wizard
Posts: 336
Joined: 21 Apr 2014, 16:14
Znuny Version: 6.0.18

The database relation between Dynamic Fields and tickets in OTRS 6

Post by fcasal »

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!
wurzel
Znuny guru
Posts: 3224
Joined: 08 Jul 2010, 22:25
Znuny Version: x.x.x
Real Name: Florian

Re: The database relation between Dynamic Fields and tickets in OTRS 6

Post by wurzel »

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.
fcasal
Znuny wizard
Posts: 336
Joined: 21 Apr 2014, 16:14
Znuny Version: 6.0.18

Re: The database relation between Dynamic Fields and tickets in OTRS 6

Post by fcasal »

I already checked it, but dynamic fields are only relate between them, and the valid, is alone.
crythias
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

Post by crythias »

otrs-dynamicfield6.png
This is from v6 schema png
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
fcasal
Znuny wizard
Posts: 336
Joined: 21 Apr 2014, 16:14
Znuny Version: 6.0.18

Re: The database relation between Dynamic Fields and tickets in OTRS 6

Post by fcasal »

It helps. I will try with that. Thanks!
Post Reply