/** * Requests all records matching the query. * * @param query * never <code>null</code> * @return all records matching the query, may be empty but never <code>null</code> * @throws FilterEvaluationException */ public MetadataResultSet<ISORecord> getRecords( MetadataQuery query ) throws FilterEvaluationException { if ( query == null ) { throw new IllegalArgumentException( "MetadataQuery must not be null!" ); } List<ISORecord> result = applyFilter( query.getFilter(), query.getStartPosition(), query.getMaxRecords() ); return new ListMetadataResultSet( result ); }
if ( query != null && query.getStartPosition() != 1 && dialect.getClass().getSimpleName().equals( "MSSQLDialect" ) ) { String oldHeader = idSelect.toString(); if ( query != null && ( query.getStartPosition() != 1 || query.getMaxRecords() > -1 ) && dialect.getClass().getSimpleName().equals( "OracleDialect" ) ) { String oldHeader = idSelect.toString(); idSelect = new StringBuilder(); idSelect.append( "select * from ( " ); if ( query.getStartPosition() != 1 ) { idSelect.append( "select a.*, ROWNUM rnum from (" ); if ( query != null && query.getStartPosition() != 1 && dialect instanceof PostGISDialect ) { idSelect.append( " OFFSET " ).append( Integer.toString( query.getStartPosition() - 1 ) ); if ( query != null && query.getStartPosition() != 1 && dialect.getClass().getSimpleName().equals( "MSSQLDialect" ) ) { idSelect.append( ") as X1 where X1.rownum > " ); idSelect.append( query.getStartPosition() - 1 ); if ( query != null && ( query.getStartPosition() != 1 || query.getMaxRecords() > -1 ) && dialect.getClass().getSimpleName().equals( "OracleDialect" ) ) { idSelect.append( " ) " ); if ( query.getStartPosition() != 1 ) { idSelect.append( " a " ); if ( query.getStartPosition() != -1 ) { max += query.getStartPosition();
idSelect.append( wb.getOrderBy().getSQL() ); if ( query != null && query.getStartPosition() != 1 ) { idSelect.append( " OFFSET " ).append( Integer.toString( query.getStartPosition() - 1 ) );