public String sqlAD_getCustomizationChangeLogs(String vendorName,String catalogName,String schemaName){
  String searchTableName="AD_ChangeLog";
  ArrayList<String> columnNames=new ArrayList<String>();
  columnNames.add("t0.TableName");
  columnNames.add("t.Record_ID");
  columnNames.add("t1.ColumnName");
  columnNames.add("t.NewValue");
  columnNames.add("t2.Name");
  ArrayList<String> aliasNames=new ArrayList<String>();
  aliasNames.add("TABLENAME");
  aliasNames.add("RECORDID");
  aliasNames.add("COLUMNNAME");
  aliasNames.add("NEWVALUE");
  aliasNames.add("DISPLAYTYPE");
  ArrayList<String> joinTypes=new ArrayList<String>();
  ArrayList<String> joinTables=new ArrayList<String>();
  ArrayList<String> joinConditions=new ArrayList<String>();
  joinTypes.add("INNER JOIN");
  joinTables.add("AD_Table");
  joinConditions.add("t.AD_Table_ID = t0.AD_Table_ID");
  joinTypes.add("INNER JOIN");
  joinTables.add("AD_Column");
  joinConditions.add("t.AD_Table_ID = t1.AD_Table_ID AND t.AD_Column_ID = t1.AD_Column_ID");
  joinTypes.add("INNER JOIN");
  joinTables.add("AD_Reference");
  joinConditions.add("t1.AD_Reference_ID = t2.AD_Reference_ID");
  ArrayList<String> conditions=new ArrayList<String>();
  conditions.add("t.IsCustomization = 'Y'");
  conditions.add("t.IsActive = 'Y'");
  ArrayList<String> sortColumns=new ArrayList<String>();
  sortColumns.add("1");
  sortColumns.add("2");
  sortColumns.add("3");
  return sql_select(vendorName,catalogName,schemaName,searchTableName,null,columnNames,aliasNames,joinTypes,joinTables,null,joinConditions,conditions,sortColumns,false);
}

public String sqlAD_getCustomizationChangeLogs ( String vendorName , String catalogName , String schemaName ) { String searchTableName = "AD_ChangeLog" ; ArrayList < String > columnNames = new ArrayList < String > ( ) ; columnNames . add ( "t0.TableName" ) ; columnNames . add ( "t.Record_ID" ) ; columnNames . add ( "t1.ColumnName" ) ; columnNames . add ( "t.NewValue" ) ; columnNames . add ( "t2.Name" ) ; ArrayList < String > aliasNames = new ArrayList < String > ( ) ; aliasNames . add ( "TABLENAME" ) ; aliasNames . add ( "RECORDID" ) ; aliasNames . add ( "COLUMNNAME" ) ; aliasNames . add ( "NEWVALUE" ) ; aliasNames . add ( "DISPLAYTYPE" ) ; ArrayList < String > joinTypes = new ArrayList < String > ( ) ; ArrayList < String > joinTables = new ArrayList < String > ( ) ; ArrayList < String > joinConditions = new ArrayList < String > ( ) ; joinTypes . add ( "INNER JOIN" ) ; joinTables . add ( "AD_Table" ) ; joinConditions . add ( "t.AD_Table_ID = t0.AD_Table_ID" ) ; joinTypes . add ( "INNER JOIN" ) ; joinTables . add ( "AD_Column" ) ; joinConditions . add ( "t.AD_Table_ID = t1.AD_Table_ID AND t.AD_Column_ID = t1.AD_Column_ID" ) ; joinTypes . add ( "INNER JOIN" ) ; joinTables . add ( "AD_Reference" ) ; joinConditions . add ( "t1.AD_Reference_ID = t2.AD_Reference_ID" ) ; ArrayList < String > conditions = new ArrayList < String > ( ) ; conditions . add ( "t.IsCustomization = 'Y'" ) ; conditions . add ( "t.IsActive = 'Y'" ) ; ArrayList < String > sortColumns = new ArrayList < String > ( ) ; sortColumns . add ( "1" ) ; sortColumns . add ( "2" ) ; sortColumns . add ( "3" ) ; return sql_select ( vendorName , catalogName , schemaName , searchTableName , null , columnNames , aliasNames , joinTypes , joinTables , null , joinConditions , conditions , sortColumns , false ) ; }
gets the database specific sql command to find customizations which must be re - applied
