Query Error Message

Cindy Miller
Cindy Miller
Name Dropper Participant First Anniversary Facilitator 1
in Blackbaud Raiser's Edge NXT®: General Discussions

I'm writing a query in RENXT, and I've received an error message that I don't understand. Here it is: The compare_type must be None for the first filter field, and And or Or for all others. I think it has something to do with my criteria, but I don't see anything wrong with it:

8c58047d6e6a7841921d28d7d081c46a-huge-im

Is there anyone out there who can help me determine what this error code is telling me? Thanks so much!

Comments

  • JoAnn Strommen
    JoAnn Strommen Community All-Star
    Tenth Anniversary Kudos 5 March 2026 Challenge: Answered Questions January 2026 Monthly Challenge

    @Cindy Miller I believe your query could be better structured. Haven't seen that error but try this:

    When selecting the summary Total Amount of Gifts you should have been given the option

    4e2db711e1c9d73d4c72bdbc832f3b4c-huge-im

    Choose yes. Assuming by the “AND” the other criteria you used are all related to your total. Nest those other criteria in your “total” criteria. Your query when complete should look more like this (from my query):

    2ea37639c42113144a73cf25da75ed20-huge-im

    My thoughts for what they're worth :)

  • Alex Wong
    Alex Wong Community All-Star
    Tenth Anniversary Kudos 5 Facilitator 4 bbcon 2025 Attendee Badge

    @Cindy Miller
    First, there shouldn't be any error when using Query in webview, I recommend you report this to Blackbaud support so they can look into fixing this bug.

    Second, I also think your criteria look off. Can you give more context on what you are trying to query on?

  • Cindy Miller
    Cindy Miller
    Name Dropper Participant First Anniversary Facilitator 1

    @Alex Wong Here's the list I want to achieve: All constituents who gave a total of more than $1,000 after 6/30/2024 to a specific list of funds and who are not trustees (appeal code TRUCUR) and we want to avoid those who do not want to be contacted (appeal code NOSOL). Thanks!

  • Alex Wong
    Alex Wong Community All-Star
    Tenth Anniversary Kudos 5 Facilitator 4 bbcon 2025 Attendee Badge

    @Cindy Miller

    a7b5bc2777ac07447a2c678fc60ab393-huge-im
    22b7ff297481b3e460f70764ddbace97-huge-im
    4585196049308957f9ca0af133423d80-huge-im

    Notice how the gift date and fund description criteria is “indented” meaning it is part of the total amount of gifts criteria.

    Add other constituent based criteria: solicit code, constituent appeal.

  • Cindy Miller
    Cindy Miller
    Name Dropper Participant First Anniversary Facilitator 1

    @Alex Wong That worked beautifully! I'm creating all new queries (we are in our first month of using RENXT), so this will give me the basis I need for this type of query. Thank you so much! - Cindy

Categories