protected void getPSBody( AbstractWhereBuilder builder, StringBuilder getDatasetIDs ) { String rootTableAlias = builder.getAliasManager().getRootTableAlias(); getDatasetIDs.append( " FROM " ); getDatasetIDs.append( mainTable ); getDatasetIDs.append( " " ); getDatasetIDs.append( rootTableAlias ); for ( PropertyNameMapping mappedPropName : builder.getMappedPropertyNames() ) { for ( Join join : mappedPropName.getJoins() ) { getDatasetIDs.append( " LEFT OUTER JOIN " ); getDatasetIDs.append( join.getToTable() ); getDatasetIDs.append( ' ' ); getDatasetIDs.append( join.getToTableAlias() ); getDatasetIDs.append( " ON " ); getDatasetIDs.append( join.getSQLJoinCondition() ); } } if ( builder.getWhere() != null ) { getDatasetIDs.append( " WHERE " ); getDatasetIDs.append( builder.getWhere().getSQL() ); } }
sql.append( ftTableAlias ); for ( PropertyNameMapping mappedPropName : wb.getMappedPropertyNames() ) { for ( Join join : mappedPropName.getJoins() ) { sql.append( " LEFT OUTER JOIN " );
for ( PropertyNameMapping mappedPropName : wb.getMappedPropertyNames() ) { for ( Join join : mappedPropName.getJoins() ) { sql.append( " LEFT OUTER JOIN " );
sql.append( ftTableAlias ); for ( PropertyNameMapping mappedPropName : wb.getMappedPropertyNames() ) { for ( Join join : mappedPropName.getJoins() ) { sql.append( " LEFT OUTER JOIN " );