CMDBuild Forum

Mail-Template lookup

Old Versions
#1

Hello,

 

I have a reference field added to a new class. I activated email notification on changes on that class and can access the values using the current context:

Data was changed on {current:Text1}

When it comes to reference fields (e.g. Employee) it only returns the number.

Can you give me an example how lookup the Employees name using the number for use in the email subject line ?

 

My further question is: Is it possible to access the previous values in the email body to create an email text like this:

 

The Value of Field X  was changed form OLD VALUE to NEW VALUE

 

Thanks,

Ulrich

#2
Dear Ulrich,
To retrieve the Employees name you could use something like this:
{cql:select Description from Employee where Id = {current:Text1}}
Regarding the second question I'm afraid it's not possible to access the previous values.
Regards,
CMDBuild Team