스크린샷 2017-03-04 오후 9.51.25.png

각 항목 자체는 이상/이하 로 설정할수 있으나 항목 과 항목이 and 로 되어 있는것 같습니다. 

 

예를 들어

조회수 200이거나 추천수 5 이상 만족

조회수 200 또는 추천수 5 이상이면 으로 동작하게 수정 하고 싶습니다.

 

혹시 quires 파일을 수정해야 한다면 어떤 파일의 어디를 수정을 해야 할지 알려주시면 고맙겠습니다. 무턱대고 모두 or 로 변경해봐도 반응이 없는듯합니다.

스크린샷 2017-03-04 오후 10.01.49.png

  • ?

    예) 조회수 500이상 또는 추천수 5이상
    모두 가져오려고 하는 거죠?

     

    getDocumentList.xml

     

    <condition operation="excess" column="readed_count" var="tl_excess_readed_count" filter="number" pipe="and" />
    <condition operation="below" column="readed_count" var="tl_below_readed_count" filter="number" pipe="and" />
    <condition operation="more" column="readed_count" var="tl_more_readed_count" filter="number" pipe="and" />
    <condition operation="less" column="readed_count" var="tl_less_readed_count" filter="number" pipe="and" />
    <condition operation="excess" column="voted_count" var="tl_excess_voted_count" filter="number" pipe="and" />
    <condition operation="below" column="voted_count" var="tl_below_voted_count" filter="number" pipe="and" />
    <condition operation="more" column="voted_count" var="tl_more_voted_count" filter="number" pipe="and" />
    <condition operation="less" column="voted_count" var="tl_less_voted_count" filter="number" pipe="and" />
    <condition operation="below" column="blamed_count" var="tl_excess_blamed_count" filter="number" pipe="and" />
    <condition operation="excess" column="blamed_count" var="tl_below_blamed_count" filter="number" pipe="and" />
    <condition operation="less" column="blamed_count" var="tl_more_blamed_count" filter="number" pipe="and" />
    <condition operation="more" column="blamed_count" var="tl_less_blamed_count" filter="number" pipe="and" />
    <condition operation="excess" column="comment_count" var="tl_excess_comment_count" filter="number" pipe="and" />
    <condition operation="below" column="comment_count" var="tl_below_comment_count" filter="number" pipe="and" />
    <condition operation="more" column="comment_count" var="tl_more_comment_count" filter="number" pipe="and" />
    <condition operation="less" column="comment_count" var="tl_less_comment_count" filter="number" pipe="and" />
    <condition operation="excess" column="voted_count + blamed_count" var="tl_excess_popular_count" filter="number" pipe="and" />
    <condition operation="below" column="voted_count + blamed_count" var="tl_below_popular_count" filter="number" pipe="and" />
    <condition operation="more" column="voted_count + blamed_count" var="tl_more_popular_count" filter="number" pipe="and" />
    <condition operation="less" column="voted_count + blamed_count" var="tl_less_popular_count" filter="number" pipe="and" />

     

    변경

     

    <group pipe="and">
    <condition operation="excess" column="readed_count" var="tl_excess_readed_count" filter="number" pipe="or" />
    <condition operation="below" column="readed_count" var="tl_below_readed_count" filter="number" pipe="or" />
    <condition operation="more" column="readed_count" var="tl_more_readed_count" filter="number" pipe="or" />
    <condition operation="less" column="readed_count" var="tl_less_readed_count" filter="number" pipe="or" />
    <condition operation="excess" column="voted_count" var="tl_excess_voted_count" filter="number" pipe="or" />
    <condition operation="below" column="voted_count" var="tl_below_voted_count" filter="number" pipe="or" />
    <condition operation="more" column="voted_count" var="tl_more_voted_count" filter="number" pipe="or" />
    <condition operation="less" column="voted_count" var="tl_less_voted_count" filter="number" pipe="or" />
    <condition operation="below" column="blamed_count" var="tl_excess_blamed_count" filter="number" pipe="or" />
    <condition operation="excess" column="blamed_count" var="tl_below_blamed_count" filter="number" pipe="or" />
    <condition operation="less" column="blamed_count" var="tl_more_blamed_count" filter="number" pipe="or" />
    <condition operation="more" column="blamed_count" var="tl_less_blamed_count" filter="number" pipe="or" />
    <condition operation="excess" column="comment_count" var="tl_excess_comment_count" filter="number" pipe="or" />
    <condition operation="below" column="comment_count" var="tl_below_comment_count" filter="number" pipe="or" />
    <condition operation="more" column="comment_count" var="tl_more_comment_count" filter="number" pipe="or" />
    <condition operation="less" column="comment_count" var="tl_less_comment_count" filter="number" pipe="or" />
    <condition operation="excess" column="voted_count + blamed_count" var="tl_excess_popular_count" filter="number" pipe="or" />
    <condition operation="below" column="voted_count + blamed_count" var="tl_below_popular_count" filter="number" pipe="or" />
    <condition operation="more" column="voted_count + blamed_count" var="tl_more_popular_count" filter="number" pipe="or" />
    <condition operation="less" column="voted_count + blamed_count" var="tl_less_popular_count" filter="number" pipe="or" />
    </group>

     

    다른 쿼리들도 해당부분 응용해서 변경