The database relation between Dynamic Fields and tickets in OTRS 6

Moderator: crythias

Post Reply
fcasal
OTRS superhero
Posts: 327
Joined: 21 Apr 2014, 16:14
OTRS Version?: 6.0.18

The database relation between Dynamic Fields and tickets in OTRS 6

Post by fcasal » 29 May 2019, 15:41

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
OTRS guru
Posts: 2761
Joined: 08 Jul 2010, 22:25
OTRS Version?: 6.0.x

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

Post by wurzel » 29 May 2019, 15:43

    ((OTRS)) Community Edition 6.0.x, LAMP LIVE auf Debian 9
    OTRS 7 SILVER

    -- 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
    OTRS superhero
    Posts: 327
    Joined: 21 Apr 2014, 16:14
    OTRS Version?: 6.0.18

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

    Post by fcasal » 29 May 2019, 15:44

    I already checked it, but dynamic fields are only relate between them, and the valid, is alone.

    crythias
    Moderator
    Posts: 10102
    Joined: 04 May 2010, 18:38
    OTRS Version?: 5.0.x
    Location: SouthWest Florida, USA
    Contact:

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

    Post by crythias » 29 May 2019, 16:12

    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 5.0.x (private/testing/public) on Linux with MySQL database. Also on github.
    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
    OTRS superhero
    Posts: 327
    Joined: 21 Apr 2014, 16:14
    OTRS Version?: 6.0.18

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

    Post by fcasal » 29 May 2019, 21:56

    It helps. I will try with that. Thanks!

    Post Reply