/** Finds all the studies */ @Override public void processRequest() throws Exception { StudyDAO sdao = new StudyDAO(sm.getDataSource()); ArrayList studies = (ArrayList) sdao.findAll(); // find all parent studies ArrayList parents = (ArrayList) sdao.findAllParents(); ArrayList displayStudies = new ArrayList(); for (int i = 0; i < parents.size(); i++) { StudyBean parent = (StudyBean) parents.get(i); ArrayList children = (ArrayList) sdao.findAllByParent(parent.getId()); DisplayStudyBean displayStudy = new DisplayStudyBean(); displayStudy.setParent(parent); displayStudy.setChildren(children); displayStudies.add(displayStudy); } FormProcessor fp = new FormProcessor(request); EntityBeanTable table = fp.getEntityBeanTable(); ArrayList allStudyRows = DisplayStudyRow.generateRowsFromBeans(displayStudies); String[] columns = { resword.getString("name"), resword.getString("unique_identifier"), resword.getString("OID"), resword.getString("principal_investigator"), resword.getString("facility_name"), resword.getString("date_created"), resword.getString("status"), resword.getString("actions") }; table.setColumns(new ArrayList(Arrays.asList(columns))); table.hideColumnLink(2); table.hideColumnLink(6); table.setQuery("ListStudy", new HashMap()); table.addLink(resword.getString("create_a_new_study"), "CreateStudy"); table.setRows(allStudyRows); table.computeDisplay(); request.setAttribute("table", table); // request.setAttribute("studies", studies); session.setAttribute("fromListSite", "no"); resetPanel(); panel.setStudyInfoShown(false); panel.setOrderedData(true); setToPanel(resword.getString("in_the_application"), ""); if (parents.size() > 0) { setToPanel(resword.getString("studies"), new Integer(parents.size()).toString()); } if (studies.size() > 0) { setToPanel( resword.getString("sites"), new Integer(studies.size() - parents.size()).toString()); } forwardPage(Page.STUDY_LIST); }