kolev.kg <kolev...@gmail.com>

I assume you have put this statement in a lookup connector, correct?

If so then it is normal to get such an error if your link criteria is
not bound to a unique constraint, i.e. you are querying for something
that can be present in multiple records at the same time. In your case
you have 3 records which "end_date" field is NULL. When you get
multiple entries returned the AL gives you the opportunity to further
filter the records or to put them all in the resultant entry before
doing the input map. Since the AL does not know what exactly you might
want to be done you have been given the ability to specify your
intentions using a hook - "On Multiple Entries" to be precise. In that
hook you could cycle throughout all the entries that matched your
criteria using a script.

Best Regards,
Kaloyan Kolev.