×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Only one line being sent when multiple return in query
2

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

    RE: Only one line being sent when multiple return in query

    (OP)
    Ooops. I just realized this is a Macola forum and not an Exact Event Manager forum. So, please let me know if there is not expertise on Exact Event Manager here.

    RE: Only one line being sent when multiple return in query

    2
    Hello Tammy,

    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

    (OP)
    Thank you Tori. I actually finally figured that out. I had just forgot I had that post. It took me awhile to figure it out. I am learning a lot about Event Manager with some of the issues I am encountering. Thank you. That was the problem. The unique key should have been on two fields (the order number and the line number) and it was only one one field (the order number).

    RE: Only one line being sent when multiple return in query

    If you're setting up an event to not repeat - avoid basing the Unique identifier on an ID field. If the table in question is ever altered or rewritten (as part of an update for example) then new values are assigned to the ID field and everything will retrigger...

    Peter Shirley
    Macola Consultant, PA and surrounding states.
    http://www.erpessentials.com

    Red Flag This Post

    Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

    Red Flag Submitted

    Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
    The Tek-Tips staff will check this out and take appropriate action.

    Reply To This Thread

    Posting in the Tek-Tips forums is a member-only feature.

    Click Here to join Tek-Tips and talk with other members! Already a Member? Login

    Close Box

    Join Tek-Tips® Today!

    Join your peers on the Internet's largest technical computer professional community.
    It's easy to join and it's free.

    Here's Why Members Love Tek-Tips Forums:

    Register now while it's still free!

    Already a member? Close this window and log in.

    Join Us             Close