/bundles/itninjaweb/img/Breadcrumb_cap_w.png
Hello,

I need to send an email to a email address group depending on a field in kbox, basically if the HD_TICKET.CUSTOM_FIELD_VALUE8 = 'Registers') then Send an email to the email group registers OR HD_TICKET.CUSTOM_FIELD_VALUE8 = 'Printers') then send an email to the email group Printers and so on.

I already have the rule below, but that one only sends an email to an address depending on one field:

select HD_TICKET.ID,
HD_TICKET.ID as TICKNUM,
HD_TICKET.TITLE,
HD_TICKET_CHANGE.COMMENT AS EMAIL_BODY,
U1.USER_NAME as OWNER_NAME,
U3.USER_NAME as LASTINPUTNAME,
DATE_FORMAT(HD_TICKET.CREATED,'%b %d %Y %I:%i:%s %p') as CREATED,
DATE_FORMAT(HD_TICKET.MODIFIED,'%b %d %Y %I:%i:%s %p') as MODIFIED,
HD_STATUS.NAME AS STATUS_NAME,
HD_STATUS.ORDINAL as STATUS_ORDINAL,
STATE,
U1.FULL_NAME as OWNER_FULLNAME,
U1.EMAIL as OWNER_EMAIL,
U2.USER_NAME as SUBMITTER_NAME,
U2.FULL_NAME as SUBMITTER_FULLNAME,
U2.EMAIL as SUBMITTER_EMAIL,
U3.EMAIL as UPDATEREMAIL,
'FedEx_Labels_Group@autozone.com,kbox.support.group@autozone.com' as NEWTICKETEMAIL,
UNIX_TIMESTAMP(HD_TICKET_CHANGE.TIMESTAMP)
from ( HD_TICKET,
HD_PRIORITY,
HD_STATUS,
HD_IMPACT,
HD_CATEGORY)
JOIN HD_TICKET_CHANGE ON HD_TICKET_CHANGE.HD_TICKET_ID = HD_TICKET.ID
and HD_TICKET_CHANGE.ID=<CHANGE_ID>
left join USER U1 on U1.ID = HD_TICKET.OWNER_ID
left join USER U2 on U2.ID = HD_TICKET.SUBMITTER_ID
left join USER U3 on U3.ID = HD_TICKET_CHANGE.USER_ID
where HD_PRIORITY.ID = HD_PRIORITY_ID and
HD_STATUS.ID = HD_STATUS_ID and
HD_IMPACT.ID = HD_IMPACT_ID and
HD_CATEGORY.ID = HD_CATEGORY_ID and
HD_TICKET_CHANGE.DESCRIPTION = 'TICKET CREATED' and
HD_TICKET.TITLE = 'Used Fedex Labels Script'

Any help on this will be greatly appreciated.
0 Comments   [ - ] Hide Comments

Comments

Please log in to comment

Rating comments in this legacy AppDeploy message board thread won't reorder them,
so that the conversation will remain readable.
Answer this question or Comment on this question for clarity

Answers

0
You could break it up into multiple rules or to keep it in one rule you'll want something like this in your query:

select ...
case when HD_TICKET.CUSTOM_FIELD_VALUE8='Printers' then 'printersgroup@company'
when HD_TICKET.CUSTOM_FIELD_VALUE8='Registers' then 'registersgroup@company'
else 'me@company' end DYNAMICGROUP
...from


Then address the email to the column DYNAMICGROUP
Answered 07/08/2010 by: GillySpy
Seventh Degree Black Belt

Please log in to comment
0
ORIGINAL: GillySpy

You could break it up into multiple rules or to keep it in one rule you'll want something like this in your query:

select ...
case when HD_TICKET.CUSTOM_FIELD_VALUE8='Printers' then 'printersgroup@company'
when HD_TICKET.CUSTOM_FIELD_VALUE8='Registers' then 'registersgroup@company'
else 'me@company' end DYNAMICGROUP
...from


Then address the email to the column DYNAMICGROUP



Thank you very much that worked great!!
Answered 07/09/2010 by: chris811
Orange Belt

Please log in to comment