I have a "Pole" point feature class with a related "SignsParksRec" table to store signs on each pole. I created a definition query in the pole feature class in Pro so that only the poles that had a sign in a particular category would display. My query:
FacilityID IN (SELECT Pole_ID FROM SignParksRec WHERE bannercategory IS NOT NULL)
The definition query validates, but when I apply it, there are five poles that do not meet the query and still display.
I've read the documentation on subqueries, but I wonder if I'm running into trouble because the data sources are branch versioned? I know when I do query layers, I have to add where clauses to only return the most recent record and not the archived ones.
