Hi all, it is possible to make a query to the db and sort the elements
of multiple tables by date?
I will try to be more specific with an example, I have this
controller, the structure of the model should be evident:
def index(): # This is the index controller
dataset_one = db().select(db.dataset_one.id,
db.dataset_one.title, orderby= ~db.dataset_one.created_on)
dataset_one = dataset_one[:2] # limits to the last two results
dataset_two = db().select(db.dataset_two.id,
db.dataset_two.title, orderby= ~db.dataset_two.created_on)
dataset_two = dataset_two[:2] # limits to the last two results
return dict(dataset_one=dataset_one, dataset_two=dataset_two)
it return two dictionaries with the last 2 entry for dataset_one and
dataset_two (4 total in 2 dict).
But what I want to accomplish is to return only one dictionary with
the two most recent entry from all dataset, so if the 2 most recent
are from dataset_one the query get this results only and ignore
dataset_two...
To be honest I dont think is possible, but I will happy to be wrong.
Sadly, I cant restructure the db...
I hope to have made this question clear enough... My english is not very well...
Thanks for any help!
