Index: openacs-4/packages/cms/www/modules/items/index.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/cms/www/modules/items/index.xql,v
diff -u -r1.2 -r1.2.2.1
--- openacs-4/packages/cms/www/modules/items/index.xql 16 Nov 2004 22:32:48 -0000 1.2
+++ openacs-4/packages/cms/www/modules/items/index.xql 29 Nov 2005 21:36:05 -0000 1.2.2.1
@@ -5,23 +5,18 @@
select
- i.content_type, i.latest_revision, r.description
+ i.content_type, i.latest_revision, r.title,
+ r.description, o.pretty_name as type_pretty_name
from
- cr_items i, cr_revisions r
+ cr_items i, cr_revisions r, acs_object_types o
where
i.item_id = :item_id
and
r.revision_id = content_item__get_best_revision(:item_id)
+ and
+ i.content_type = o.object_type
-
-
-
- select title from cr_revisions where revision_id = :latest_revision
-
-
-
-