Displaying 1 result from an estimated 1 matches for "explicated_studi".
Did you mean:
explicated_study
2006 Aug 17
1
How to sort child table on fields in the associated parent
...ike:
SELECT p.name, f.label, s.type
FROM patients p, folders f, studies s
WHERE f.id = s.folder_id
AND p.id = f.patient_id
AND s.type = ''CXR''
ORDER BY p.name, f.label
Is there a way to put this into a model so that the controller and view
code might simply deal with:
@explicated_studies = ExplicatedStudy.find(:all, :condition => "type in
(''CXR'', ''CT'')" )
and:
..
<td><%= explicated_study.name %></td>
<td><%= explicated_study.label %></td>
..
acts_as_list appears to allow accessing the lin...