=== order by PK asc
Request:
GET /cd?order=me.cdid
Accept: application/hal+json
Response:
200 OK
Content-type: application/hal+json
{
   "_embedded" : {
      "cd" : [
         {
            "_links" : {
               "artist" : {
                  "href" : "/artist/1"
               },
               "cd_to_producer" : {
                  "href" : "/cd_to_producer?me.cd=1"
               },
               "genre" : {
                  "href" : "/genre/1"
               },
               "self" : {
                  "href" : "/cd/1"
               },
               "tracks" : {
                  "href" : "/track?me.cd=1"
               }
            },
            "artist" : 1,
            "cdid" : 1,
            "genreid" : 1,
            "single_track" : null,
            "title" : "Spoonful of bees",
            "year" : "1999"
         },
         {
            "_links" : {
               "artist" : {
                  "href" : "/artist/1"
               },
               "cd_to_producer" : {
                  "href" : "/cd_to_producer?me.cd=2"
               },
               "genre" : {
                  "href" : "/genre/2"
               },
               "self" : {
                  "href" : "/cd/2"
               },
               "tracks" : {
                  "href" : "/track?me.cd=2"
               }
            },
            "artist" : 1,
            "cdid" : 2,
            "genreid" : 2,
            "single_track" : null,
            "title" : "Forkful of bees",
            "year" : "2001"
         },
         {
            "_links" : {
               "artist" : {
                  "href" : "/artist/1"
               },
               "cd_to_producer" : {
                  "href" : "/cd_to_producer?me.cd=3"
               },
               "genre" : {
                  "href" : "/genre/2"
               },
               "self" : {
                  "href" : "/cd/3"
               },
               "tracks" : {
                  "href" : "/track?me.cd=3"
               }
            },
            "artist" : 1,
            "cdid" : 3,
            "genreid" : 2,
            "single_track" : null,
            "title" : "Caterwaulin' Blues",
            "year" : "1997"
         },
         {
            "_links" : {
               "artist" : {
                  "href" : "/artist/2"
               },
               "cd_to_producer" : {
                  "href" : "/cd_to_producer?me.cd=4"
               },
               "genre" : {
                  "href" : "/genre/3"
               },
               "self" : {
                  "href" : "/cd/4"
               },
               "tracks" : {
                  "href" : "/track?me.cd=4"
               }
            },
            "artist" : 2,
            "cdid" : 4,
            "genreid" : 3,
            "single_track" : null,
            "title" : "Generic Manufactured Singles",
            "year" : "2001"
         },
         {
            "_links" : {
               "artist" : {
                  "href" : "/artist/3"
               },
               "cd_to_producer" : {
                  "href" : "/cd_to_producer?me.cd=5"
               },
               "genre" : {
                  "href" : "/genre/4"
               },
               "self" : {
                  "href" : "/cd/5"
               },
               "tracks" : {
                  "href" : "/track?me.cd=5"
               }
            },
            "artist" : 3,
            "cdid" : 5,
            "genreid" : 4,
            "single_track" : null,
            "title" : "Come Be Depressed With Us",
            "year" : "1998"
         }
      ]
   },
   "_links" : {
      "self" : {
         "href" : "/cd?rows=30&page=1",
         "title" : "TestSchema::Result::CD"
      }
   }
}

=== order by PK desc
Request:
GET /cd?order=me.cdid%20desc
Accept: application/hal+json
Response:
200 OK
Content-type: application/hal+json
{
   "_embedded" : {
      "cd" : [
         {
            "_links" : {
               "artist" : {
                  "href" : "/artist/3"
               },
               "cd_to_producer" : {
                  "href" : "/cd_to_producer?me.cd=5"
               },
               "genre" : {
                  "href" : "/genre/4"
               },
               "self" : {
                  "href" : "/cd/5"
               },
               "tracks" : {
                  "href" : "/track?me.cd=5"
               }
            },
            "artist" : 3,
            "cdid" : 5,
            "genreid" : 4,
            "single_track" : null,
            "title" : "Come Be Depressed With Us",
            "year" : "1998"
         },
         {
            "_links" : {
               "artist" : {
                  "href" : "/artist/2"
               },
               "cd_to_producer" : {
                  "href" : "/cd_to_producer?me.cd=4"
               },
               "genre" : {
                  "href" : "/genre/3"
               },
               "self" : {
                  "href" : "/cd/4"
               },
               "tracks" : {
                  "href" : "/track?me.cd=4"
               }
            },
            "artist" : 2,
            "cdid" : 4,
            "genreid" : 3,
            "single_track" : null,
            "title" : "Generic Manufactured Singles",
            "year" : "2001"
         },
         {
            "_links" : {
               "artist" : {
                  "href" : "/artist/1"
               },
               "cd_to_producer" : {
                  "href" : "/cd_to_producer?me.cd=3"
               },
               "genre" : {
                  "href" : "/genre/2"
               },
               "self" : {
                  "href" : "/cd/3"
               },
               "tracks" : {
                  "href" : "/track?me.cd=3"
               }
            },
            "artist" : 1,
            "cdid" : 3,
            "genreid" : 2,
            "single_track" : null,
            "title" : "Caterwaulin' Blues",
            "year" : "1997"
         },
         {
            "_links" : {
               "artist" : {
                  "href" : "/artist/1"
               },
               "cd_to_producer" : {
                  "href" : "/cd_to_producer?me.cd=2"
               },
               "genre" : {
                  "href" : "/genre/2"
               },
               "self" : {
                  "href" : "/cd/2"
               },
               "tracks" : {
                  "href" : "/track?me.cd=2"
               }
            },
            "artist" : 1,
            "cdid" : 2,
            "genreid" : 2,
            "single_track" : null,
            "title" : "Forkful of bees",
            "year" : "2001"
         },
         {
            "_links" : {
               "artist" : {
                  "href" : "/artist/1"
               },
               "cd_to_producer" : {
                  "href" : "/cd_to_producer?me.cd=1"
               },
               "genre" : {
                  "href" : "/genre/1"
               },
               "self" : {
                  "href" : "/cd/1"
               },
               "tracks" : {
                  "href" : "/track?me.cd=1"
               }
            },
            "artist" : 1,
            "cdid" : 1,
            "genreid" : 1,
            "single_track" : null,
            "title" : "Spoonful of bees",
            "year" : "1999"
         }
      ]
   },
   "_links" : {
      "self" : {
         "href" : "/cd?rows=30&page=1",
         "title" : "TestSchema::Result::CD"
      }
   }
}

=== order by year desc and title desc
Request:
GET /cd?sort=me.year%20desc,title%20desc
Accept: application/hal+json
Response:
200 OK
Content-type: application/hal+json
{
   "_embedded" : {
      "cd" : [
         {
            "_links" : {
               "artist" : {
                  "href" : "/artist/2"
               },
               "cd_to_producer" : {
                  "href" : "/cd_to_producer?me.cd=4"
               },
               "genre" : {
                  "href" : "/genre/3"
               },
               "self" : {
                  "href" : "/cd/4"
               },
               "tracks" : {
                  "href" : "/track?me.cd=4"
               }
            },
            "artist" : 2,
            "cdid" : 4,
            "genreid" : 3,
            "single_track" : null,
            "title" : "Generic Manufactured Singles",
            "year" : "2001"
         },
         {
            "_links" : {
               "artist" : {
                  "href" : "/artist/1"
               },
               "cd_to_producer" : {
                  "href" : "/cd_to_producer?me.cd=2"
               },
               "genre" : {
                  "href" : "/genre/2"
               },
               "self" : {
                  "href" : "/cd/2"
               },
               "tracks" : {
                  "href" : "/track?me.cd=2"
               }
            },
            "artist" : 1,
            "cdid" : 2,
            "genreid" : 2,
            "single_track" : null,
            "title" : "Forkful of bees",
            "year" : "2001"
         },
         {
            "_links" : {
               "artist" : {
                  "href" : "/artist/1"
               },
               "cd_to_producer" : {
                  "href" : "/cd_to_producer?me.cd=1"
               },
               "genre" : {
                  "href" : "/genre/1"
               },
               "self" : {
                  "href" : "/cd/1"
               },
               "tracks" : {
                  "href" : "/track?me.cd=1"
               }
            },
            "artist" : 1,
            "cdid" : 1,
            "genreid" : 1,
            "single_track" : null,
            "title" : "Spoonful of bees",
            "year" : "1999"
         },
         {
            "_links" : {
               "artist" : {
                  "href" : "/artist/3"
               },
               "cd_to_producer" : {
                  "href" : "/cd_to_producer?me.cd=5"
               },
               "genre" : {
                  "href" : "/genre/4"
               },
               "self" : {
                  "href" : "/cd/5"
               },
               "tracks" : {
                  "href" : "/track?me.cd=5"
               }
            },
            "artist" : 3,
            "cdid" : 5,
            "genreid" : 4,
            "single_track" : null,
            "title" : "Come Be Depressed With Us",
            "year" : "1998"
         },
         {
            "_links" : {
               "artist" : {
                  "href" : "/artist/1"
               },
               "cd_to_producer" : {
                  "href" : "/cd_to_producer?me.cd=3"
               },
               "genre" : {
                  "href" : "/genre/2"
               },
               "self" : {
                  "href" : "/cd/3"
               },
               "tracks" : {
                  "href" : "/track?me.cd=3"
               }
            },
            "artist" : 1,
            "cdid" : 3,
            "genreid" : 2,
            "single_track" : null,
            "title" : "Caterwaulin' Blues",
            "year" : "1997"
         }
      ]
   },
   "_links" : {
      "self" : {
         "href" : "/cd?rows=30&page=1",
         "title" : "TestSchema::Result::CD"
      }
   }
}

=== order by field in a relation (and the primary set for test stability)
Request:
GET /cd?prefetch=artist&sort=artist.name,cdid
Accept: application/hal+json
Response:
200 OK
Content-type: application/hal+json
{
   "_embedded" : {
      "cd" : [
         {
            "_embedded" : {
               "artist" : {
                  "artistid" : 1,
                  "charfield" : null,
                  "name" : "Caterwauler McCrae",
                  "rank" : 13
               }
            },
            "_links" : {
               "artist" : {
                  "href" : "/artist/1"
               },
               "cd_to_producer" : {
                  "href" : "/cd_to_producer?me.cd=1"
               },
               "genre" : {
                  "href" : "/genre/1"
               },
               "self" : {
                  "href" : "/cd/1"
               },
               "tracks" : {
                  "href" : "/track?me.cd=1"
               }
            },
            "artist" : 1,
            "cdid" : 1,
            "genreid" : 1,
            "single_track" : null,
            "title" : "Spoonful of bees",
            "year" : "1999"
         },
         {
            "_embedded" : {
               "artist" : {
                  "artistid" : 1,
                  "charfield" : null,
                  "name" : "Caterwauler McCrae",
                  "rank" : 13
               }
            },
            "_links" : {
               "artist" : {
                  "href" : "/artist/1"
               },
               "cd_to_producer" : {
                  "href" : "/cd_to_producer?me.cd=2"
               },
               "genre" : {
                  "href" : "/genre/2"
               },
               "self" : {
                  "href" : "/cd/2"
               },
               "tracks" : {
                  "href" : "/track?me.cd=2"
               }
            },
            "artist" : 1,
            "cdid" : 2,
            "genreid" : 2,
            "single_track" : null,
            "title" : "Forkful of bees",
            "year" : "2001"
         },
         {
            "_embedded" : {
               "artist" : {
                  "artistid" : 1,
                  "charfield" : null,
                  "name" : "Caterwauler McCrae",
                  "rank" : 13
               }
            },
            "_links" : {
               "artist" : {
                  "href" : "/artist/1"
               },
               "cd_to_producer" : {
                  "href" : "/cd_to_producer?me.cd=3"
               },
               "genre" : {
                  "href" : "/genre/2"
               },
               "self" : {
                  "href" : "/cd/3"
               },
               "tracks" : {
                  "href" : "/track?me.cd=3"
               }
            },
            "artist" : 1,
            "cdid" : 3,
            "genreid" : 2,
            "single_track" : null,
            "title" : "Caterwaulin' Blues",
            "year" : "1997"
         },
         {
            "_embedded" : {
               "artist" : {
                  "artistid" : 2,
                  "charfield" : null,
                  "name" : "Random Boy Band",
                  "rank" : 13
               }
            },
            "_links" : {
               "artist" : {
                  "href" : "/artist/2"
               },
               "cd_to_producer" : {
                  "href" : "/cd_to_producer?me.cd=4"
               },
               "genre" : {
                  "href" : "/genre/3"
               },
               "self" : {
                  "href" : "/cd/4"
               },
               "tracks" : {
                  "href" : "/track?me.cd=4"
               }
            },
            "artist" : 2,
            "cdid" : 4,
            "genreid" : 3,
            "single_track" : null,
            "title" : "Generic Manufactured Singles",
            "year" : "2001"
         },
         {
            "_embedded" : {
               "artist" : {
                  "artistid" : 3,
                  "charfield" : null,
                  "name" : "We Are Goth",
                  "rank" : 13
               }
            },
            "_links" : {
               "artist" : {
                  "href" : "/artist/3"
               },
               "cd_to_producer" : {
                  "href" : "/cd_to_producer?me.cd=5"
               },
               "genre" : {
                  "href" : "/genre/4"
               },
               "self" : {
                  "href" : "/cd/5"
               },
               "tracks" : {
                  "href" : "/track?me.cd=5"
               }
            },
            "artist" : 3,
            "cdid" : 5,
            "genreid" : 4,
            "single_track" : null,
            "title" : "Come Be Depressed With Us",
            "year" : "1998"
         }
      ]
   },
   "_links" : {
      "self" : {
         "href" : "/cd?rows=30&page=1",
         "title" : "TestSchema::Result::CD"
      }
   }
}

=== order by field in two relations
Request:
GET /cd?prefetch=artist,genre&order=-genre.name,artist.name
Accept: application/hal+json
Response:
200 OK
Content-type: application/hal+json
{
   "_embedded" : {
      "cd" : [
         {
            "_embedded" : {
               "artist" : {
                  "artistid" : 2,
                  "charfield" : null,
                  "name" : "Random Boy Band",
                  "rank" : 13
               },
               "genre" : {
                  "genreid" : 3,
                  "name" : "pop"
               }
            },
            "_links" : {
               "artist" : {
                  "href" : "/artist/2"
               },
               "cd_to_producer" : {
                  "href" : "/cd_to_producer?me.cd=4"
               },
               "genre" : {
                  "href" : "/genre/3"
               },
               "self" : {
                  "href" : "/cd/4"
               },
               "tracks" : {
                  "href" : "/track?me.cd=4"
               }
            },
            "artist" : 2,
            "cdid" : 4,
            "genreid" : 3,
            "single_track" : null,
            "title" : "Generic Manufactured Singles",
            "year" : "2001"
         },
         {
            "_embedded" : {
               "artist" : {
                  "artistid" : 3,
                  "charfield" : null,
                  "name" : "We Are Goth",
                  "rank" : 13
               },
               "genre" : {
                  "genreid" : 4,
                  "name" : "goth"
               }
            },
            "_links" : {
               "artist" : {
                  "href" : "/artist/3"
               },
               "cd_to_producer" : {
                  "href" : "/cd_to_producer?me.cd=5"
               },
               "genre" : {
                  "href" : "/genre/4"
               },
               "self" : {
                  "href" : "/cd/5"
               },
               "tracks" : {
                  "href" : "/track?me.cd=5"
               }
            },
            "artist" : 3,
            "cdid" : 5,
            "genreid" : 4,
            "single_track" : null,
            "title" : "Come Be Depressed With Us",
            "year" : "1998"
         },
         {
            "_embedded" : {
               "artist" : {
                  "artistid" : 1,
                  "charfield" : null,
                  "name" : "Caterwauler McCrae",
                  "rank" : 13
               },
               "genre" : {
                  "genreid" : 1,
                  "name" : "emo"
               }
            },
            "_links" : {
               "artist" : {
                  "href" : "/artist/1"
               },
               "cd_to_producer" : {
                  "href" : "/cd_to_producer?me.cd=1"
               },
               "genre" : {
                  "href" : "/genre/1"
               },
               "self" : {
                  "href" : "/cd/1"
               },
               "tracks" : {
                  "href" : "/track?me.cd=1"
               }
            },
            "artist" : 1,
            "cdid" : 1,
            "genreid" : 1,
            "single_track" : null,
            "title" : "Spoonful of bees",
            "year" : "1999"
         },
         {
            "_embedded" : {
               "artist" : {
                  "artistid" : 1,
                  "charfield" : null,
                  "name" : "Caterwauler McCrae",
                  "rank" : 13
               },
               "genre" : {
                  "genreid" : 2,
                  "name" : "country"
               }
            },
            "_links" : {
               "artist" : {
                  "href" : "/artist/1"
               },
               "cd_to_producer" : {
                  "href" : "/cd_to_producer?me.cd=2"
               },
               "genre" : {
                  "href" : "/genre/2"
               },
               "self" : {
                  "href" : "/cd/2"
               },
               "tracks" : {
                  "href" : "/track?me.cd=2"
               }
            },
            "artist" : 1,
            "cdid" : 2,
            "genreid" : 2,
            "single_track" : null,
            "title" : "Forkful of bees",
            "year" : "2001"
         },
         {
            "_embedded" : {
               "artist" : {
                  "artistid" : 1,
                  "charfield" : null,
                  "name" : "Caterwauler McCrae",
                  "rank" : 13
               },
               "genre" : {
                  "genreid" : 2,
                  "name" : "country"
               }
            },
            "_links" : {
               "artist" : {
                  "href" : "/artist/1"
               },
               "cd_to_producer" : {
                  "href" : "/cd_to_producer?me.cd=3"
               },
               "genre" : {
                  "href" : "/genre/2"
               },
               "self" : {
                  "href" : "/cd/3"
               },
               "tracks" : {
                  "href" : "/track?me.cd=3"
               }
            },
            "artist" : 1,
            "cdid" : 3,
            "genreid" : 2,
            "single_track" : null,
            "title" : "Caterwaulin' Blues",
            "year" : "1997"
         }
      ]
   },
   "_links" : {
      "self" : {
         "href" : "/cd?rows=30&page=1",
         "title" : "TestSchema::Result::CD"
      }
   }
}