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 are vital 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.
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, but an extensive check is a very time consuming job.
So anyone can help me on this information?
best regards
--