The following figure provides 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
Unique Key (Index Section)
Data Source Section
Custom SQL Example
Custom SQL used for the example follows.
| Code Block | ||
|---|---|---|
| ||
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.
| Code Block | ||
|---|---|---|
| ||
sourcename,effectivedate,fromeffectivedate,toeffectivedate,entityfilter,entityid,xrefaccountid,spddeltafilter |
Other Filters Example
Other filters used:
Name | WHERE Clause |
|---|---|
| fromdate | MASTERTABLE.CREATE_DATE >= :fromdate |
| todate | MASTERTABLE.CREATE_DATE <= :todate |
On this page
| Table of Contents |
|---|