I am trying to do something that I assume is very simple, but I am just not getting it. I have two tables: Hydrants and Inspections.
The Hydrants table has a Key of “HydrantNum” and numerous other fields that track details about each hydrant.
The Inspections table also has a “HydrantNum” field which has a ref to the Hydrants table. Other Inspection fields include “Inspection Date”, “Result”, etc. The inspections table can contain multiple inspections for each hydrant.
What I am trying to do is create a view that only displays the hydrants that have not had an inspection within the current calendar year. When an inspection is logged for a hydrant in the current calendar year, that hydrant should fall out of this view. Simple, right?
I tried using a Slice to accomplish this, but I couldn’t figure out the row filter expression. Does anyone have any suggestions for me?