Hi, I don´t know how to name my topic prperly, but i hope that I can give a clear description of my problem. I´m no expert, so I have no idea where to start with...
So, on the one hand I have a table where I have loaded all Groups of our Active Directory and a corresponding table with all Members of the AD. Let´s say the table with the groups contains a group named "TS_USERS".
(By the way, I used this Cookbook to load the elements from the AD: )
When I select a certain group in the group-table, all members of this group are displayed in the member-table
On the other hand, I have a table where all users of a specific Oracle-Database are loaded. This table is not linked to the AD-Data. The users in this table all have a status, let`s say "active" or" inactive". Let´s assume the name of the table is "SYS_USERS".
What I want to do now is a query, which provides the following information: List all the users, who are members of SYS_USERS and have the Status "active" but are not members of the AD-group "TS_USERS". (To clarify: A user, who is not member of the group TS_USERS must not have status "active" in the "SYS_USERS"-Table)
I hope this is understandable. Since there is no link between the two Datasets, i can´t use a SQL-Query. So i wonder, if there are any functions in QS, that i can use.
I have two filterboxes (A and B) now with mostly the same content, and only a few differences. Now i would like to have a third box (or a table, diagram, whatever...) which lists all the elements, that is present in filterbox B but not in Filterbox A. Any Ideas?
The only other way to go at it would be to load all the data into your data model and be sure the tables are connected appropriately such that you can get the resolution you want that way. Hopefully this may get you on the right track.
To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question. I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.