Query multiple tables, combined pagination
I have three tables, each with different columns and datasets. I would like to be able to:
a) Return all records within each table, combined into a single array of records with pagination. This is so I can page through ALL records regardless of their type
b) Pass a query to each table, and then have a combined array of records returned including pagination for the combined array
Is this possible?
I can see how to fire off three separate queries and then combine results into one array, but the problem with this is that each one then have their own pagination, totals, etc, not one combined
I appreciate any help you can provide.
Other
3 replies