My issue is I need to delete a subset of records from within a biz form (in excess of 1,000 records) while retaining others (also in excess of 1,000). I am very easily able to isolate these records using the filter in the BizForm data tab (and export to CSV for archiving purposes).
Given that your solution is based on a custom query, is there any danger/reason why I shouldn't just run queries directly against the BizForm database tables to delete records?
Generally speaking I never like to do that--I'd prefer to use an API or otherwise "approved" method of using the app to change the state of the database. But if there are no external dependencies on these tables, given my use case, it sounds like a SQL script might be a viable option?