The ability to upload a list of constituent IDs into a query

This is based on a feature I frequently used in another database (Tessitura). I could upload a list of constituent IDs into a query. This was helpful because if I took an export and removed constituents I did not want on the file but wanted to add another field, I could create a list of all the constituents I wanted by uploading the exact IDs and creating a query. I could then repull my export with the field I desired.

  • Jeanna Burch
  • May 2 2025
  • Reviewed: Voting Open
Reporting and Analysis
  • Attach files
  • Dallas Moses commented
    06 May 18:56

    You should already be able to do this, if I'm not mistaken about what you're wanting. You can copy/paste IDs into the "Constituent ID" criteria (using the one of operator) of a constituent query and save. This will get you a query based on just those IDs. In DBV you can copy/paste up to 500 at a time, in RENXT you can copy/paste up to 2000. You can use the OR operator to add the constituent ID criteria as many times as you need to get all of your IDs into the query if it exceeds 500/2000.

    Attachments Open full size

Related ideas