[ckan-dev] DataStore API documentation update?

Tue Oct 31 21:32:15 UTC 2017

Hi there,

We've just discovered a quirk of the DataStore API in that column names
that are ALL CAPS need to be quoted in order for the sql statement to
correctly return results.

For context we're on postgres 9.5 running 2.6.4 CKAN core.

I'd like to add a note in the docs for this as it was a source of many
frustrations until we worked it out and want to save other devs from our
pain :D

Which branch in the ckan/ckan repo is the best to contribute a
documentation update please so that it gets back/forward ported to the
current supported versions of core?

I think it should be a new "note" added at this point in the docs:
http://docs.ckan.org/en/ckan-2.7.2/maintaining/datastore.html#ckanext.datastore.logic.action.datastore_search_sql

Many thanks,

C.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.okfn.org/pipermail/ckan-dev/attachments/20171101/4a69120a/attachment-0002.html>