From: <ssk...@vh...> - 2005-12-05 15:48:07
|
Author: sskracic Date: 2005-12-05 16:45:52 +0100 (Mon, 05 Dec 2005) New Revision: 1025 Modified: trunk/ccm-cms/pdl/com/arsdigita/content-section/Search.pdl Log: This is continuation of r1022, where the changes that bring additional parameter 'descend' to the category filter are reverted. This time for CMS. Modified: trunk/ccm-cms/pdl/com/arsdigita/content-section/Search.pdl =================================================================== --- trunk/ccm-cms/pdl/com/arsdigita/content-section/Search.pdl 2005-12-05 15:35:53 UTC (rev 1024) +++ trunk/ccm-cms/pdl/com/arsdigita/content-section/Search.pdl 2005-12-05 15:45:52 UTC (rev 1025) @@ -39,25 +39,3 @@ } } -query searchCategoryObjectsDescend { - BigDecimal id; - - do { - select m.object_id - from cat_object_category_map m, - cat_cat_subcat_trans_index cc - where m.category_id = cc.subcategory_id - and cc.category_id in :ids - union - select i.item_id - from cat_object_category_map cm, - cat_cat_subcat_trans_index cc2, - cms_items i - where cc2.category_id in :ids - and cc2.subcategory_id = cm.category_id - and cm.object_id = i.parent_id - } map { - id = m.object_id; - } -} - |