Should advanced query run over the results that are currently displayed in the grid?
I have a custom application (Find/Browse) that displays the most recent certification record for each employee. Each employee can have multiple historical certification records with different expiry dates. I have an Advanced Query to show me which certification records in the grid will be expiring on a specific date. When I use the Advanced Query, it is running over the underlying business view instead of the data in the grid. Is there a setting that I missed to tell Advanced Query to run over the data in the grid?