thrawn01/sorting.md

## sorting.md

      
    Raw
  

              sorting.md
            
          
    Sorting

Everyone does it differently 😭 and most query string parsers don't support LHS or RHS parsing or building. Prefer RHS for clarity and simplicity of parsing. I don't like the - or + operators because It's easy to over look.
Options from different sources


ChatGPT /users?sort=email,asc
RHS Single Field /users?sort=email:ASC
RHS Multiple Fields /users?sort=email:asc,name:desc
RHS Multiple Fields Keyed /users?sort=email:asc&sort=name:desc
LHS /users?sort=[asc]email
LHS Multiple Fields /users?sort=[asc]email,[desc]name
RHS Multiple Fields Keyed /users?sort=[asc]email&sort=[desc]name
Plus / Minus Operator /users?sort=+email
Mailjet /users?sort=email+DESC

Conclusion

Use /users?sort=email:ASC . The direction should be optional and should be case in-sensitive with multiple fields separated by comma (,)
For example /users?sort=email:ASC,name:DESC such that email is sorted first and name is sorted second. Using sort=email:ASC,sort=name:DESC is a risk as some query parameter parsers might return values as a map which could lose the sort order of email then name.
Clients

Not sure I like passing in sort in this way, but it's simple. Users of this client will STILL have to lookup "How to do sorting" in the documentation as either way we do it..... it won't be obvious to the user without looking at the documentation.
// Complex... not really useful?
it := client.ListUsers(ListOptions{ Sort: 
   []Sort{ 
	   {Field: "email", Dir: "asc"}, 
	   {Field: "name", Dir: "desc"}, 
   }
)

// Simple... but string manipulation might be needed in some cases.
it := client.ListUsers(ListOptions{ Sort: "email:asc,name:desc"})

var page []Users
for it.Next(ctx, &page) {
	for _, u := range page {
		fmt.Printf("User: %s Email: %s\n", u.Name, u.Email)
	}
}