Change the order of a sort criteria in views to a custom hierarchy I have a content type called Technique that contains a title field, a description field, and a node reference called "belt level" referencing a content type called Curriculum level. The content in Curriculum level are as follows:  


Yellow belt
Orange belt
Blue belt
Brown belt
Red belt
Black belt


I have created an Integer field in the Curriculum level content type called level int. I have set "yellow" to 1, "orange" to 2, "blue" to 3, "brown" to 4, "red" to 5, and "black" to 6. Now I have a view of techniques, in which I want the sort criteria to display results based on the level int field value of the content that the node reference field (called "belt level") in the technique was referencing. The problem I am running into is that I have no way of connecting the two. If I use the belt level field to try to set the sort criteria, I can only sort it alphabetically based on the title. How can I sort it based on the level int field instead?
Add a relationship Content: belt level (or whatever your node reference field is called) to the view.

Then add a new sort, choose Content: level int (or whatever the integer field is called) and under 'relationship' choose the one you just added.

That should do it.