The following figure provides an example of a completed Edit Data Object form.
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 |
|---|---|
| fromdate | MASTERTABLE.CREATE_DATE >= :fromdate |
| todate | MASTERTABLE.CREATE_DATE <= :todate |
To save and close your custom Data Object:
- On the Solution tab, in the Manage group, click Save.
You see the Save current DataObject Definition box. - Click Save.
You can now close the form. - On the Solution tab, in the Manage group, click Close.
On this page
0 Comments