Sending filtered Table Variable via Task Email Addressed based on filter

[kcastagnaro]

Hi. I am stumped by a problem. 

I have nurses who screen patients for clinical trials.  Once they screen, they enter a date into a follow-up field. I would like to send a email every Monday with a list of the patients who have follow-up dates coming in the next week. 

I have created a task with a table variable that looks like this. I didn't include it but the WHERE portion where I set the 7 day window works fine. In the exxample below, Screening.User_ID is the Nurse and I join it with User.User_ID so that I can access the nurse's email. 

The email portion is also working fine.

There are two nurses (Ginger & Ivana) who have patients with follow-up dates in the next 7 days. And Both Ginger and Ivana receive their own email with the table. 

 

The problem is that I want the email to Ginger to only contain Ginger's patients and the email to Ivana to only contain Ivana's patients.  

Any help would be so greatly appreciated!

Thank you!

 

[KlisaN137]

Hi @kcastagnaro,

Did you also joined (in the table variable level) Nurse ID (or name) from user table with the field that represent Nurse ID in the screening table?

[kcastagnaro]

Hi, thanks for trying to help me. I'm so stuck!

Yes, I did join the those two fields you mentioned. it's the section highlighted in green.  CTMS_t_User.User_ID is joined with CTMS_t_Screen.Screen_User_ID.

 

 

[kcastagnaro]

I was able to figure this out with some help from @CoopperBackpack in a different thread.

 

THANK YOU!