He covered regular lookup columns as well as Managed Metadata columns.What it comes down to is using the projection to the source of the lookup or Managed Metadata column and then filtering base on the original, underlying value.
It feel like you’d need to specify where that list is or something, but under the covers that happens for you.
There are no errors, messages, or warnings at any point.
This only happens in one site collection, even though many other site collections use the same User Profile Synchronization Service.
I may get a club soda out of it, but at Andrew’s suggestion, I figured I’d put up a post as well.
As has happened so many times in the past, the blogosphere fills in the gaps.