This content has been marked as final. Show 2 replies
Something like this?
TOP (100) PERCENT T3.im_id AS [Incident ID], T1.tps_creation_datetime AS [Date/Time], T2.lc_title AS Event, dbo.tps_user.tps_title AS [Triggered By],
dbo.tps_group.tps_title AS [Supporter Group], T4.im_full_name AS Categorie, tps_user_1.tps_title AS [Raise User]
FROM dbo.pm_process INNER JOIN
dbo.tps_audit_trail AS T1 LEFT OUTER JOIN
dbo.lc_action AS T2 ON T1.tps_function_id = T2.lc_business_function_guid INNER JOIN
dbo.tps_user ON T1.tps_creation_user = dbo.tps_user.tps_guid INNER JOIN
dbo.tps_group ON T1.tps_create_group_guid = dbo.tps_group.tps_guid ON dbo.pm_process.pm_guid = T1.tps_object_guid INNER JOIN
dbo.im_incident_category AS T4 INNER JOIN
dbo.im_incident AS T3 ON T4.im_guid = T3.im_category_guid ON dbo.pm_process.pm_guid = T3.pm_guid INNER JOIN
dbo.tps_user AS tps_user_1 ON dbo.pm_process.pm_raise_user_guid = tps_user_1.tps_guid
WHERE (T3.im_id = 1)
ORDER BY [Incident ID], [Date/Time]
Yes, thank you very much.
I´ve tried something like this but I didn´t work .
Your´s works fine.
Ok now I have to try my best and find my mistake
Thanks again and with kind regards