List of EM and Survery Tickets
We have been requested to provide a list of all EM (EM-) and Survey tickets (Survey-) where the associated IM ticket is not closed yet.
I am successful to get the list of EM and Survey tickets that are not closed however, now seeking advise / guidance / help / reference to link / join so that associated IM tickets and their status is listed.
Below is the query for reference:
select rp.reportprocessid, rp.result,rp.projectname from ReportProcess rp
where (rp.projectname like '%email%' and rp.result <> 'closed') or
(rp.projectname like '%survey%' and rp.Result like 'in process')
order by rp.ReportProcessID
Anything on this would be highly helpful.