Hi Kristen,

It sounds like a custom module would be the best option here since you would be able to code it as you need.

https://www.labkey.org/home/Documentation/wiki-page.view?name=simpleModules

To stay under the SQL column limits, you will most likely need to setup multiple tables to only hold a certain number of columns, but have each table utilize the same primary key value so a JOIN will tie the tables together.

Then with Josh's idea, your pagination would consist of querying one or more tables respectively.

A custom module will also allow you to develop your own download function as well. As for filters, the pagination query idea from above would have to incorporate the filtering as well.

Regards,

Jon