I have a stated record type of Escalation which has a parent/child relationship with a stateless record type of CodeStreams. CodeStreams has a resolution field for each child CodeStream. There can be many CodeStreams to one escalation.
I am trying to create a query that will only return records in which none of the children have a resolution of "fixed".
I have tried a variety of and/or options to no avail, seems some records still come back where a child is "fixed". I am thinking this may have to be done with SQL, any help would be much appreciated.