Table Variable in email (task)

[Bleman1]

Hi all,

 

I have a problem with table variable in my email (task):

 

- 1. There is a table jobs with multiple jobs in different categories

- 2. There is a table  freelancers where freelancers can insert which category jobs they want to receive via email.

At this moment, a freelancers receives an email with all jobs posted within the last 5 days when they criteria equals ICT, but I just want them to receive the ICT jobs instead of all posted jobs.

 

Anyone a suggestion?

Tanks a lot!

Bleman

 

 

 

 

[NiceDuck]

Do you have a field there on either one of the table involves that can be used to Identify if the record is an ICT Job? If yes,  just add another conditional statement on the where clause for that filter.