@PostConstruct public void populate() { orderList.clear(); list.clear(); employeeId = 0; orderList = em.createNamedQuery("EOrder.findByType&Status") .setParameter("orderType", "Purchase") .setParameter("status", "QC_Waiting") .getResultList(); for (int i = 0; i < orderList.size(); i++) { String prodCode = orderList.get(i).getEIntent().getProductCode(); int prodCatId = Integer.parseInt(prodCode.substring(0, prodCode.indexOf("."))); int prodId = Integer.parseInt(prodCode.substring(prodCode.indexOf(".") + 1)); orderListClass = new OrderListClass(); orderListClass.setSiteId(orderList.get(i).getEIntent().getESites().getId()); orderListClass.setSiteName(eSitesFacade.find(orderListClass.getSiteId()).getName()); orderListClass.setProductCategoryId(prodCatId); orderListClass.setProductCategoryName(eProductCategoryFacade.find(prodCatId).getName()); orderListClass.setProductId(prodId); orderListClass.setProductName(eProductFacade.find(prodId).getName()); orderListClass.setOrderId(orderList.get(i).getId()); orderListClass.setOrderDate(dateFormat.format(orderList.get(i).getDate())); orderListClass.setOrderQuantity(orderList.get(i).getProdQuantity()); orderListClass.setQuotationId(orderList.get(i).getSelectQuotationId()); orderListClass.setUnitPrice( eQuotationFacade.find(orderListClass.getQuotationId()).getUnitPrice()); orderListClass.setVendorId( eQuotationFacade.find(orderListClass.getQuotationId()).getEVendors().getId()); orderListClass.setVendorName(eVendorsFacade.find(orderListClass.getVendorId()).getVenName()); list.add(orderListClass); } }