/** Obtains filter for TableSQLData */ public void getFilter( SQLReturnObject result, boolean isNewFilter, VariablesSecureApp vars, TableSQLData tableSQL, Vector<String> filter, Vector<String> filterParams, Properties prop) throws Exception { String aux; if (isNewFilter) { aux = vars.getRequestGlobalVariable( "inpParam" + prop.getProperty("ColumnName"), tableSQL.getTabID() + "|param" + prop.getProperty("ColumnName")); } else { aux = vars.getSessionValue(tableSQL.getTabID() + "|param" + prop.getProperty("ColumnName")); } // The filter is not applied if the parameter value is null or // parameter value is '%' for string references. if (!aux.equals("")) { UIReferenceUtility.addFilter( filter, filterParams, result, tableSQL, prop.getProperty("ColumnName"), prop.getProperty("ColumnName"), reference, true, aux); } if (addSecondaryFilter) { if (isNewFilter) { aux = vars.getRequestGlobalVariable( "inpParam" + prop.getProperty("ColumnName") + "_f", tableSQL.getTabID() + "|param" + prop.getProperty("ColumnName") + "_f"); } else { aux = vars.getSessionValue( tableSQL.getTabID() + "|param" + prop.getProperty("ColumnName") + "_f"); } if (!aux.equals("")) { UIReferenceUtility.addFilter( filter, filterParams, result, tableSQL, prop.getProperty("ColumnName"), prop.getProperty("ColumnName") + "_f", reference, false, aux); } } }
public void setComboTableDataIdentifier( ComboTableData comboTableData, String tableName, FieldProvider field) throws Exception { if (!UIReferenceUtility.checkTableTranslation(comboTableData, tableName, field, reference)) { comboTableData.addSelectField( UIReferenceUtility.formatField( comboTableData.getVars(), reference, (((tableName != null && tableName.length() != 0) ? (tableName + ".") : "") + field.getField("name"))), "NAME"); } }
/** Helper method called from generateSQL to create the SQL for the identifier */ protected void identifier( TableSQLData tableSql, String parentTableName, Properties field, String identifierName, String realName, boolean tableRef) throws Exception { if (field == null) return; if (!UIReferenceUtility.checkTableTranslation( tableSql, parentTableName, field, reference, identifierName, realName, tableRef)) { tableSql.addSelectField( UIReferenceUtility.formatField( tableSql.getVars(), reference, (parentTableName + "." + field.getProperty("ColumnName"))), identifierName); } }