OTRS 3.1.5 where is the link ticket-Dynamic Fields

[StefanoBoccanera]

Hi
I migrated from otrs 3.0.9 to 3.1.5.
All sounds fine, after I migrated the DB (postgres 8.4), but I didn't find how the ticket are linked to the dynamic fields created.
This information is viatl for me, because I have many automated reports using specific sql select. So before to migrate the production installation I have to modify any
select to output the right informations.

best regards

[jojo]

have a look at the database structure provided in the doc folder

[StefanoBoccanera]

have a look at the database structure provided in the doc folder

Hi jojo

I just saw to the OTRSDatabaseDiagram.png, but no link relation is depicted btw ticket and dynamic_field or dynamic_field_value tables.

I suspect, after a very brief cross analysis, that object_id column into dynamic_field_value table contains the ticket id reference.

A extend analysis is very huge for me, so it's possible to redirect the question to development team to check if the above assumption is right?

best regards

[jojo]

object id will reference article id or ticket id depending on the type of the freefield.

you can also use the developer mailing list or irc channel on freenode for these questions