Public Interface Export Function › Design Objects › Dialog Flow Diagram Objects › DIALOG_FLOW › Task

Task

Select the source and destination procedure steps for a dialog flow. Order by source and destination names.

SELECT SRC.NAME, DLG.TYPE, DST.NAME
  FROM
  MODEL M,
  BUSINESS_SYS SYS,
  BUSINESS_PROC BP,
  BUS_PROC_STEP SRC,
  DIALOG_FLOW DLG,
  BUS_PROC_STEP DST
  WHERE
  M.NAME = 'my model name'
  AND SYS.NAME = 'my business system name'
  AND SYS.MODEL_ID = M.ID
  AND SRC.BUS_PROCEDURE_ID = BP.ID
  AND BP.BUSINESS_SYS_ID = SYS.ID
  AND DLG.INITS_P_STEP_ID = SRC.ID
  AND DLG.INITBY_P_STEP_ID = DST.ID
ORDER BY SRC.NAME, DST.NAME