Custom EDS Data Object Example

The following figures provide an example of a completed Edit EDS Data Object form. For a description of each option, see EDS Data Object Definition Form Options.

General Information Section

EDS Data Object Definition - General Information Example

Unique Key (Index Section)

EDS Data Object Definition - Key Section

Data Source Section

Custom SQL Example

Custom SQL used for the example follows.

Select ord.BUS_TASK_ID BUS_TASK_ID, ord.SEND_BY SEND_BY, ord.CORRELATION_ID CORRELATION_ID, ord.CF_NAME CF_NAME, ord.PROC_STATUS PROC_STATUS, to_char(MASTERTABLE.CREATE_DATE,'YYYY-MM-DD HH24:MI:SS') CREATE_DATE, to_char(MASTERTABLE.UPDATE_DATE,'YYYY-MM-DD HH24:MI:SS') UPDATE_DATE, MASTERTABLE.ORCH_STATE_CLOB from pace_masterdbo.ORCH_REQUEST_DEF ord, pace_masterdbo.ORCH_QUEUE MASTERTABLE where ord.INSTANCE=MASTERTABLE.ORCH_REQ_DEF_INSTANCE and ord.CORRELATION_ID LIKE '%_DATA' and rownum <= 100

Filters Section

Common Filter Example

Common filters used for this example follow.

sourcename,effectivedate,fromeffectivedate,toeffectivedate,entityfilter,entityid,xrefaccountid,spddeltafilter

Other Filters Example

Other filters used:

Name

WHERE Clause

Name

WHERE Clause

fromdate

MASTERTABLE.CREATE_DATE >= :fromdate

todate

MASTERTABLE.CREATE_DATE <= :todate