Profile picture for user Dilcarina Duarte

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

by M. Zschuckelt
Posted on Thu, 10/25/2018 - 07:46

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

0
by Florian Rese
Posted on Thu, 10/25/2018 - 08:14

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.

0
by Dilcarina Duarte Author
Posted on Mon, 12/17/2018 - 17:30

Thank you both! 

Regards,

Dilcarina

0

Featured achievement

Rookie
Say hello to the ARIS Community! Personalize your community experience by following forums or tags, liking a post or uploading a profile picture.
Recent Unlocks

Leaderboard

|
icon-arrow-down icon-arrow-cerulean-left icon-arrow-cerulean-right icon-arrow-down icon-arrow-left icon-arrow-right icon-arrow icon-back icon-close icon-comments icon-correct-answer icon-tick icon-download icon-facebook icon-flag icon-google-plus icon-hamburger icon-in icon-info icon-instagram icon-login-true icon-login icon-mail-notification icon-mail icon-mortarboard icon-newsletter icon-notification icon-pinterest icon-plus icon-rss icon-search icon-share icon-shield icon-snapchat icon-star icon-tutorials icon-twitter icon-universities icon-videos icon-views icon-whatsapp icon-xing icon-youtube icon-jobs icon-heart icon-heart2 aris-express bpm-glossary help-intro help-design Process_Mining_Icon help-publishing help-administration help-dashboarding help-archive help-risk icon-knowledge icon-question icon-events icon-message icon-more icon-pencil forum-icon icon-lock