Forums
Smart Notification
Bursting on email addresses pulled from Lawson
Author
Messages
Lacey
Basic Member
Posts: 14
8/31/2012 5:40 PM
I have created a JDBC query which pull the email of each employee's supervisor for the last column. In the query preview the addresses pull wonderfully. However, once the infoset is complete the actual infoset pulls nulls for the emaill address column. I have tried with the type for the column as 'email' and as 'string', neither have worked. I would like to burst this notification out by these addresses. Any ideas why they will not pull through?
Matthew Nye
Veteran Member
Posts: 514
8/31/2012 6:38 PM
Make sure there are no null values in your results. I have had this cause the what you're describing.