Thank you for your answer.
What do you mean by:
1) too many records: I have about 1k per dataset
2) database view?
Le samedi 15 décembre 2012 20:23:44 UTC+1, Massimo Di Pierro a écrit :
>
> If you have lots of records you may be able to do it with a database view
> but that may be db specific.
>
> If you don't have too many records you can do:
>
> rows = ( db(db.dataset1).select() | db(db.dataset2).select() ).sort(lambda
> row: row.date)
>
>
>
> On Saturday, 15 December 2012 08:43:35 UTC-6, Mamisoa Andriantafika wrote:
>>
>> Hi,
>>
>> I have this db model:
>>
>> db.define_table('patients',
>> Field('name', 'string', length=32),
>> Field('firstname', 'string', length=32),
>> Field('dob', 'date'),
>> format='%(name)s')
>>
>> db.define_table('dataset1',
>> Field('date', 'date', length=32),
>> Field('param1', 'string', length=50),
>> Field('param2', 'string', length=50),
>> Field('patient_id', db.patients, writable=False, readable=False))
>>
>> db.define_table('dataset2',
>> Field('date', 'date', notnull=True),
>> Field('test1', 'text'),
>> Field('patient_id', db.patients, writable=False, readable=True))
>>
>> I'd like to show in one view, for 1 patient_id, all the corresponding
>> dataset1 and dataset2 ordered by date.
>>
>> What query should I use? Do I have to use an intermediate table 'history'
>> to record each activity in dataset1/2 to get a result?
>>
>> Thanks for help.
>>
>
--
