[ckan-dev] DataStore API documentation update?

Wed Nov 1 10:40:39 UTC 2017

Hi Cam,

Please send any patch agaisnt master and make a note on the description or
a comment that it should be backported and we'll cherry-pick it to the
relevant branch.

Thanks!

Adrià

On 31 October 2017 at 21:32, Cam Findlay <cam at camfindlay.com> wrote:

> 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.
>
> _______________________________________________
> ckan-dev mailing list
> ckan-dev at lists.okfn.org
> https://lists.okfn.org/mailman/listinfo/ckan-dev
> Unsubscribe: https://lists.okfn.org/mailman/options/ckan-dev
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.okfn.org/pipermail/ckan-dev/attachments/20171101/45ce1434/attachment-0002.html>