Query Error Message

Cindy Miller

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:

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

JoAnn Strommen

@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

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):

My thoughts for what they're worth

Alex Wong

@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

@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

@Cindy Miller

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

@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