[ckan-dev] Join resources

[Stefan Oderbolz]

This is not yet a core feature, but there is a PR in development that would
cover that: https://github.com/ckan/ckan/pull/3816

But until then, you can use the API to get the JSON result and use whatever
plugin you like to visualize that.

On Tue, Apr 10, 2018 at 11:49 PM, Daniel Foguelman <dj.foguelman at gmail.com>
wrote:

> 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.ht
>> ml#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
>>
>>
>
> _______________________________________________
> 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.okfn.org/pipermail/ckan-dev/attachments/20180411/f4dea84b/attachment-0003.html>