search

cphsolutionslab / ckanext-dataproxy

Use foreign data wrappers as source for the datastore in CKAN
11 stars 14 forks source link

Dynamic join #4

Open beechnut opened 9 years ago

beechnut commented 9 years ago

The DataStore API allows you to dynamically join tables. Is this doable in dataproxy, and if so, how?

ozooner commented 9 years ago

datastore_search_sql method takes in a SQL query that is specific to PostgreSQL. While it would be possible to also proxy queries to target database (query syntax would have to be appropriate), it is currently not implemented.