[ckan-dev] datastore_search_sql, only works for creator of dataset?

Wed Dec 4 17:02:56 UTC 2013

Hi Henrik,

The url doesn't work for me. I did however try a query on demo.ckan.org and
it worked just fine. Can you give us your CKAN version? Do you have the
postgres users for the datastore correctly setup, i.e., does the read-only
user only have read-only access?

Nigel Babu

Developer  |  @nigelbabu <https://twitter.com/nigelbabu>

The Open Knowledge Foundation <http://okfn.org/>

Empowering through Open Knowledge

http://okfn.org/  |  @okfn <http://twitter.com/OKFN>  |  OKF on
Facebook<https://www.facebook.com/OKFNetwork> |
Blog <http://blog.okfn.org/>  |  Newsletter<http://okfn.org/about/newsletter>

 CKAN | http://ckan.org/ | @CKANproject
<http://twitter.com/CKANproject> |the world’s leading open-source data
portal platform

On 3 December 2013 13:00, Henrik Aagaard Sørensen <BU1G at tmf.kk.dk> wrote:

> I haven't made my own extension. This is the query I'm trying to execute:
>
> http://data.kk.dk/api/action/datastore_search_sql?sql=SELECT+%22parkomat_id%22%2C+%22wkb_geometry%22%2C+count%28%22tlRecordID%22%29+FROM+%22f51463ac-d6ef-434e-bd40-b398c11fdc1d%22+LEFT+JOIN+%22660e19fa-8838-4a5c-9495-0d7f94fab51e%22+ON+%22tlPDM%22+%3D+%22parkomat_id%22+AND+NOW%28%29+BETWEEN+%22tlPayDateTime%22+AND+%22tlExpDateTime%22+GROUP+BY+%22parkomat_id%22%2C+%22wkb_geometry%22
>
> Combining these two resources:
>
> http://data.kk.dk/dataset/parkomater/resource/f51463ac-d6ef-434e-bd40-b398c11fdc1d
>
> http://data.kk.dk/dataset/parkomat-transaktioner/resource/660e19fa-8838-4a5c-9495-0d7f94fab51e
>
> Does it work for you guys?
> _______________________________________________
> ckan-dev mailing list
> ckan-dev at lists.okfn.org
> http://lists.okfn.org/mailman/listinfo/ckan-dev
> Unsubscribe: http://lists.okfn.org/mailman/options/ckan-dev
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.okfn.org/pipermail/ckan-dev/attachments/20131204/e6cdc370/attachment-0003.html>