Power Flow Search Constituent Record not returning unique count

Rachel Ryerson
Rachel Ryerson
Fourth Anniversary Facilitator 1
in Blackbaud Raiser's Edge NXT® APIs
I have a power flow set up to search a constituent record after form is submitted. I have a condition after the search to see how many records it returned. Many times it will return more than 1 record when in Raiser's Edge there is only one record. It may be because they have multiple addresses or emails. I really need to know if the count is truly one or more than one. Is there a way to do a distinct count?

Comments

  • Ben Lambert
    Ben Lambert
    Ninth Anniversary Kudos 5 Name Dropper Participant
    Hi Rachel,


    Just to make sure I understand the behavior you're describing...are you using the SearchConstituent action in the connector? If so, that action drives the same search functionality that you'd see in NXT - so if you provide the same search text in NXT, do you see multiple results?
  • Ben Regier
    Ben Regier
    Sixth Anniversary Kudos 5 Name Dropper Participant
    You shouldn't be seeing more than one result for a single constituent. You might get multiple results of people with the same names, but they should all have different constituent IDs. So your list is already distinct. Sounds like you might have duplicate records in your database.

Categories