When membership is obtained for a filter that Includes another filter or Excludes another filter, the membership for those filters is pulled in.
- Membership of the filter is determined based on the SQL query for the filter
- Membership of included filters is obtained and added to the results
- Membership of excluded filters is obtained and excluded from the results
For example:
- Membership of Filter: Food is determined based on the SQL query and Hamburgers, Potato Chips, Apple, and Ketchup is listed (by GUID)
- Membership of the included filter 'Precious Jewels' is pulled and Emerald, Diamond, and Ruby are added to the list
- Membership of the excluded filter 'Red Things' is pulled and Ketchup, Apple, and Ruby are removed
- The remaining membership is Hamburgers, Potato Chips, Emerald, Diamond.
Unfortunately I don't have a link, but I hope this helps. You could open up SQL Studio and review the stored procedures with Programmability to confirm the exact SQL process that handles all of this.
Does this answer your question?