Changes between Version 3 and Version 5 of Ticket #93


Ignore:
Timestamp:
06/11/2012 02:27:23 PM (14 years ago)
Author:
yuanhuoqing
Comment:

Legend:

Unmodified
Added
Removed
Modified

  • Ticket #93

    • Property Status changed from new to closed
    • Property Resolution changed from to fixed

  • Ticket #93 – Description

    v3 v5  
    22221、查出需要在索引页露出的配置项，示例sql（手机小类）如下： 
    2323{{{ 
     24 
    2425select * from (select * from pdl_config_item where group_flag=1 and config_id=20937 order by order_key asc, id) where rownum<=6 
     26 
    2527}}} 
    26282、循环上一步返回的配置项结果集，根据配置项id去查对应的自定义查询项， 
    2729示例sql（手机小类）如下： 
     30 
    2831{{{ 
     32 
    2933select * from pdl_defined_criteria t where t.group_flag = 1 and t.item_id = ? order by t.order_key asc 
     34 
    3035}}} 
     36 
    3137 
    3238二、如何根据筛选项查询产品