API Case Sensitivity?

[paradoxxjm]

Currently the API call records are case sensitive, and they probably don't need to be.
For example:
If you query the number of farmers in St Thomas who have last name Johnson with a common "johnson", the API returns no farmers. But if you change it to "Johnson" it returns 9 records.

Lower-case "johnson" : http://agriapi.herokuapp.com/farmers/?res_parish=ST.THOMAS&last_name=johnson
Upper-case "Johnson" : http://agriapi.herokuapp.com/farmers/?res_parish=ST.THOMAS&last_name=Johnson

[paradoxxjm]

@redrory here is the API case sensitivity bug I was talking about. You can run the above queries to see the effect.

[varunity]

For now there is a work around on how to accomplish this. For an API call like the one above that is not case sensitive, try specifying the farmer's last name as a search term instead. Eg. http://harvestdata.herokuapp.com/farmers/?res_parish=ST.THOMAS&search=johnson .

I'll leave this issue open in case we need to address case-sensitive filtering on fields in the near future.