(OQL Query): Send a email to the user's manager

[Rosario.F]

Hi Guys,

in my iTop (2.7) I have created a lot of notifications with which I send an email to the person who opened the ticket. In the "TO" field I used the query:

"SELECT Person WHERE id =: this-> caller_id"

Now, I'd also like to send a carbon copy (CC) email to the user's function manager.
Could you help me to write the quely?

Thank you so much,
Rosario

[Vincent @ Combodo]

SELECT Person AS manager 
JOIN Person AS employee ON employee.manager_id = manager.id
WHERE employee.id=:this->caller_id

[Rosario.F]

Thank you so much Vincent,
your query works

[Jeffrey Bostoen]

One way to do it, would be to extend the ticket class with an AttributeExternalField so you can add caller_manager_id to the ticket class. Additional benefit: you can show the manager in the ticket presentation if wanted.

Then the query becomes as simple as

SELECT Person WHERE id = :this->caller_id OR id = :this->caller_manager_id

[Rosario.F]

Thanks for the tip Jeffrey, I solved it with Vincent's query