We have 2 models... say for eg: Person and Contractor... Based on
different criteria (office, department, interest etc) we need to show
paginated result of both people and contractors which will be all
sorted by name.
Right now, the one solution is to put SQL query like:
select * from (
select * from people where conditions
select * from contractors where same conditions
order by name
and then use the paginated plugin to take care of the collection
returned by query.
Since we are dealing with legacy database where I cannot club together
both the models and create STI to make the code simpler.
Is there any better approach for this problem... I am sure there...