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".
SELECT * FROM INCIDENTSM1 WHERE CATEGORY <> 'purchase request' and OPEN <> 'Closed' and INCIDENT_ID in (select SOURCE from SCRELATIONM1 WHERE DEPEND in (SELECT "NUMBER" FROM PROBSUMMARYM1 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.
Thanks for the direction to solve this problem. I finally came up with the right syntax to make this work. Listed below is the source code to make this solution work if anyone else has a similar problem. After adding this function to a current or new script library, build a search using the following expert search query: