create_measure_adhoc_todo.htsql

/do(
  $_s_e := top(visit.filter(id()=$visit)).study_enrollment.id(),
  $_a_c := top(acquire_channel.filter(id()=$acquire_channel)).id(),
  $_title := if_null($title, '---'),
  $id := insert(todo := {
    individual := $individual,
    study_enrollment := $_s_e,
    expected_completion_date := $ecd,
    title := if_null($title, '---'),
    asset_type := 'measure',
    num_required_entries := $nre,
    acquire_channel := $_a_c
  }),
  for($_mtr := $mtr, with($_mtr,
    insert(measure_type_revision_x_todo := {
      todo := $id,
      measure_type_revision := $measure_type_revision
    })
  )),
  update(
    todo[$id].filter(title='---') {id(),
      title := top(measure_type_revision_x_todo).measure_type_revision
               .measure_type.title
  }),
  {id := $id}
)