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 union 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...