[ckan-dev] DataStore API documentation update?

Cam Findlay cam at camfindlay.com
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>


More information about the ckan-dev mailing list