nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Power Flow Search Constituent Record not returning unique count

Rachel Ryerson

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?

Find more posts tagged with

Comments

Ben Lambert

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

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.