When attempting to load a constituent based list in NetCommunity, you may get the following error when the list loads: System.ApplicationException: Error fetching records (DoSearch()): QueryField not found at Blackbaud.Web.Content.Core.Data.RecordSearch.DoSearch() at Blackbaud.Web.Content.Core.DataSourceConstituentFetch.StartPagedFetchByQueryID(Int32 QueryID, Int32 RecordsPerPage, IDataSourceFetchFields FetchFields, String options, Int32 SystemID)
This error occurs when you have a constituent query in The Raiser's Edge that is utilizing Constituent Consent fields (for example, Response)
This is resolved in 7.96 patch 13, released in September - October 2018 and applied to databases in Blackbaud Hosting Services. If your database is installed locally, download and install the latest version and patch, if applicable.
Steps to Duplicate
Create a Constituent Query in The Raiser's Edge
Add in the Criteria of Constituent Contact Consent -> Response -> [not blank]