Hi everyone!

I recently ran into a hurdle when trying to pull a clean list of current Email Opt-Ins/Opt-Outs for our communications in RE NXT.

Because constituent consents are structured as a one-to-many relationship, RE NXT queries currently pull all historical consent records rather than isolating just the most recent status.

Right now, the only way I was able to work around is by exporting to Excel and running a manual deduplication, which adds extra steps and, more importantly, introduces compliance risks if outdated preferences slip through.

The Feature Request: Can we add a native query option (or criteria filter) to only return the most recent consent record (latest consent record) per constituent?

If this is something that would make your life easier and your data safer, please upvote this idea!

Let's get Blackbaud to build this into the system.

Thank you.