Sorting results in v2 doesn't seem to work?

[Josh Adams]

No matter what search I do, or what field I specify in "resultSort" and "resultOrder", it just sorts by the ID key (alphabetically, not numerically).

... "objectType": "animalBreeds", "objectAction": "search", "search": { "resultLimit": 10, "resultSort": "breedName",  "resultOrder": "desc", "filters": [ { "fieldName": "breedSpecies", "operation": "contains", "criteria" : "dog" } ], "fields": ["breedName" ] }

returns:

   "data" : {
      "218" : {
         "breedName" : "Wheaten Terrier"
      },
      "219" : {
         "breedName" : "Whippet"
      },
      "220" : {
         "breedName" : "White German Shepherd"
      },
      "221" : {
         "breedName" : "Wire-haired Pointing Griffon"
      },
      "222" : {
         "breedName" : "Wirehaired Fox Terrier"
      },
      "223" : {
         "breedName" : "Wolf Dog"
      },
      "224" : {
         "breedName" : "Yorkshire Terrier Yorkie"
      },
      "422" : {
         "breedName" : "Yellow Labrador Retriever"
      },
      "424" : {
         "breedName" : "Xoloitzcuintle/Mexican Hairless"
      },
      "964" : {
         "breedName" : "White Swiss Shepherd Dog (Swiss Berger)"
      }
   },

What gives?

Josh

[Richard Saffell]

Josh,

Pretty sure that's actually your client sorting by the ID field. Look at the raw results from the API to confirm the expected sort.

If you search for your client should should find a way to disable the sorting of the array.

I took your same request and I see the results sorted by breedName:

[Josh Adams]

Indeed! I was using curl, passing result through json_pp, which apparently is sorting the keys. How embarrassing!

Thanks!

Josh