Allow lists to run off of dynamic queries

I would like to be able to make queries that have a lot of including/excluding etc. and have the ability for those queries to be used for generating a list.  The user might still filter on that but this would give them a good set to begin with.

  • Guest
  • Jan 12 2016
  • Reviewed: Voting Open
  • Jul 6, 2016

    Admin response

    This is partially implemented with the static query from database view option when creating a new list. If you want dynamic queries, please continue to vote on this idea. 

  • Attach files
  • Emily Leary commented
    19 Nov 18:25

    This is a necessity for us!

  • Lorna Ruemper commented
    06 Nov 16:23

    According to the BBaud Constituent List help, "When you open or refresh a list based on a static query or query list, it automatically updates with any changes made in the database view." But this does not happen, the Webview Constituent list does not actually update. So you have to go back to the original static query, open it, run it, save it - then finally it will update in your Webview Constituent list - very frustrating.

  • Lisa Harrison-Cain commented
    19 Aug 16:46

    I second Kari Cheng's comment, and all of the others, for that matter. It would be great to have this fully implemented prior to the transition to NXT from database view. Thank you.

  • Kari Cheng commented
    19 Aug 16:17

    We are working to send out a monthly email through NXT where the list of recipients would change each month according to certain criteria. To be able to use a dynamic query would be much better (and a time saver) instead of having to pull a static query each time.

    Hoping to see this implemented soon, as we are being told we are fully transitioning from Database View to RENXT soon.

  • Katie Emerick commented
    06 Aug 20:05

    Having a dynamic query would help us immensely with the cumbersome email receipt process! We cannot fully implement NXT's e-receipt function w/out the segmentation options provided with query. Specifically, letter code. While static query is great, it is not feasible to pull a static query every week for 5 letter codes.

  • Emma Bindloss commented
    25 Jul 12:09

    I find it very useful to schedule emails for event registration reminders and dynamic queries are important to make sure you aren't spamming people who have either already booked or have already declined. Without dynamic queries it is not possible to schedule effectively and this costs time. I hope you can resolve this soon.

  • Laura Furtado commented
    22 May 13:59

    I was hoping with query being added to NXT email would allow us to choose dynamic queries for emails in NXT. At the very least we should be allowed to use dynamic queries and translate them to a query list. We have dynamic queries we use for recurring emails. It would be annoying to have to refresh those each time we need to use them.

  • Jane Van Ingen commented
    16 Apr 16:07

    Now that queries are available in Web View, hopefully dynamic queries will be integrated into NXT soon.

  • Crystal Morgan commented
    15 Apr 16:41

    I think this would be useful for emailing lists from query not having to be remade each time, BUT could be solved by just allowing emailing using queries directly. If this creates a more limited view that users can then sort through, I wonder if using securities makes more sense.

    But allowing us more access to our data I always support, so upvoted

  • Sharon Gibbons commented
    13 Apr 16:59

    We need the option to run lists from both dynamic and static

  • Laura Abada commented
    December 16, 2024 22:52

    We need this feature for several recurring processes we run on a regular basis. I don't want to have to reinvent something new.

  • Rivki Raphaelson commented
    December 16, 2024 22:36

    We use this functionality multiple times a week in database view. We would need to completely reinvent the wheel if query lists with dynamic queries was removed.

    how are we supposed to make a list of many complex criteria?

  • Becky Wise commented
    September 05, 2024 16:28

    We need the ability to send emails to constituents who are flagged "email only" for communications. In addition, we need to add a query filter to exclude constituents who have asked not to recieve our magazine. This is important in order for us to continue to navigate the changing privacy laws in the U.S. and worldwide.

  • Maryann Perrotta commented
    October 18, 2023 14:04

    If Blackbaud wants to ultimately remove the Database View from Raiser’s Edge, they will have to incorporate all DBA functions in NXT Web View including the most basic functions such as creating a list/query in NXT and having every field available for including/excluding just like database view. As a DBA I cannot see myself working in NXT anytime soon since the functionality doesn’t exist for me to complete my responsibilities within Raiser’s Edge. Let’s get this done “Dynamic query” would make the BB Community happy!

  • Kathleen Eastman commented
    August 18, 2023 21:17

    Not having this functionality prevents DBA's from supporting their colleagues with something that is basic and greatly needed. When our fundraisers can open a list and have it auto update, the DBA is not needed beyond the set up, saving valuable time needed for other requests and solving other issues. WHAT IS KEEPING BB FROM IMPLEMENTING THIS?!!!!!!!!!!!!!!!!!1

  • Mary Beth Welsh commented
    July 21, 2023 16:20

    Since this question was opened in 2016 - It doesn't seem like these votes matter. but for what it's worth - yes! Dynamic query is basic and should have been there from the beginning.

  • Karen Mitchell commented
    July 13, 2023 12:34

    What's the point of RE NXT lists? You can't even create a mailing list excluding do not mail. I can't then create a dynamic query from database view so that I can exclude it in Lists, as all queries are static. Very frustrating.

  • Guest commented
    May 06, 2023 12:37

    I'm setting up a new solution for my team and am building everything in database view, as I have 6+ years of intensive RE experience but everyone else on my team will be completely new. They will only use NXT. I want to create default lists for them built off dynamic queries so they can find and contact constituents. Why do I have to duplicate effort by building a list in NXT AND a dynamic query in the database to do the same task?

  • Guest commented
    January 31, 2023 15:12

    Why are NXT lists still static? From a business perspective it doesn't make sense. Most users should interact with the data via a web front end, not in the backend database!

  • Gwen Williams commented
    December 19, 2022 21:11

    We need to be able to create lists based on dynamic queries. It is ridiculous that we don't have this as an option yet. This should be an easy thing to implement give that static queries are already included. Please get this added for us. It will make things much more efficient!

  • Load older comments
  • +1565