Linking table dynamic_field_value to another table associated with a specific ticket for reporting purposes
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: Matthew.Roche@MIQ.COM Website: www.miq.comhttp://www.miq.com/ Newsfeed: www.miq-rss.infohttp://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=xhttp://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
participants (1)
-
Roche, Matthew