com.oracle.e1.aisclient.query

Class Query

java.lang.Object

com.oracle.e1.aisclient.query.Query

public class Query
extends java.lang.Object

Query object holds all of the query conditions you want to be applied to an EnerpriesOne form query. Query can only be executed against AIS server with the 'query' capability available.

Version:

1.1 Query is new in version 1.1 of API, and is dependent on AIS version 9.1.5.2

Field Summary

Fields

Modifier and Type	Field and Description
static java.lang.String	MATCH_ALL
static java.lang.String	MATCH_ANY
protected static java.lang.String	STR_SV_LITERAL

Constructor Summary

Constructors

Constructor and Description
Query(LoginEnvironment loginEnv) Create a Query, and add it to a form request, to apply that query to the request.

Method Summary

Methods

Modifier and Type	Method and Description
BetweenCondition	addBetweenCondition(java.lang.String controlId) Add a between condition to determine if a field value is between to other specified values.
DateCondition	addDateCondition(java.lang.String controlId, DateOperator dateOperator) Add a date condition to compare a date field to a date value based on the specified date operator
ListCondition	addListCondition(java.lang.String controlId) After creating the Query object you can add a list condition, to compare a field to a list of values.
NumberCondition	addNumberCondition(java.lang.String controlId, NumericOperator numOperator) Add a number condition to compare a numeric field from the form to a numeric value
StringCondition	addStringCondition(java.lang.String controlId, StringOperator strOperator, java.lang.String value) Add a string condition to compare a string feild from the form to a string value
StringCondition	addStringConditionUserId(java.lang.String controlId, StringOperator strOperator) Add a string condition user id to compare a string field from the form to the currently logged in user id
java.util.ArrayList<Condition>	getCondition()
java.lang.String	getMatchType()
boolean	isAutoClear()
boolean	isAutoFind()
void	setAutoClear(boolean autoClear) Set AutoClear to true to clear the form before performing the query
void	setAutoFind(boolean autoFind) Set AutoFind to true to automatically press the find button to popoulate the reocrds.
protected void	setCondition(java.util.ArrayList<Condition> condition)
void	setMatchType(java.lang.String matchType) Set the match type to MATCH_ALL to indicate all of the conditions must be met (AND).

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Detail

MATCH_ALL

public static final java.lang.String MATCH_ALL

See Also:

Constant Field Values

MATCH_ANY

public static final java.lang.String MATCH_ANY

See Also:

Constant Field Values

STR_SV_LITERAL

protected static java.lang.String STR_SV_LITERAL

Constructor Detail

Query

public Query(LoginEnvironment loginEnv)
      throws CapabilityException

Create a Query, and add it to a form request, to apply that query to the request.

Parameters:

loginEnv -

Throws:

CapabilityException

Method Detail

addListCondition

public ListCondition addListCondition(java.lang.String controlId)

After creating the Query object you can add a list condition, to compare a field to a list of values.

Parameters:

controlId -

Returns:

addBetweenCondition

public BetweenCondition addBetweenCondition(java.lang.String controlId)

Add a between condition to determine if a field value is between to other specified values.

Parameters:

controlId -

Returns:

addDateCondition

public DateCondition addDateCondition(java.lang.String controlId,
                             DateOperator dateOperator)

Add a date condition to compare a date field to a date value based on the specified date operator

Parameters:

controlId -

operator -

Returns:

addNumberCondition

public NumberCondition addNumberCondition(java.lang.String controlId,
                                 NumericOperator numOperator)

Add a number condition to compare a numeric field from the form to a numeric value

Parameters:

controlId -

numOperator -

Returns:

addStringCondition

public StringCondition addStringCondition(java.lang.String controlId,
                                 StringOperator strOperator,
                                 java.lang.String value)

Add a string condition to compare a string feild from the form to a string value

Parameters:

controlId -

strOperator -

value -

Returns:

addStringConditionUserId

public StringCondition addStringConditionUserId(java.lang.String controlId,
                                       StringOperator strOperator)

Add a string condition user id to compare a string field from the form to the currently logged in user id

Parameters:

controlId -

strOperator -

Returns:

setCondition

protected void setCondition(java.util.ArrayList<Condition> condition)

getCondition

public java.util.ArrayList<Condition> getCondition()

setAutoFind

public void setAutoFind(boolean autoFind)

Set AutoFind to true to automatically press the find button to popoulate the reocrds. If using FormActions and pressing the find button you should not set it to true here or a double find will execute.

Parameters:

autoFind -

isAutoFind

public boolean isAutoFind()

setMatchType

public void setMatchType(java.lang.String matchType)

Set the match type to MATCH_ALL to indicate all of the conditions must be met (AND). Set match type to MATCH_ANY to indicate any of the conditions can be met (OR). The default is MATCH_ALL

Parameters:

matchType -

getMatchType

public java.lang.String getMatchType()

setAutoClear

public void setAutoClear(boolean autoClear)

Set AutoClear to true to clear the form before performing the query

Parameters:

autoClear -

isAutoClear

public boolean isAutoClear()