Smartnote Bursting on two email fields

Sort:
You are not authorized to post a reply.
Author
Messages
Nabil
Veteran Member
Posts: 61
Veteran Member
    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
    Veteran Member
    Posts: 412
    Veteran Member
      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
      Veteran Member
      Posts: 61
      Veteran Member
        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
        Veteran Member
        Posts: 89
        Veteran Member
          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
          Veteran Member
          Posts: 61
          Veteran Member
            That answers my question. Thank you!!
            You are not authorized to post a reply.