Index: src/main/java/com/napa/pulse/controller/rest/SessionRestController.java =================================================================== diff -u -r67a5b398154a952209a2644756fb670bffbd8d33 -rba270d62a3472b9538d0e718b44ba445262842c3 --- src/main/java/com/napa/pulse/controller/rest/SessionRestController.java (.../SessionRestController.java) (revision 67a5b398154a952209a2644756fb670bffbd8d33) +++ src/main/java/com/napa/pulse/controller/rest/SessionRestController.java (.../SessionRestController.java) (revision ba270d62a3472b9538d0e718b44ba445262842c3) @@ -1876,7 +1876,7 @@ @Track @RequestMapping(value = "auth/{sessionId}/{siteId}/selected-product-lines", method = RequestMethod.GET) - public String getMinMaxSessionSelectedProducts(@PathVariable(PulseConstants.SESSION_ID) int sessionId ,Integer siteId) + public String getMinMaxSessionSelectedProducts(@PathVariable(PulseConstants.SESSION_ID) int sessionId ,@PathVariable("siteId") Integer siteId) throws PulseException { try { List> list = sessionService.getMinMaxSessionSelectedProducts(sessionId, siteId); @@ -1888,7 +1888,7 @@ @Track @RequestMapping(value = "auth/{sessionId}/{siteId}/unselected-product-lines", method = RequestMethod.GET) - public String getMinMaxSessionUnselectedProducts(@PathVariable(PulseConstants.SESSION_ID) int sessionId,Integer siteId) + public String getMinMaxSessionUnselectedProducts(@PathVariable(PulseConstants.SESSION_ID) int sessionId,@PathVariable("siteId") Integer siteId) throws PulseException { try { List> list = sessionService.getMinMaxSessionUnselectedProducts(sessionId,siteId); Index: src/main/java/com/napa/pulse/dao/impl/SessionDAOImpl.java =================================================================== diff -u -rd89f1066ca9b3165ef0ad0a38d88aefd9a5136fb -rba270d62a3472b9538d0e718b44ba445262842c3 --- src/main/java/com/napa/pulse/dao/impl/SessionDAOImpl.java (.../SessionDAOImpl.java) (revision d89f1066ca9b3165ef0ad0a38d88aefd9a5136fb) +++ src/main/java/com/napa/pulse/dao/impl/SessionDAOImpl.java (.../SessionDAOImpl.java) (revision ba270d62a3472b9538d0e718b44ba445262842c3) @@ -4922,7 +4922,8 @@ public List> getMinMaxSessionSelectedProducts ( int sessionId,Integer siteId ) { return jdbcTemplate.queryForList ( "select mmcl.LINE_ID as \"id\", mmcl.FIELD_ABBR as \"code\", 'true' as \"line\", mmspl.order_cycle as \"orderCycle\",mmspl.lead_time as \"leadTime\" ,case when mmspl.per_car = 1 then 'true' else 'false' end as \"perCar\", 'true' as \"isStockEditOff\" " + "from MIN_MAX_CALC_LINE mmcl, MIN_MAX_SESSION_PROD_LINE mmspl \n" + - "where mmspl.SESSION_ID = " + sessionId + " and mmspl.PRODUCT_LINE_ID = mmcl.LINE_ID and mmcl.ACTIVE_FLAG = 1 order by mmcl.FIELD_ABBR" ); + "where mmspl.SESSION_ID = " + sessionId + " and mmspl.site_id = "+siteId+" and mmspl.PRODUCT_LINE_ID = mmcl.LINE_ID and mmcl.ACTIVE_FLAG = 1 order by mmcl.FIELD_ABBR" ); + } @Override