But when I do that then all of those features I am missing are still missing....but this time because of the definition query. The table is a table of inspections for the features. Each feature has an inspection record in there dating back many years, but I am only interested in the inspections for the current year.
What I need to see are all of the features (ie. hydrants) that have an inspection record during 2022.
But I also need to keep all of the hydrants that don't have an inspection record in 2022....which is what I thought the "Keep all Features" would do. I could then symbolize based on the joined INSP_DATE field. All of the INSP_DATE = Null would be the ones that haven't been inspected yet.
I could do this with two separate layers....one layer with ALL of the hydrants as "Uninspected" and then the layer with just the inspected layers on top of it. Visually, it works, but when I load it into a web map, when a user clicks on an inspected hydrant, they are actually seeing a pop-up for the same hydrant twice....one pop-up from the Uninspected layer (which they can't see) and one pop-up for the top Inspected layer.
There has to be a way to show both Uninspected and Inspected in the same layer.