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 MIQ Logistics Limited Unit 1, Alpha Way Thorpe Industrial Park Egham, Surrey TW20 8RZ United Kingdom Direct Tel: +44 (0) 1784 480136 Facsimile: +44 (0) 1784 480177 Email: [email protected] Website: www.miq.com<http://www.miq.com/> Newsfeed: www.miq-rss.info<http://www.miq-rss.info/> Twitter: http://twitter.com/miqlogistics Directions:www.multimap.com/map/browse.cgi?lat=51.4169&lon=-0.5289&scale=10000&icon=x<http://www.multimap.com/map/browse.cgi?lat=51.4169&lon=-0.5289&scale=10000&icon=x> Except as otherwise agreed in writing, signed by a director of MIQ Logistics, all storage, picking and packing services are carried out subject to the United Kingdom Warehousing Association's conditions of contract current at the time of contract (UKWA) and all other services provided by MIQ Logistics are provided subject to the British International Freight Association's standard trading conditions current at the time of contract (BIFA). Hyperlinks to the current UKWA & BIFA conditions are included at the foot of this email. Your attention is specifically drawn to the limitations of liability in respect of loss or damage contained in those conditions. Consequentially, customers should notify their own insurers to ensure that adequate insurance cover is in place in connection with any services provided by MIQ Logistics. http://www.bifa.org/_attachments/Resources/1105_S4.pdf http://www.ukwa.org.uk/_files/6-conditions-of-contract-sample-6.pdf
--------------------------------------------------------------------- OTRS mailing list: itsm - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/itsm To unsubscribe: http://lists.otrs.org/mailman/listinfo/itsm
