How to use

getOrderBy

method

in

org.deegree.sqldialect.filter.AbstractWhereBuilder

protected StringBuilder getPreparedStatementDatasetIDs( AbstractWhereBuilder builder ) {
  StringBuilder getDatasetIDs = new StringBuilder( 300 );
  String rootTableAlias = builder.getAliasManager().getRootTableAlias();
  getDatasetIDs.append( "SELECT DISTINCT " );
  getDatasetIDs.append( rootTableAlias );
  getDatasetIDs.append( '.' );
  getDatasetIDs.append( idColumn );
  // for SELECT DISTINCT, all ORDER BY columns have to be SELECTed as well
  if ( builder.getOrderBy() != null ) {
    // hack to transform the ORDER BY column list in select list
    String orderColList = builder.getOrderBy().getSQL().toString();
    int i = 1;
    while ( orderColList.contains( " ASC" ) || orderColList.contains( "DESC" ) ) {
      orderColList = orderColList.replaceFirst( " ASC| DESC", " AS crit" + ( i++ ) );
    }
    getDatasetIDs.append( ',' );
    getDatasetIDs.append( orderColList );
  }
  return getDatasetIDs;
}

if ( builder.getOrderBy() != null ) {
  for ( SQLArgument o : builder.getOrderBy().getArguments() ) {
    o.setArgument( stmt, i++ );

  idSelect.append( " WHERE " ).append( wb.getWhere().getSQL() );
if ( wb.getOrderBy() != null ) {
  idSelect.append( " ORDER BY " );
  idSelect.append( wb.getOrderBy().getSQL() );
if ( wb.getOrderBy() != null ) {
  for ( SQLArgument argument : wb.getOrderBy().getArguments() ) {
    argument.setArgument( stmt, i++ );

if ( builder.getOrderBy() != null ) {
  idSelect.append( " ORDER BY " );
  idSelect.append( builder.getOrderBy().getSQL() );
if ( builder.getOrderBy() != null ) {
  outerSelect.append( " ORDER BY " );
  String sortCols = builder.getOrderBy().getSQL().toString();
  String rootTableQualifier = builder.getAliasManager().getRootTableAlias() + ".";
  int columnCount = StringUtils.count( sortCols, "," ) + 1;
if ( builder.getOrderBy() != null ) {
  for ( SQLArgument o : builder.getOrderBy().getArguments() ) {
    o.setArgument( preparedStatement, i++ );
    arguments.add( o.getValue() );

String ftTableAlias = wb.getAliasManager().getRootTableAlias();
LOG.debug( "WHERE clause: " + wb.getWhere() );
LOG.debug( "ORDER BY clause: " + wb.getOrderBy() );
if ( wb.getOrderBy() != null ) {
  sql.append( " ORDER BY " );
  sql.append( wb.getOrderBy().getSQL() );
if ( wb.getOrderBy() != null ) {
  for ( SQLArgument o : wb.getOrderBy().getArguments() ) {
    o.setArgument( stmt, i++ );