private Query buildQuery() { logger.debug("IN"); Query query = null; try { QbeEngineInstance qbeEngineInstance = getEngineInstance(); Map env = qbeEngineInstance.getEnv(); query = new Query(); query.setDistinctClauseEnabled(false); IModelEntity entity = getSelectedEntity(); QbeEngineInstance engineInstance = getEngineInstance(); QbeTemplate template = engineInstance.getTemplate(); registryConfig = (RegistryConfiguration) template.getProperty("registryConfiguration"); List<Column> columns = registryConfig.getColumns(); columnMaxSize = registryConfig.getColumnsMaxSize(); Iterator<Column> it = columns.iterator(); Map<String, String> fieldNameIdMap = new HashMap<String, String>(); while (it.hasNext()) { Column column = it.next(); getMandatoryMetadata(column); getColumnsInfos(column); IModelField field = getColumnModelField(column, entity); if (field == null) { logger.error("Field " + column.getField() + " not found!!"); } else { String name = field.getPropertyAsString("label"); if (name == null || name.length() == 0) { name = field.getName(); } String sorter = column.getSorter() != null && (column.getSorter().equalsIgnoreCase("ASC") || column.getSorter().equalsIgnoreCase("DESC")) ? column.getSorter().toUpperCase() : null; query.addSelectFiled( field.getUniqueName(), "NONE", field.getName(), true, true, false, sorter, field.getPropertyAsString("format")); fieldNameIdMap.put(column.getField(), field.getUniqueName()); } } // get Drivers and filters List<RegistryConfiguration.Filter> filters = registryConfig.getFilters(); int i = 0; ArrayList<ExpressionNode> expressionNodes = new ArrayList<ExpressionNode>(); for (Iterator iterator = filters.iterator(); iterator.hasNext(); ) { Filter filter = (Filter) iterator.next(); addFilter(i, query, env, fieldNameIdMap, filter, expressionNodes); i++; } // put together expression nodes if (expressionNodes.size() == 1) { query.setWhereClauseStructure(expressionNodes.get(0)); } else if (expressionNodes.size() > 1) { ExpressionNode exprNodeAnd = new ExpressionNode("NODE_OP", "AND"); exprNodeAnd.setChildNodes(expressionNodes); query.setWhereClauseStructure(exprNodeAnd); } } finally { logger.debug("OUT"); } return query; }