CMDBuild Forum

How to use SQL query to get value from table in Notification s - Templares

Hi all,

Anyone can help me how to query value of CISubset table based on {client.CISubset} in Preventive maintenance for Planning ? as image, I added sql query to get Description of CISubset

image

I set sql query for them (PM01 -Opening-Advance, PM02-Assignment-Advance, PM03-Execution-Advance, PM04-Suspension-Advance) the same

then I checked Email in Preventive maintenance

  • Planning
    image
    It shows what I’ve typed.

  • Execution
    image
    It shows description value as I expected

Thank you.
Phan.