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.
It is really important for anyone who follows this to not change the object_type once set, because the object_id in dynamic_field_value doesn't know the difference between ticket.id=2 and article.id=2, and therefore the values will apply where you don't expect. On Mon, Oct 29, 2012 at 8:56 AM, Roche, Matthew <[email protected]>wrote: > 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 >
--------------------------------------------------------------------- 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
