How get result of previous task in chain?

[ukolovda]

For my example, I want run BUILTIN e-mail task and transfer its result (success/error message) in the next task for logging in the application table.

[ukolovda]

Made second task for single-running job:

      PERFORM timetable.add_task(
        kind => 'SQL',
        parent_id => v_mail_task_id,
        command => format(
$query$WITH
log(result, output) as (select
    case when returncode = 0 then 1 else 0 end,
    output
  from timetable.execution_log 
  where task_id=%s 
  order by last_run desc 
  limit 1),
insert_log(id) AS (INSERT INTO LOG_SEND_MAIL(
          SENDER, RECIPIENT, MESSAGE_TITLE, MAIL_TEXT, SENT_RESULT, ERROR_MESSAGE)
  select  %L,     %L,        %L,            %L,        log.result,  log.output
  from log
  returning SEND_MAIL_WITH_ATTACHMENT_ID)
select timetable.delete_job(%L)
  $query$,
      v_mail_task_id,
      MAIL.USER_LOGIN, cRECIPIENT, pMESSAGE_TITLE, pMAIL_TEXT, 
      v_job_name
      ),
    order_delta => 10
  );

[pashagolub]

Good catch! The formatting is a little bit odd though :)

[ukolovda]

Fixed formatting