In our projects table we have every version of a project. Is it possible to show only those projects where max(version_id) in the admin interface?
Thanks! :) Eric
A:
You mean like this?
SELECT Project, MAX(version_id) FROM <ProjectsTable> GROUP BY Project
hallie
2010-03-16 02:56:47
Yes, using a statement like that. The SQL is the easy part, but how to I get the admin page for the list of projects to display only the result of executing this statement.
Eric
2010-03-16 19:09:50
A:
you can use django views for this .In ur vies u can wirte any query which u need and render that on a template using a dictionary.
ha22109
2010-03-19 13:38:49
Right. But the question is how to do it in the admin interface.... I still need to know how to do it there. It is easy to do it in a view but how to do it in the admin interface. :)
Eric
2010-03-20 10:59:18