com.oracle.e1.aisclient

Class DataRequest

java.lang.Object

com.oracle.e1.aisclient.AISRequest

com.oracle.e1.aisclient.JASRequestBase

com.oracle.e1.aisclient.FSRParent

com.oracle.e1.aisclient.DataRequest

public class DataRequest
extends FSRParent

Use the DataRequest object to request data from a view or table in EnterpriseOne. You define if the request is for a browse (where records are returned) or a count where just the number of records matching the query is returned.

        //indicate that data service capability is being used
        loginEnv.getUsedCapabilities().add(AISClientCapability.DATA_SERVICE);

        //created the data request
        DataRequest children = new DataRequest(loginEnv);

        //it is a count type
        children.setDataServiceType(DataRequest.TYPE_COUNT);

        //over the F0150 table
        children.setTargetName("F0150");
        //indicate table type
        children.setTargetType(DataRequest.TARGET_TABLE);

        //create a query
        Query childrenQ = new Query(loginEnv);
        //set it to do a find
        childrenQ.setAutoFind(true);
        //match all conditions
        childrenQ.setMatchType(Query.MATCH_ALL);

        //first condition is value of ES in the OSTP column
        childrenQ.addStringCondition("F0150.OSTP", StringOperator.EQUAL(), "ES");
        //second condition is value of 7500 in the PA8 column
        childrenQ.addStringCondition("F0150.PA8", StringOperator.EQUAL(), "7500");

        //set the query to the request
        children.setQuery(childrenQ);

        //send the request in, indicatging the data service uri
        String response = JDERestServiceProvider.jdeRestServiceCall(loginEnv, children, JDERestServiceProvider.POST_METHOD, JDERestServiceProvider.DATA_SERVICE_URI);

        //marchal the response to the CountResponse class
        CountResponse childrenCount = loginEnv.getObjectMapper().readValue(response, CountResponse.class);

        //print out the count
        System.out.println(childrenCount.getCount());
 

Field Summary

Fields

Modifier and Type	Field and Description
static java.lang.String	TARGET_TABLE
static java.lang.String	TARGET_VIEW
static java.lang.String	TYPE_AGGREGATION
static java.lang.String	TYPE_BROWSE
static java.lang.String	TYPE_COUNT

Fields inherited from class com.oracle.e1.aisclient.JASRequestBase

GRID_DATA_OUTPUT_TYPE, VERSION2_OUTPUT_TYPE

Constructor Summary

Constructors

Modifier	Constructor and Description
protected	DataRequest()
	DataRequest(LoginEnvironment loginEnv)

Method Summary

Modifier and Type	Method and Description
void	addOrderBy(LoginEnvironment loginEnv, java.lang.String tableId, java.lang.String columnId, OrderByDirection direction) Use this method to add an order by to the request
AggregationInfo	getAggregation()
java.lang.String	getDataServiceType()
Having	getHaving()
int	getNextPageTimeInterval()
java.lang.String	getNextPageTimeInterval1()
java.lang.String	getTargetName()
java.lang.String	getTargetType()
boolean	isEnableNextPageProcessing()
void	setAggregation(AggregationInfo aggregation)
void	setDataServiceType(java.lang.String dataServiceType)
void	setEnableNextPageProcessing(boolean enableNextPageProcessing)
void	setHaving(Having having)
void	setNextPageTimeInterval(int nextPageTimeInterval)
void	setTargetName(java.lang.String targetName)
void	setTargetType(java.lang.String targetType)

Methods inherited from class com.oracle.e1.aisclient.FSRParent

addFSREvent, getFindOnEntry, getFormActions, getFormServiceDemo, getLoadBaseFormOnly, getMaxPageSize, getOutputType, getQuery, getQueryObjectName, getReturnControlIDs, isAliasNaming, isShowActionControls, setAliasNaming, setFindOnEntry, setFindOnEntry, setFormActions, setFormServiceDemo, setFormServiceDemo, setJasserver, setLoadBaseFormOnly, setMaxPageSize, setMaxPageSize, setMaxPageSizeUnlimited, setOutputType, setQuery, setQueryObjectName, setReturnControlIDs, setShowActionControls

Methods inherited from class com.oracle.e1.aisclient.JASRequestBase

getCacheTime, isAllowCache, isForceUpdate, isIncludeTimings, isSetDirtyOnly, setAllowCache, setCacheTime, setForceUpdate, setIncludeTimings, setOutputType, setSetDirtyOnly

Methods inherited from class com.oracle.e1.aisclient.AISRequest

getDeviceName, getEnvironment, getJasserver, getPassword, getPsToken, getRole, getSsoUniqueId, getToken, getUsername, isSsoEnabled, setDeviceName, setEnvironment, setPassword, setPsToken, setRole, setSsoEnabled, setSsoUniqueId, setToken, setUsername

Methods inherited from class java.lang.Object

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

Field Detail

TARGET_TABLE

public static final java.lang.String TARGET_TABLE

See Also:

Constant Field Values

TARGET_VIEW

public static final java.lang.String TARGET_VIEW

See Also:

Constant Field Values

TYPE_BROWSE

public static final java.lang.String TYPE_BROWSE

See Also:

Constant Field Values

TYPE_COUNT

public static final java.lang.String TYPE_COUNT

See Also:

Constant Field Values

TYPE_AGGREGATION

public static final java.lang.String TYPE_AGGREGATION

See Also:

Constant Field Values

Constructor Detail

DataRequest

public DataRequest(LoginEnvironment loginEnv)
            throws CapabilityException

Throws:

CapabilityException

DataRequest

protected DataRequest()

Method Detail

setTargetName

public void setTargetName(java.lang.String targetName)

getTargetName

public java.lang.String getTargetName()

setTargetType

public void setTargetType(java.lang.String targetType)

getTargetType

public java.lang.String getTargetType()

setDataServiceType

public void setDataServiceType(java.lang.String dataServiceType)

getDataServiceType

public java.lang.String getDataServiceType()

setAggregation

public void setAggregation(AggregationInfo aggregation)

getAggregation

public AggregationInfo getAggregation()

addOrderBy

public void addOrderBy(LoginEnvironment loginEnv,
                       java.lang.String tableId,
                       java.lang.String columnId,
                       OrderByDirection direction)
                throws CapabilityException

Use this method to add an order by to the request

Parameters:

tableId -

columnId -

direction -

Throws:

CapabilityException

setHaving

public void setHaving(Having having)

getHaving

public Having getHaving()

setNextPageTimeInterval

public void setNextPageTimeInterval(int nextPageTimeInterval)

Overrides:

setNextPageTimeInterval in class JASRequestBase

getNextPageTimeInterval1

public java.lang.String getNextPageTimeInterval1()

getNextPageTimeInterval

public int getNextPageTimeInterval()

Overrides:

getNextPageTimeInterval in class JASRequestBase

setEnableNextPageProcessing

public void setEnableNextPageProcessing(boolean enableNextPageProcessing)

isEnableNextPageProcessing

public boolean isEnableNextPageProcessing()