Displaying 1 result from an estimated 1 matches for "folder_label".
2006 Aug 17
1
How to sort child table on fields in the associated parent
...es.
That is:
patients folders studies
id id id
name patient_id folder_id
... label type
... ...
The list of studies with their associated folder and patient might look
like this:
name folder_label study_type
Brown,Sam brsa1 CXR
Jones,Gary jg99999 CXR
Jones,Gary joga15 CT
Smith,Rob smro4 CXR
Smith,Rob smro4 CT
I want to present my user with a list of all studies of type ''CXR''
sorted by the p...