I am trying to create a data source in datasource designer based on a query that I am designing in query designer. The end result should be a list of all Work Orders with a Work Leader that is missing a specific competence.
In Query designer, I am able to retrieve a list of ongoing Work Orders with Work Leaders and I am also able to retrieve a list of competence per Work Leader but I fail to remove the Work Orders for those with a Work Leader that has the specific competence.
The filter in Query Designer seems to be applied as a final step which makes it hard to just get a list of the specific competence at hand, and eliminates the possibility to use left outer join and search for null values.
Is there anyone that knows a good way to solve this challenge?