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

• Previous message: [ckan-dev] datastore_search_sql, only works for creator of dataset?
• Next message: [ckan-dev] datastore_search_sql, only works for creator of dataset?
• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

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?

• Previous message: [ckan-dev] datastore_search_sql, only works for creator of dataset?
• Next message: [ckan-dev] datastore_search_sql, only works for creator of dataset?
• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]