public void setResultColumns(List<ResultColumnInfo> resultColumns){ attrKeys = new ArrayList<String>(); for (ResultColumnInfo r:resultColumns){ attrKeys.add(r.getName()); } //Exclude identifier column from list items (don't want this displayed) attrKeys.remove(0); attrOffset = 1; }
rc = new ResultColumnInfo (); rcs.add (rc); rc.setKey (QuickViewByGivenName.ENTITY_ID_RESULT); rc.setDataType ("string"); rc.setName ("Entity Id"); rc.setDesc ("Internal id assigned to person"); rc = new ResultColumnInfo (); rcs.add (rc); rc.setKey (QuickViewByGivenName.PERSON_ID_RESULT); rc.setDataType ("string"); rc.setName ("Person ID"); rc.setDesc ("The Person's ID"); rc = new ResultColumnInfo (); rcs.add (rc); rc.setKey (QuickViewByGivenName.PRINCIPAL_NAME_RESULT); rc.setDataType ("string"); rc.setName ("Principalname"); rc.setDesc ("Principal name"); rc = new ResultColumnInfo (); rcs.add (rc); rc.setKey (QuickViewByGivenName.GIVEN_NAME_RESULT); rc.setDataType ("string"); rc.setName ("Given name"); rc.setDesc ("Given name, i.e. Smith, John"); rc = new ResultColumnInfo ();
builder.append (rc.getName ()); builder.append (colSeperator); builder.append (rc.getDataType ()); builder.append (colSeperator); builder.append (rc.getKey ()); builder.append (colSeperator); builder.append (rowSeperator);
String[] jpqlResultColumns = queryString.substring(selectIndex, fromIndex).replaceAll("\\s", "").split(","); for(ResultColumnInfo results : searchTypeInfo.getSearchResultTypeInfo().getResultColumns()){ if(results.getKey().equals(searchRequest.getSortColumn())){ if(results.getDataType()!=null && "string".equals(results.getDataType().toLowerCase())){ orderByClause = " ORDER BY LOWER(" + jpqlResultColumns[i] + ") "; }else{
resultCell.setKey(resultColumn.getKey());