Topic: Filter a TableGrid
Hi Everyone,
I have a tableGrid that has a bunch of service records for different pieces of equipment.
I would like for the tableGrid to show only the records with the latest Service date.
.
Equip Service Date
Alternator 8/1/2020
Alternator 8/15/2020
Alternator 8/20/2020
Engine 7/1/2021
Engine 7/15/2021
.
So for the Alternator I would like to see only the 8/20/2020 record.
And the same for each piece of equipment.
.
I'm thinking I might be able to put a select statement in the filter section of the tableGrid but I don't know how I might format the statement...if it's possible or adviseable.
.
Thanks
Frank