Only one line being sent when multiple return in query
Only one line being sent when multiple return in query
(OP)
Hello -
We are having an issue with an event that was created by someone that has left the company. All the IT people on my team are new to Exact Event Manager (< 1 year) and we do not know all the ins and outs of it.
So, my problem is this. I have an event that is set up to break on the customer number and send an email to the email address field. The SQL statement returns multiple rows per customer number but only one of the lines is being sent in the email.
I have checked the following:
The query results return more than one row for the customer I am testing with. Note that the person that developed the query used the different tabs to develop the query and did not write the SQL themselves. With the events I have developed, I tend to write the SQL myself and mine are working. I doubt that it matters, but I thought I would mention it. On the email tab, the message text has the Begin Repeat and End Repeat tags. I even took an event that was working and checked to see if there was some difference the the way the tags were handled and I didn't see any. So, it looks like the tags are correct. On the Subscribers tab and Advanced sub-tab, the Message Break Field is set to the cus_no (now no distribution method is checked to the right but on some other events I see the same thing and they work). On the Subscribers tab and Advanced sub-tab, the Contains Email Address to send to value is set to the email_addr.
Does anyone have any ideas what we are doing wrong? If more information is needed, please let me know what you need to know.
Thank you.
Tammy
We are having an issue with an event that was created by someone that has left the company. All the IT people on my team are new to Exact Event Manager (< 1 year) and we do not know all the ins and outs of it.
So, my problem is this. I have an event that is set up to break on the customer number and send an email to the email address field. The SQL statement returns multiple rows per customer number but only one of the lines is being sent in the email.
I have checked the following:
Does anyone have any ideas what we are doing wrong? If more information is needed, please let me know what you need to know.
Thank you.
Tammy
RE: Only one line being sent when multiple return in query
RE: Only one line being sent when multiple return in query
I would recommend that you take a look at the query that is defined for the event. If the event is set to not repeat, then it will go back to the query to look at the field which is marked as "Unique" to determine if the record is a duplicate or not. The field that is marked as a the "Unqiue" field should be unique for each record. In this case, you will probably have a key field plus a key from your customer/contact record. For example: if the query is selecting invoices and needs to send one one per each customer contact, then the unique should be a combination of the Invoice_No + Contact Name or ID. If you have further questions, I will be glad to help you out.
Thanks,
Tori
RE: Only one line being sent when multiple return in query
RE: Only one line being sent when multiple return in query
Peter Shirley
Macola Consultant, PA and surrounding states.
http://www.erpessentials.com