I've got a view outputting a table, with a referenced role as one of the columns. All the columns apart from my role column let me select them to be sortable. Could this be added to the views integration? Thanks.

Comments

cgmonroe’s picture

cgmonroe commented

First, you have to understand that the "role" in the node is actual just the role id. What you are seeing is a number being converted to the match name. This is why it can't be sorted... sorting is done by SQL and it will only sort the number (not the translation)... but the number will probably not be in alpha order which is what you want.

The way to get role sorting is by using a reference in your view to tie the rolereference field to the real user role info, then using display the rolename instead of the rolereference field. This will be sortable since it's really the name and not a number being converted to a name.