Trying to use j-sql to find what i think should be something straightforward, but cant figure out the magic keywords.
In my work packages I have a field indicating which components stories need to be generated for (e.g. Engine, Axle, Tire, Wheel). Those stories then have an specific team assignment like "Engine Team", "Axle Team", "Tire Team", etc., because everything is in the same project.
What I'm trying to do is find any Work Packages where the parent identifies that a child is needed ("Engine"), but no child object exists assigned to that team ("Engine Team").
I started with a folder on my structure board, with an insert, as follows:
project = "Car" and component in (Engine) and issuetype = "Work Package" AND status != Closed
But I cant seem to figure out the magic jql/s-jql which will then filter out work packages where the specific stories with a given team assignment have already been made (or conversely, returning those items where a team assignment of that type is missing)
Thanks
