I want to add the ability to sort/order by multiple fields for rooms. The simple way to go about this would be:
/getRooms?order_by=price:ASC
/getRooms?order_by=price # implied ASC
But what if I want to return rooms sorted by price first, and then another field?
/getRooms?order_by=price:ASC,rating:DESC
Which would internally create the sql: ORDER BY price ASC, rating DESC
.
Although if I look at some of the APIs ( youtube, ebay ) I don't seem to see any examples of multiple values for order by? Is there any specific reason or am I just not looking deep enough?
Also, does it make sense to use '+' or '-' in place of ASC or DESC? Mimicing how Amazon does it:
http://docs.aws.amazon.com/AWSECommerceService/latest/DG/APPNDX_SortValuesArticle.html
So /getRooms?order_by=-price,+rating
or does this make it more confusing, thereby I should just stick to ASC
and DESC
?