dynamic_field_value has an object_id which is either the ticket.id or the article.id, depending on the type of object represented by the dynamic field. The dynamic_field_value.field_id maps to dynamic_field.id and dynamic_field.object_type determines Ticket or Article.
Hi
We have added an extra text field called comments in the Additional ITSM field of our tickets to be used as a quick status update, we then want to use SQL Server Reporting Services to pull this information through and link it to the specific ticket it is associated with.
I have identified that the text I enter in to comments box shows up in the table dynamic_field_value in the value_text column and has an associated field_id of 46
What I cannot work out is how to associate this to the specific ticket the comment was entered in to so I can pull this info forward to SRSS
Any ideas/suggestions?
Matt Roche
IT Support Analyst
---------------------------------------------------------------------
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs