Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 8 Next »

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

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

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
fromdateMASTERTABLE.CREATE_DATE >= :fromdate
todateMASTERTABLE.CREATE_DATE <= :todate



On this page

  • No labels