Index: src/main/java/com/napa/pulse/dao/impl/SessionDAOImpl.java =================================================================== diff -u -r2e97c222854d1a6b211cb7e42770dfec28fa481d -r80379a08363d3b64b3f8ec7750b2bd4fb1f642fa --- src/main/java/com/napa/pulse/dao/impl/SessionDAOImpl.java (.../SessionDAOImpl.java) (revision 2e97c222854d1a6b211cb7e42770dfec28fa481d) +++ src/main/java/com/napa/pulse/dao/impl/SessionDAOImpl.java (.../SessionDAOImpl.java) (revision 80379a08363d3b64b3f8ec7750b2bd4fb1f642fa) @@ -2101,7 +2101,7 @@ + " BLOCK_ORDER, BLOCK_RETURN, USER_ID, REASON_ID, FORECAST_MODEL_ID, CLUSTER_PCT_SALE, DC_SALES_LAST_12_MONTHS, " + " DC_SALES_LAST_24_MONTHS, TRANSFER_12_MONTHS, TRANSFER_24_MONTHS, PEER_SALES_12, REVIEWED, FLEET_FLAG, SYSTEM_FLAG, SYSTEM_RECOMMENDED, " + " EDIT_LINKED_SIM_PROD_ID, SIMILAR_PRODUCT_EDIT, DECLINE_ORDER, DECLINE_RETURN, LAST_SALE_DT, BUSINESS_RULES_APPLIED, HQ_ORDER_QTY, HQ_KEEP_QTY,ORG_MIN_STOCKING_QTY,ORG_MAX_STOCKING_QTY " - + " from session_site_product where site_Id = ? and session_id = ? and reviewed ?)" , s , sessionId , reviewOnly ? (" = 1") :("IN (select reviewed from session_site_product where session_id = "+sessionId+")") ); + + " from session_site_product where site_Id = ? and session_id = ? and reviewed "+ (reviewOnly ? (" =1) ") : ("IN (select reviewed from session_site_product where session_id =" +sessionId + ") or reviewed is null or reviewed =0 or reviewed=1 )") ), s , sessionId ) ; }