talk@lists.collectionspace.org

WE HAVE SUNSET THIS LISTSERV - Join us at collectionspace@lyrasislists.org

View all threads

Complex PSQL query challenge, get objectProductionPlace and all Broader Contexts

YN
Yousuf Nejati
Fri, Sep 23, 2016 7:55 PM

Hey everyone,

My question is in regards to obtaining all of the 'Broader Context' 'Place
[Local Places]' of a 'Production Place.' Any ideas?

In hopes that we start migrating the Talk list over to a more user friendly
forum setting, please see my question here, located within the
CollectionSpace wiki:

https://wiki.collectionspace.org/questions/164561506/psql-query-to-obtain-a-local-place-term-and-related-sub-terms-by-using-objectproductionplace

And, in general:

https://wiki.collectionspace.org/questions

Thank you!

--
Yousuf Nejati

  • Junior Software Developer*
    Granite Horizon
    Web Design and Development | Enterprise Content Management | IT Consulting

yousuf.nejati@granitehorizon.com greg@granitehorizon.com
granitehorizon.com
(888) 354-6626 x786 <%28888%29%20354-6626%20x730> | (916) 647-6350 x786
<%28916%29%20647-6350%20x730> | (866) 867-7126 (fax)
8153 Elk Grove Boulevard Suite 20
Elk Grove CA 95758-5965

Hey everyone, My question is in regards to obtaining all of the 'Broader Context' 'Place [Local Places]' of a 'Production Place.' Any ideas? In hopes that we start migrating the Talk list over to a more user friendly forum setting, please see my question here, located within the CollectionSpace wiki: https://wiki.collectionspace.org/questions/164561506/psql-query-to-obtain-a-local-place-term-and-related-sub-terms-by-using-objectproductionplace And, in general: https://wiki.collectionspace.org/questions Thank you! -- Yousuf Nejati * Junior Software Developer* Granite Horizon Web Design and Development | Enterprise Content Management | IT Consulting yousuf.nejati@granitehorizon.com <greg@granitehorizon.com> granitehorizon.com (888) 354-6626 x786 <%28888%29%20354-6626%20x730> | (916) 647-6350 x786 <%28916%29%20647-6350%20x730> | (866) 867-7126 (fax) 8153 Elk Grove Boulevard Suite 20 Elk Grove CA 95758-5965
JB
John B Lowe
Fri, Sep 23, 2016 8:45 PM

Yousuf,

Great question!

No, there's no easy way to do with using the regular CSpace UI or tools.

However, we have done it in several ways with webapps and other custom
queries. I have written some of this up in the Questions forum where you
posted it.

Do let's continue our conversation there.

Cheers,

John

Yousuf, Great question! No, there's no easy way to do with using the regular CSpace UI or tools. However, we have done it in several ways with webapps and other custom queries. I have written some of this up in the Questions forum where you posted it. Do let's continue our conversation there. Cheers, John
RM
Richard Millet
Fri, Sep 23, 2016 8:49 PM

Thanks John and Yousuf.  I also added my response to the Questions site at:

https://wiki.collectionspace.org/questions/164561506/psql-query-to-obtain-a-local-place-term-and-related-sub-terms-by-using-objectproductionplace

Let's get that Questions site going!!!


From: Talk talk-bounces@lists.collectionspace.org on behalf of John B Lowe jblowe@berkeley.edu
Sent: Friday, September 23, 2016 1:45 PM
To: Yousuf Nejati
Cc: CollectionSpace Talk List
Subject: Re: [Talk] Complex PSQL query challenge, get objectProductionPlace and all Broader Contexts

Yousuf,

Great question!

No, there's no easy way to do with using the regular CSpace UI or tools.

However, we have done it in several ways with webapps and other custom queries. I have written some of this up in the Questions forum where you posted it.

Do let's continue our conversation there.

Cheers,

John

Thanks John and Yousuf. I also added my response to the Questions site at: https://wiki.collectionspace.org/questions/164561506/psql-query-to-obtain-a-local-place-term-and-related-sub-terms-by-using-objectproductionplace Let's get that Questions site going!!! ________________________________________ From: Talk <talk-bounces@lists.collectionspace.org> on behalf of John B Lowe <jblowe@berkeley.edu> Sent: Friday, September 23, 2016 1:45 PM To: Yousuf Nejati Cc: CollectionSpace Talk List Subject: Re: [Talk] Complex PSQL query challenge, get objectProductionPlace and all Broader Contexts Yousuf, Great question! No, there's no easy way to do with using the regular CSpace UI or tools. However, we have done it in several ways with webapps and other custom queries. I have written some of this up in the Questions forum where you posted it. Do let's continue our conversation there. Cheers, John