: How to find the link btw ticket and dynamic_field value ?

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 -- * Stefano Boccanera*
participants (1)
-
Stefano Boccanera