Application Entry Order by Items error when updating Assign To



Description of Issue

When updating the Assign To field in Application Entry, clicking the help button, an error occurs

ORDER BY items must appear in the select list if SELECT DISTINCT is specified



Context
  • Permits and Code Enforcement

  • PI

  • Application Entry (piappent)



Cause




Resolution

Development is currently researching the issue. Install MUN-436730 once available

Work around is to enter the Assigned To Team/Clerk value manually instead of using the Help button to view available ones



Additional Information