Package oracle.bpel.services.workflow.repos

Class Ordering

java.lang.Object

oracle.bpel.services.workflow.repos.Ordering

All Implemented Interfaces:

Serializable

public class Ordering
extends Object
implements Serializable

See Also:

• Serialized Form

Field Summary

Fields

Modifier and Type	Field	Description
static final String	ASCENDING_ORDER	Ascending order
static final String	ASCSTRING	For ascending order
static final String	DESCENDING_ORDER	Descending order
static final String	DESCSTRING	For descending order

Constructor Summary

Constructors

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

Method Summary

Modifier and Type	Method	Description
void	addClause(Column column, boolean isAscending, boolean isNullFirst)	To add the more orderby columns.
String	getOrderBy()	Deprecated. since 11.1.1.2.0
List<String>	getOrderColumns()	Returns the list of columns in the orderby part of the resulting SQL statement
List<OrderingClauseType>	getOrderingClauseList()	getOrderingClauseList returns the ordering clause list
TaskOrderingType	getTaskOrderingType()	Returns TaskOrderingType JAXB representation of this Ordering object
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 Details

ASCSTRING

public static final String ASCSTRING

For ascending order

See Also:

• Constant Field Values

DESCSTRING

public static final String DESCSTRING

For descending order

See Also:

• Constant Field Values

ASCENDING_ORDER

public static final String ASCENDING_ORDER

Ascending order

See Also:

• Constant Field Values

DESCENDING_ORDER

public static final String DESCENDING_ORDER

Descending order

See Also:

• Constant Field Values

Constructor Details

Ordering

public Ordering(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:

Exception

WorkflowException

Method Details

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:

Exception

WorkflowException

getOrderBy

@Deprecated
public 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 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 Object

Returns:

String representation of the Ordering object.

getOrderColumns

public List<String> getOrderColumns()

Returns the list of columns in the orderby part of the resulting SQL statement

Returns:

getOrderingClauseList

public List<OrderingClauseType> getOrderingClauseList()

getOrderingClauseList returns the ordering clause list

getTaskOrderingType

public TaskOrderingType getTaskOrderingType()

Returns TaskOrderingType JAXB representation of this Ordering object

Returns: