Hello Community!
Do you know how can I develop a query to show all the object person who occurs in a model FAD but are not in a model Organizational chart ?
The point is how can i set a negative condition, like persons who are not in a model organizational chart type.
Thanks in advance,
Dilcarina
Hi Dilcarina,
good news and bad news.
The bad news: ARIS queries do not have an equivalent to the SQL operator "NOT EXISTS" so far.
The good news: Your case can be solved through semantic checks. There is a rule type checking exactly the kind of rules you described. So configure this rule for a semantic check profile you use anyway. If you don't use any, yet, take a closer look at them. The big advantage is that any modeller can apply them easily and errors are highlighted in the model: QA at the finger tips of the modeller.
Regards, M. Zschuckelt
Hi Dilcarina,
there is a workaround using queries as well. You could try the following (depending on your DB structure):
Start at Group level then take all FADs contained then all Persons contained and then "occurrs" in Org chart. Then you set a target at the person objects, create a table view with a column for each of the steps and later on filter for all Blanks in the column "Org Chart"., so something like the attachede picture.