private DiscrepancyNote createQuery(QueryServiceHelperBean helperBean, QueryBean queryBean) throws Exception { DiscrepancyNote dn = new DiscrepancyNote(); dn.setStudy(helperBean.getContainer().getStudy()); dn.setEntityType("itemData"); dn.setDescription("description"); dn.setDetailedNotes(queryBean.getComment()); dn.setDiscrepancyNoteType(new DiscrepancyNoteType(3)); if (queryBean.getStatus().equals("new")) { dn.setResolutionStatus(resolutionStatusDao.findById(1)); } else if (queryBean.getStatus().equals("updated")) { dn.setResolutionStatus(resolutionStatusDao.findById(2)); } else if (queryBean.getStatus().equals("closed")) { dn.setResolutionStatus(resolutionStatusDao.findById(4)); } String assignedTo = queryBean.getAssigned_to(); if (!StringUtils.isEmpty(assignedTo)) { int endIndex = assignedTo.indexOf(")"); int begIndex = assignedTo.indexOf("("); String userName = assignedTo.substring(begIndex + 1, endIndex); UserAccount userAccount = userAccountDao.findByUserName(userName); helperBean.setUserAccount(userAccount); dn.setUserAccount(userAccount); } dn.setUserAccountByOwnerId(helperBean.getContainer().getUser()); // create itemData when a query is created without an autosaved itemdata if (helperBean.getItemData() == null) { helperBean.setItemData(createBlankItemData(helperBean)); } dn.setDateCreated(new Date()); return dn; }