Create message according to location of the organization

[Daiana Perri]

I would like to set up different notifications according to the location of the organization.
For example, if a ticket is generated by a user of an organization that has an organization that is in location “Argentina” that has a custom email, different from the organization that is in location “Chile”, I would like to set up different notifications according to the location of the organization.
Is this possible?

[Stephen Abello]

Hi,
This is indeed possible.

If you need to send different notification depending on the organization of the caller, the service, the service family, or any data available on the Ticket, this can be done by creating multiple trigger/action couples, using a filter on the Trigger.

For example, you want to filter the UserRequests where the Organization of the caller is the Organization of the Location "Argentina" as follow:

SELECT UserRequest AS ur JOIN Organization AS o ON ur.org_id = o.id JOIN Location AS l ON l.org_id = o.id WHERE l.name ="Argentina"

Then you only need to create a Trigger that'll only be called in this specific case by putting this query in the filter

I hope this helps
Stephen