private String getCustomQuery() { if (StaticConfiguration.isVersioningProperties()) { return "SELECT R.REG_PATH_ID, R.REG_NAME FROM REG_RESOURCE R , REG_PROPERTY PP, REG_RESOURCE_PROPERTY RP" + "R.REG_VERSION=RP.REG_VERSION AND" + "RP.REG_PROPERTY_ID=PP.REG_ID AND PP.REG_NAME=? AND PP.REG_VALUE LIKE ?"; } else { return "SELECT R.REG_PATH_ID, R.REG_NAME FROM REG_RESOURCE R , REG_PROPERTY PP, REG_RESOURCE_PROPERTY RP" + "((R.REG_PATH_ID=RP.REG_PATH_ID AND R.REG_NAME = RP.REG_RESOURCE_NAME ) OR" + "(R.REG_PATH_ID=RP.REG_PATH_ID AND R.REG_NAME IS NULL AND RP.REG_RESOURCE_NAME IS NULL)) AND" + "RP.REG_PROPERTY_ID=PP.REG_ID AND PP.REG_NAME=? AND PP.REG_VALUE LIKE ?"; } }
tables.add(", REG_COMMENT C"); tables.add(", REG_RESOURCE_COMMENT RC"); if(StaticConfiguration.isVersioningComments()) { conditions.add("R.REG_VERSION=RC.REG_VERSION AND RC.REG_COMMENT_ID=C.REG_ID AND " + "C.REG_COMMENT_TEXT LIKE ?"); if(StaticConfiguration.isVersioningTags()) { tagClause.append("R.REG_VERSION=RT.REG_VERSION AND " + "RT.REG_TAG_ID=T.REG_ID "); tables.add(", REG_RESOURCE_PROPERTY RP"); StringBuffer propertyClause = new StringBuffer(); if(StaticConfiguration.isVersioningProperties()) { propertyClause.append("R.REG_VERSION=RP.REG_VERSION AND " + "RP.REG_PROPERTY_ID=PP.REG_ID");
tables.add(", REG_COMMENT C"); tables.add(", REG_RESOURCE_COMMENT RC"); if(StaticConfiguration.isVersioningComments()) { conditions.add("R.REG_VERSION=RC.REG_VERSION AND RC.REG_COMMENT_ID=C.REG_ID AND " + "C.REG_COMMENT_TEXT LIKE ?"); if(StaticConfiguration.isVersioningTags()) { tagClause.append("R.REG_VERSION=RT.REG_VERSION AND " + "RT.REG_TAG_ID=T.REG_ID "); tables.add(", REG_RESOURCE_PROPERTY RP"); StringBuffer propertyClause = new StringBuffer(); if(StaticConfiguration.isVersioningProperties()) { propertyClause.append("R.REG_VERSION=RP.REG_VERSION AND " + "RP.REG_PROPERTY_ID=PP.REG_ID");
private String getCustomQuery() { if (StaticConfiguration.isVersioningProperties()) { return "SELECT R.REG_PATH_ID, R.REG_NAME FROM REG_RESOURCE R , REG_PROPERTY PP, REG_RESOURCE_PROPERTY RP" + "R.REG_VERSION=RP.REG_VERSION AND" + "RP.REG_PROPERTY_ID=PP.REG_ID AND PP.REG_NAME=? AND PP.REG_VALUE LIKE ?"; } else { return "SELECT R.REG_PATH_ID, R.REG_NAME FROM REG_RESOURCE R , REG_PROPERTY PP, REG_RESOURCE_PROPERTY RP" + "((R.REG_PATH_ID=RP.REG_PATH_ID AND R.REG_NAME = RP.REG_RESOURCE_NAME ) OR" + "(R.REG_PATH_ID=RP.REG_PATH_ID AND R.REG_NAME IS NULL AND RP.REG_RESOURCE_NAME IS NULL)) AND" + "RP.REG_PROPERTY_ID=PP.REG_ID AND PP.REG_NAME=? AND PP.REG_VALUE LIKE ?"; } }
private String getCustomQuery() { if (StaticConfiguration.isVersioningProperties()) { return "SELECT R.REG_PATH_ID, R.REG_NAME FROM REG_RESOURCE R , REG_PROPERTY PP, REG_RESOURCE_PROPERTY RP" + "R.REG_VERSION=RP.REG_VERSION AND" + "RP.REG_PROPERTY_ID=PP.REG_ID AND PP.REG_NAME=? AND PP.REG_VALUE LIKE ?"; } else { return "SELECT R.REG_PATH_ID, R.REG_NAME FROM REG_RESOURCE R , REG_PROPERTY PP, REG_RESOURCE_PROPERTY RP" + "((R.REG_PATH_ID=RP.REG_PATH_ID AND R.REG_NAME = RP.REG_RESOURCE_NAME ) OR" + "(R.REG_PATH_ID=RP.REG_PATH_ID AND R.REG_NAME IS NULL AND RP.REG_RESOURCE_NAME IS NULL)) AND" + "RP.REG_PROPERTY_ID=PP.REG_ID AND PP.REG_NAME=? AND PP.REG_VALUE LIKE ?"; } }