Skip navigation links

oracle.bpel.services.workflow.repos
Class Ordering

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

All Implemented Interfaces:

java.io.Serializable

public final 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.

Method Summary

void	addClause(Column column, boolean isAscending, boolean isNullFirst) To add the more orderby columns.
java.lang.String	getOrderBy() Return ordering string, Used by the persitency service to create SQL query
java.util.List	getOrderColumns() Returns the list of columns in the orderby part of the resulting SQL statement
java.util.List	getOrderingClauseList() getOrderingClauseList returns the ordering clause list
java.lang.String	toString() Return ordering string, Used by the persitency service to create SQL query

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(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

public java.lang.String getOrderBy()

Return ordering string, Used by the persitency service to create SQL query

Returns:

String Order by sql string

toString

public java.lang.String toString()

Return ordering string, Used by the persitency service to create SQL query

Overrides:

toString in class java.lang.Object

Returns:

String Order by sql string

getOrderColumns

public java.util.List getOrderColumns()

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

Returns:

getOrderingClauseList

public java.util.List getOrderingClauseList()

getOrderingClauseList returns the ordering clause list

Skip navigation links