PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 01/15/2014 10:26 AM by  Nabil
Smartnote Bursting on two email fields
 4 Replies
Sort:
You are not authorized to post a reply.
Author Messages
Nabil
Programmer/Analyst
St. Luke's Health System
Veteran Member
(105 points)
Veteran Member
Posts:47


Send Message:

--
01/14/2014 3:27 PM
    Hello,
    I have a current smartnote sending Employee HR and BN data to the HR Contact at various locations. Now, the HR Contacts want the employee supervisors getting the notification too.
    My question is, can my current SN that's sending emails to HR Contacts also send them to Supervisors? Those are two different fields residing in two different tables.

    Appreciate the help!

    Thanks,
    Ruma Malhotra
    Private
    Private
    Veteran Member
    (1092 points)
    Veteran Member
    Posts:412


    Send Message:

    --
    01/14/2014 3:43 PM
    One way to do this is to change the sql of your smartnote to include the email of your supervisor as a field i your smart note. You cna then burst the smart note twice. One for the HR contact and the other to the supervisor.
    Nabil
    Programmer/Analyst
    St. Luke's Health System
    Veteran Member
    (105 points)
    Veteran Member
    Posts:47


    Send Message:

    --
    01/15/2014 9:33 AM
    So essentially I'll be creating two Smartnotes, one sending emails to HR Contacts, and the other to Supervisors? My SQL is already pulling two Email fields I just don't see how I can burst it to two fields in the Bursting tab. Has anyone done this before?

    Thanks,
    The.Sam.Groves
    Programmer Analyst
    St Lukes Hospital
    Veteran Member
    (265 points)
    Veteran Member
    Posts:89


    Send Message:

    --
    01/15/2014 9:59 AM
    The method previously described is how I have done it in the past, you are literally simply creating a copy of the current notification and updating the delivery portion to link to the supervisor field instead of the employee.

    However if you really want just one notification, then there is an alternative. You would need to modify your query and notification. Update the query so it dumps two rows for every row you currently dump, and have a 'burst' email field. On one row use the employee's address and on the other use the supervisor's.

    I'm not a DBA but my off the hip thought would be to use a UNION between two select statements, one which is your current SQL with the employee's email in the field and then UNIONed to the same select statement modified to fill in the supervisor's email in the 'burst' field.

    I've never used this method since most of my infosets are multipurpose and having two rows for each actual data row would cause problems.
    Nabil
    Programmer/Analyst
    St. Luke's Health System
    Veteran Member
    (105 points)
    Veteran Member
    Posts:47


    Send Message:

    --
    01/15/2014 10:26 AM
    That answers my question. Thank you!!
    You are not authorized to post a reply.