Inventory, collection based on membership in many collections not working
Hi all.
I think I might be doing something wrong, but if I set a dynamic collection filter to filter All and have more than one "Member of Collection" line, the filter returns empty. The membership works for each line, but together it doesn't.
If the filter is Any, the superset appears as expected.
I want one collection to display the computers present in all collections I specify.
Thanks in advance!
Skuli
-
Thanks, Colby.
This is due to the nature of SQL. The two tables used represent a one to many relationship. This is similar to the Computers and Applications tables. One computer can have many applications this is why you would need to perform the same breakdown if you were looking for a computer that had two or more specific applications. The original collection would never return any computers because at the filter level SQL was trying to see if each computer was a member of a collection that was called both 7-Zip AND Adobe Flash. When you separate the two similar filters into different group filters then you can get what you are looking for.
We are discussing some ways that we can make this a little more intuitive. Sorry for the confusion.
Please sign in to leave a comment.
Comments
6 comments