Remove Rows from table using criteria
It seems the "Tables: Remove a Row" action only allows you to set up specific criteria on a single field that the row(s) must meet in order to be deleted. This doesn't allow for query-like criteria to be used. I have a table we are using for capturing logs that are date-time stamped. I would like to remove old logs where the date time stamp is over 3 days old. Is there a way to do this with a built in action?
Comments
-
@Adam_636382, could you use a filter action (Tables: Apply Filters) to filter based on certain dates (less than 3 days old) and then use that new table instead? That action automatically creates a new table and eliminates any rows that don't meet the filter criteria.
0 -
@Adam_636382 Is your goal to permanently delete the old data, or to execute a query to return a filtered data set?
If the latter, @Meghan_904209 has the right answer for you.
If you want to permanently delete the old data, I suggest applying a data retention policy to that workflow.
0