25.2.6.7.3 Querying Activity Data On Demand

Query activity-level data to supply email fields and template placeholders.

As shown below, the Notify Rejection activity uses the following Additional Data query. It retrieves the sender's email, and the description of the requested medical procedure by joining in another table. The From field references the SENDER_EMAIL column value, while a placeholder value uses the DESCRIPTION column.

select prc.description,
       frc_app.get_sender_email as sender_email
from frc_patients pat
left join frc_medical_procedures prc
       on prc.code = pat.initial_procedure
where pat.id = :ID

The figure shows the App Builder Workflow Designer with the Notify Rejection activity selected in the diagram. The Property Editor shows the Additional Data SQL Query above, that includes a SENDER_EMAIL column in its select list. The Email Header section references its value using &SENDER_EMAIL. in the value of its From property.

Figure 25-98 Referencing Additional Data Columns in an Activity

Description of "Figure 25-98 Referencing Additional Data Columns in an Activity"