Select distinct records from Query Node

Sort:
You are not authorized to post a reply.
Author
Messages
Willie
Basic Member
Posts: 14
Basic Member
    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
      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
      You are not authorized to post a reply.