Error while running query in NXT

I occasionally keep on getting this error while trying to run query in RE NXT. However when I ran the same query in database view it seem to be fine. Can some please help to understand the issue here. This is the message

The provided query field Name (ID: 597) in select_fields[0].query_field_id cannot be used with the query type Organization.

Best Answer

  • Carlene Johnson
    Carlene Johnson Community All-Star
    Tenth Anniversary Kudos 5 PowerUp Challenge: Data Health #3 First Reply
    Answer ✓

    Out of curiosity, could you test something for me?

    If this is an Organization Query, does it run properly in WV if you switch the query type to Constituent instead?

    If you still need to limit the results to organizations, you can add a filter for Key Indicator = “O” to keep the population the same.

    Let us know!

Answers

  • Thank you this did resolve the issue.

  • Carlene Johnson
    Carlene Johnson Community All-Star
    Tenth Anniversary Kudos 5 PowerUp Challenge: Data Health #3 First Reply

    NXT is much stricter than Database View about which fields are allowed in each query type. When the query was set to Organization, the “Name” field you used wasn’t considered valid for that record type — even though Database View doesn’t enforce that rule.

    Switching the query to Constituent works because it supports a wider set of fields, including the one that caused the error. Adding Key Indicator = O simply brings the results back to organizations only.

    Glad you were able to resolve the issue!

Categories