ORDER BY items must appear in the select list if SELECT DISTINCT is specified error occurs when searching for Rollup code in Account Inquiry
- Knowledge Assistant
Owned by Knowledge Assistant
Description of Issue
Error ORDER BY items must appear in the select list if SELECT DISTINCT is specified
Context
Account inquiry
Rollup
Budget Rollup
Cause
Resolution
Work ticket MUN-423809 has been created to address the issue.
Additional Information
Known workarounds
After opening Account inquiry click on Seg Find and select the ellipsis next to Rollup Code.
Manually key the Rollup Code value without selecting the ellipsis.Â