Skip navigation links

Oracle Fusion Middleware
Java API Reference for Oracle BPM Suite
11g Release 1 (11.1.1.6.3)
E25378-06


oracle.bpel.services.workflow.repos
Class Ordering

java.lang.Object
  extended by oracle.bpel.services.workflow.repos.Ordering

All Implemented Interfaces:
java.io.Serializable

public class Ordering
extends java.lang.Object
implements java.io.Serializable
See Also:
Serialized Form

Field Summary
static java.lang.String ASCENDING_ORDER
          Ascending order
static java.lang.String ASCSTRING
          For ascending order
static java.lang.String DESCENDING_ORDER
          Descending order
static java.lang.String DESCSTRING
          For descending order

 

Constructor Summary
Ordering(Column column, boolean isAscending, boolean isNullFirst)
          Constructor to create the Ordering.
Ordering(java.util.List<OrderingClauseType> clauses)
          Constructs an Ordering object from a list of OrderingClauseType objects.

 

Method Summary
 void addClause(Column column, boolean isAscending, boolean isNullFirst)
          To add the more orderby columns.
 java.lang.String getOrderBy()
          Deprecated. since 11.1.1.2.0
 java.util.List<java.lang.String> getOrderColumns()
          Returns the list of columns in the orderby part of the resulting SQL statement
 java.util.List<OrderingClauseType> getOrderingClauseList()
          getOrderingClauseList returns the ordering clause list
 java.lang.String toString()
          Returns String representation of the Ordering object.

 

Methods inherited from class java.lang.Object
equals, getClass, hashCode, notify, notifyAll, wait, wait, wait

 

Field Detail

ASCSTRING

public static final java.lang.String ASCSTRING
For ascending order
See Also:
Constant Field Values

DESCSTRING

public static final java.lang.String DESCSTRING
For descending order
See Also:
Constant Field Values

ASCENDING_ORDER

public static final java.lang.String ASCENDING_ORDER
Ascending order
See Also:
Constant Field Values

DESCENDING_ORDER

public static final java.lang.String DESCENDING_ORDER
Descending order
See Also:
Constant Field Values

Constructor Detail

Ordering

public Ordering(java.util.List<OrderingClauseType> clauses)
Constructs an Ordering object from a list of OrderingClauseType objects. If an OrderingClauseType object specifies a column, it must also specify a table name.
Parameters:
clauses - a List of OrderingClauseType objects.

Ordering

public Ordering(Column column,
                boolean isAscending,
                boolean isNullFirst)
         throws WorkflowException
Constructor to create the Ordering. This column gets added to the SQL statement that gets executed with the options specified.
Parameters:
column - Name Column to order by
isAscending - true if the order isAscending else false
isNullFirst - true if the order contains null value first else false
Throws:
java.lang.Exception
WorkflowException

Method Detail

addClause

public void addClause(Column column,
                      boolean isAscending,
                      boolean isNullFirst)
               throws WorkflowException
To add the more orderby columns. This order gets added to the SQL statement that gets executed.
Parameters:
column - Name Column to order by
isAscending - true if the order isAscending else false
isNullFirst - true if the order contains null value first else false
Throws:
java.lang.Exception
WorkflowException

getOrderBy

@Deprecated
public java.lang.String getOrderBy()
Deprecated. since 11.1.1.2.0
Deprecated. Conversion of Ordering to database port-specific SQL statement is handled internally by the persistency service.
Returns:
String a deprecated Order by sql string, for Oracle databases only.

toString

public java.lang.String toString()
Returns String representation of the Ordering object. This representation is for informational purposes only. It should NOT be used to form part of a SQL statement.
Overrides:
toString in class java.lang.Object
Returns:
String representation of the Ordering object.

getOrderColumns

public java.util.List<java.lang.String> getOrderColumns()
Returns the list of columns in the orderby part of the resulting SQL statement
Returns:

getOrderingClauseList

public java.util.List<OrderingClauseType> getOrderingClauseList()
getOrderingClauseList returns the ordering clause list

Skip navigation links

Oracle Fusion Middleware
Java API Reference for Oracle BPM Suite
11g Release 1 (11.1.1.6.3)
E25378-06


Copyright © 2009, 2011, Oracle and/or its affiliates. All rights reserved.