Alphabetical view sorting in multilingual site not working for translated content I have created a view that alphabetically lists all nodes of type "glossary entry". A glossary with many terms. Besides German I need the glossary in English, too. The translation has worked great using Entity Translation module. I only have the problem that the alphabetical order of the English version is not correct. The English glossary has the same sort order than the German (original) version:


  German version:
  
  
  Adler (German word for eagle)
  Hund (German word for dog)
  Kuh (German word for cow)
  
  
  English version:
  
  
  Eagle
  Dog
  Cow
  


I crawled many forums but couldn't find a solution for my problem. I already added the relationship "Entity Translation" in my view but the additional filter and sorts don't help me here.

What I need is a sort "title (English Translation)". Does somebody has a clue how to get this work?!!

Please find here the view's query
I solved that by adding this field as a relationship to the view and so name:field became accessible as sort criteria, which I then chose instead of content:field.