Greetings,

I have a table populated by entries from a gravity form (I am also using the gravity forms addon for wpdatatables). One of the form fields is "Lot Number". The lot number is also a meta value on the post (created via Pods). I have a beautiful table built using the gravity form as the data source and then some conditional formatting, but it shows all entries, including those for old lots.

I would like to filter the table somehow to only show results for the most recent lot number.  Lots usually span multiple days, so date filtering is problematic. Via conditional formatting in the column, I can input a number for the current lot and set a custom css class to the row and hide the row, but I want to automate this and pull the current lot value somehow to automatically filter the data.

So, two prongs to this, as I see it. If using the gravity form as a data source for the table, is there a way to filter that based on lot number?

Alternatively, I experimented with using an SQL query to pull the data from gravity forms, but I was unable to separate out the meta values of the table into separate columns. If there was a way to pull form fields and format the table properly via an SQL query, then I could probably use a WHEN function to filter by the current lot number.

Any help would be greatly appreciated. Thanks very much!