[ckan-dev] Join resources

Tue Apr 10 21:49:53 UTC 2018

Thanks! I will check it out.

Would it be possible to see the results it in the Web UI or for that I
should build a Plugin?

D.

Lic. Daniel Foguelman

On Tue, Apr 10, 2018 at 6:42 PM, Stefan Oderbolz <stefan.oderbolz at liip.ch>
wrote:

> Hi Daniel
>
> if the resources are stored in the DataStore (
> http://docs.ckan.org/en/ckan-2.7.3/maintaining/datastore.html), you can
> actually run arbitrary SQL statements on them including an inner join on
> them (http://docs.ckan.org/en/ckan-2.7.3/maintaining/datastore.
> html#ckanext.datastore.logic.action.datastore_search_sql). Is this what
> you've been looking for?
>
> https://demo.ckan.org has DataStore enabled, so you could try it there.
>
> - Stefan
>
>
>
> On Mon, Apr 9, 2018 at 10:05 PM, Daniel Foguelman <dj.foguelman at gmail.com>
> wrote:
>
>> Dear all,
>>
>> I'm looking for an easy way to create / explore / view new datasets. This
>> datasets are just the result of an inner join between join compatible
>> resources.
>>
>> Take for instance dataset A:
>>
>> year, debt
>> 2010, 1000
>> 2011, 900
>> 2012, 800
>> ...
>>
>> And dataset B:
>>
>> year, earnings
>> 2010, 20000
>> 2011, 18000
>> 2012, 23000
>>
>> I would like to dinamically be able to explore the dataset A join B:
>>
>> year, earnings, debt
>> 2010, 1000, 20000
>> 2011, 900, 18000
>> 2012, 800, 23000
>>
>> I have checked in the extensions website (extensions.ckan.org) but
>> couldn't find anythin.
>>
>> Any clues?
>>
>>
>> _______________________________________________
>> 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
>>
>>
>
>
> --
> Liip AG  // Limmatstrasse 183 //  CH-8005 Zürich
> Tel +41 43 500 39 80 // GnuPG 0x7B588C67 // www.liip.ch
>
>
> _______________________________________________
> 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/20180410/a5fbe940/attachment-0003.html>