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
  • Jennifer Watson commented
    04 Feb 21:20

    I use this feature quite often in database view so if this functionality is not moved over to webview, the "2000 one-of" option will not be enough. We need to be able to import a large list of REIDS to be able to access additional fields for those constituents.

    In addition, it would be great if we can do this for other fields besides import ids, consID. Many times I have several thousand IDs that are an alias in our database, or I have several thousand emails I need to pull information for. Copying and pasting 2000 records at a time for a "one-of" option is great for smaller data sets, but when I might have 50K records of student ids I need to pull in for student data, that is not the best use of my time.

    Attachments Open full size
  • Dallas Moses commented
    May 06, 2025 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