Error: Invalid column name 'SORTCONSTITUENTNAME'. ORDER BY items must appear in the select list if SELECT DISTINCT is specified

Error: Invalid column name 'SORTCONSTITUENTNAME'.
ORDER BY items must appear in the select list if SELECT DISTINCT is specified 
when trying to search for or add a new Major Giving Prospect.
Download and install the latest patch, which contains all fixes from previous patches. If you are running an older version, download and install the latest version and then the patch. 

Environment

 2.9.1001
 2.9.1001.15

Was this article helpful?