CMDBuild Forum

Synchronous Task - Email notification - Email template CQL

Old Versions
#1

Hi,

On version 2.4.1, can I use cql like this {cql:QueryCQLGetEmail.Email} on the email template when it's called by a synchronous task?

 

My values are: (QueryCQLGetEmail -> SELECT Email FROM Stakeholder WHERE Assignee IN (467) & Status='A')

 

 

Regars,

Mário Mourão

#2

Hi Mário,

you can write something like this, without using other variables: {cql: select Email from Stakeholder where Assignee in (467)}.

In CQL expressions the filter on the status is automatically done, so you have to remove it.

 

Best regards

CMDBuild Team

#3
Thanks it works
 
Best Regards,
Mário Mourão
 
Previously Tecnoteca wrote:

Hi Mário,

you can write something like this, without using other variables: {cql: select Email from Stakeholder where Assignee in (467)}.

In CQL expressions the filter on the status is automatically done, so you have to remove it.

 

Best regards

CMDBuild Team