Error while running query in NXT

Payal Sen

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.

Carlene Johnson

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!

Payal Sen

Thank you this did resolve the issue.

Carlene Johnson

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!