• Search Forums
    Advanced Search Topics Posts
Prev
Next
Forums Integration / Customization IPA/ProcessFlow

Select distinct records from Query Node

 1 Replies
 0 Subscribed to this topic
 52 Subscribed to this forum
Sort:
Author
Messages
Willie
Basic Member
Posts: 14
Basic Member
9/23/2014 2:29 PM
I run a query against HRHISTORY to identify employees who have made address changes via self serve. We are required to notify them via email. Problem is they may get several emails depending on how many fields they changed. The records selected are not in sequence. I have a routine which eliminates most as it checks the current employee against the previous, if they are the same it bypasses the loop. We do not have the SQL node available. Is there a way to identify unique employee records. Any advice appreciated.

Thanks.
Willie
Basic Member
Posts: 14
Basic Member
10/1/2014 6:52 PM
I solved my problem. I was using the key_field as the index, when I changed this to be part of the criteria it returns the records sequentially.

Thanks