I need to retrieve a list of interactions in a new view that will show all interactions with related incidents that have a problem.status of "Pending Project".
WHERE CATEGORY <> 'purchase request' and OPEN <> 'Closed' and INCIDENT_ID in
(select SOURCE from SCRELATIONM1
WHERE DEPEND in
WHERE problem_status = 'Pending Project')
Any help would be appreciated. If you also know of a better way to perform this action then that would be appreciated too. Thank you.