public String sqlAD_getTranslatedColumns(String vendorName,String catalogName,String schemaName){
  String searchTableName="AD_Column";
  ArrayList<String> columnNames=new ArrayList<String>();
  columnNames.add("t.ColumnName");
  ArrayList<String> aliasNames=null;
  ArrayList<String> joinTypes=new ArrayList<String>();
  joinTypes.add("INNER JOIN");
  ArrayList<String> joinTables=new ArrayList<String>();
  joinTables.add("AD_Table");
  ArrayList<String> joinConditions=new ArrayList<String>();
  joinConditions.add("t.AD_Table_ID = t0.AD_Table_ID");
  ArrayList<String> conditions=new ArrayList<String>();
  conditions.add("t0.TableName LIKE ?");
  conditions.add("t.IsTranslated = 'Y'");
  conditions.add("t.IsActive = 'Y'");
  ArrayList<String> sortColumns=new ArrayList<String>();
  sortColumns.add("1");
  return sql_select(vendorName,catalogName,schemaName,searchTableName,null,columnNames,aliasNames,joinTypes,joinTables,null,joinConditions,conditions,sortColumns,false);
}

public String sqlAD_getTranslatedColumns ( String vendorName , String catalogName , String schemaName ) { String searchTableName = "AD_Column" ; ArrayList < String > columnNames = new ArrayList < String > ( ) ; columnNames . add ( "t.ColumnName" ) ; ArrayList < String > aliasNames = null ; ArrayList < String > joinTypes = new ArrayList < String > ( ) ; joinTypes . add ( "INNER JOIN" ) ; ArrayList < String > joinTables = new ArrayList < String > ( ) ; joinTables . add ( "AD_Table" ) ; ArrayList < String > joinConditions = new ArrayList < String > ( ) ; joinConditions . add ( "t.AD_Table_ID = t0.AD_Table_ID" ) ; ArrayList < String > conditions = new ArrayList < String > ( ) ; conditions . add ( "t0.TableName LIKE ?" ) ; conditions . add ( "t.IsTranslated = 'Y'" ) ; conditions . add ( "t.IsActive = 'Y'" ) ; ArrayList < String > sortColumns = new ArrayList < String > ( ) ; sortColumns . add ( "1" ) ; 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 columns which have translations
