gridview. How to make a convenient selection of data from large tables while maintaining the intermediate result?

Question

Yii

The question is general, I do not ask you to chew it to the smallest detail, please give at least a direction where to look ...
The task is a table with a large (from 1200) number of records. You need to select certain rows, but at the same time, rows can be selected using filters and you can ensure that any row that is not included in the current filter is added to the result. This set of records also needs to be saved to the database for use in other tasks.
How to solve such a problem correctly? Do you need to save sql queries or an array of selected id after each filtering? Or make an intermediate table in which the record id and list id will be recorded (too many records in the end .... lists of 20-50 items, about 1000 lists)
I could not find something similar ...