Alert Composer

Hello,

Description:

i developed custom alert which do the following: "send email notification for all people which passport about to expire"

Problem:

in the template body, i need to use more information[extra Information] which is not provided by Resource APIs [emps, workers .. etc.]

Question:

is there any idea how to use the data returned in the custom filter expression ? 📢
is there any method to write custom sql inside template body [message Body]? 📢

like:
select Document_type

from HR_All_Document_Of_records HDOR

where person_id = ${PersonId}


since the passport information stored in DOR in our system not in per_passports.