Patentsview Plant Patent Sorting Problem
Here's a get to the patents endpoint for three plant patents.
q={"patent_number":["PP4000","PP24000","PP10000"]}&s=[{"patent_number":"asc"}]
I asked for the sort to be by patent number asc. It looks like an
alpha sort is being applied. The sql might need to be
"order by length(patent_number), patent_number"
Utility patents might have the same problem when the patent number
gets to 10,000,000. As I write this utility patent number 9,479,999 has been issued.
Update: The 10 millionth patent has been issued and is now in the patentsview database!
As predicted, the sort is
alphabetic rather than numeric.