Versions Compared

Old Version 4

changes.mady.by.user Dmitry Donosiyan

Saved on

compared with

New Version 5

changes.mady.by.user Nancy Cohn

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

The following figure provides an example of a completed Edit Data Object form

...

.

Image Added

Custom SQL Example

Custom SQL used

...

for the example follows.

Code Block
languagesql
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.

Code Block
languagetext
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

...


To save your

...

custom Data Object:

On the Solution tab, in the Manage group, click Save. 
You can now close the form. 

On the Solution tab, in the Manage group, click Close. 

Image Added


On this page

Table of Contents