Also, the Entity Relation Diagrams that result from using Jaspersoft Studio to build reports can provide a great visual. -Yousuf On Fri, Dec 16, 2016 at 9:52 AM, Yousuf Nejati <yousuf.cspace@gmail.com> wrote: > Hi Willi, > > I've been working quite extensively with UC Berkeley's CollectionSpace > Django Web Apps which require writing some pretty complicated queries ( > https://webapps.cspace.berkeley.edu). > > Reviewing the impressive work done by John Lowe and his team can give you > a pretty good sense of what's possible. You can find them here: > https://github.com/cspace-deployment/Tools/tree/master/datasources . > > One of the best ways to make things easier is by reading the Nuxeo > documentation on VCS Tables, if you haven't done so already: > https://doc.nuxeo.com/nxdoc/vcs-tables/ > > If you have any specific questions, or need more help, feel free to reach > out. > > Hope this helps. > > -Yousuf >

Willi, On May 10 of this year, Jonathan Benoit shared a query that pulled out dimensions and made a "summary string". You can find it at: http://lists.collectionspace.org/pipermail/talk_lists.collectionspace.org/2016-May/002544.html We here at UCB have derived from this query a summary in a different format for use at the Hearst Museum of Anthropology (PAHMA): https://github.com/cspace-deployment/Tools/blob/master/datasources/pahma/part7.sql Hope this help! John On Fri, Dec 16, 2016 at 9:59 AM, Yousuf Nejati <yousuf.cspace@gmail.com> wrote: > Also, the Entity Relation Diagrams that result from using Jaspersoft > Studio to build reports can provide a great visual. > > -Yousuf > > On Fri, Dec 16, 2016 at 9:52 AM, Yousuf Nejati <yousuf.cspace@gmail.com> > wrote: > >> Hi Willi, >> >> I've been working quite extensively with UC Berkeley's CollectionSpace >> Django Web Apps which require writing some pretty complicated queries ( >> https://webapps.cspace.berkeley.edu). >> >> Reviewing the impressive work done by John Lowe and his team can give you >> a pretty good sense of what's possible. You can find them here: >> https://github.com/cspace-deployment/Tools/tree/master/datasources . >> >> One of the best ways to make things easier is by reading the Nuxeo >> documentation on VCS Tables, if you haven't done so already: >> https://doc.nuxeo.com/nxdoc/vcs-tables/ >> >> If you have any specific questions, or need more help, feel free to reach >> out. >> >> Hope this helps. >> >> -Yousuf >> > > > _______________________________________________ > Talk mailing list > Talk@lists.collectionspace.org > http://lists.collectionspace.org/mailman/listinfo/talk_ > lists.collectionspace.org > >

Thanks all for your help! Sent from my phone ________________________________ From: John B Lowe <jblowe@berkeley.edu> Sent: Dec 16, 2016 11:43 To: William Wolf Cc: CollectionSpace Talk List Subject: Re: [Talk] SQL code snippets? Willi, On May 10 of this year, Jonathan Benoit shared a query that pulled out dimensions and made a "summary string". You can find it at: http://lists.collectionspace.org/pipermail/talk_lists.collectionspace.org/2016-May/002544.html We here at UCB have derived from this query a summary in a different format for use at the Hearst Museum of Anthropology (PAHMA): https://github.com/cspace-deployment/Tools/blob/master/datasources/pahma/part7.sql Hope this help! John On Fri, Dec 16, 2016 at 9:59 AM, Yousuf Nejati <yousuf.cspace@gmail.com<mailto:yousuf.cspace@gmail.com>> wrote: Also, the Entity Relation Diagrams that result from using Jaspersoft Studio to build reports can provide a great visual. -Yousuf On Fri, Dec 16, 2016 at 9:52 AM, Yousuf Nejati <yousuf.cspace@gmail.com<mailto:yousuf.cspace@gmail.com>> wrote: Hi Willi, I've been working quite extensively with UC Berkeley's CollectionSpace Django Web Apps which require writing some pretty complicated queries (https://webapps.cspace.berkeley.edu). Reviewing the impressive work done by John Lowe and his team can give you a pretty good sense of what's possible. You can find them here: https://github.com/cspace-deployment/Tools/tree/master/datasources . One of the best ways to make things easier is by reading the Nuxeo documentation on VCS Tables, if you haven't done so already: https://doc.nuxeo.com/nxdoc/vcs-tables/ If you have any specific questions, or need more help, feel free to reach out. Hope this helps. -Yousuf _______________________________________________ Talk mailing list Talk@lists.collectionspace.org<mailto:Talk@lists.collectionspace.org> http://lists.collectionspace.org/mailman/listinfo/talk_lists.collectionspace.org