Unable to find column after sort by ALIAS field

[benhaynes]

From directus created by RadioSchattenwelt : directus/directus#2184

For security issues, please email support@getdirectus.com directly.

To help us resolve your issue more quickly, please use the following template:

For feature requests/voting please use the Directus Request Tool, or come chat with us through getdirectus.com. Accepted feature requests will be added to GitHub Issues for assignment.

Version Info

• Directus version and branch (Or commit hash): 6.4.9 downloaded from release page
• PHP version: 5.6.33
• MySQL version: ?
• Web server: (Ex. Apache, nginx or IIS?) ?
• OS name and version: ?

Expected Behavior

You should be able to sort the items in the table view by each column you like.

Actual Behavior

If you try to sort the table entries by a ALIAS field from m2m relation you get the error "unable to find column X". From this moment on you are unable to access the table.

Steps to Reproduce

1. Create a table with m2m relationship
2. Try to sort the table view by the m2m ALIAS field

Schema Dump, Logs, or Screenshots