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,
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.
M. Zschuckelt on
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