Guys, I'm trying to find out where everything i see on the front end goes in the back end. Some things are easier to find based on their names, things like acquisitions and groups. However, I can't find a table for items in the catalogue. Also, when creating reports, what is the best way to reference an image? Is it via url or do I have to convert a binary to image? Thanks! -chris

> I'm trying to find out where everything i see on the front end goes in the back end. Some things are easier to find based on their names, things like acquisitions and groups. However, I can't find a table for items in the catalogue. Here's a link to some informal notes on how to incrementally start out when constructing SQL queries of CollectionSpace's back end database, including querying Cataloging records: https://wiki.collectionspace.org/display/~aronr/Getting+ started+with+SQL+queries+of+the+CollectionSpace+databases <https://wiki.collectionspace.org/display/%7Earonr/Getting+started+with+SQL+queries+of+the+CollectionSpace+databases> (See the newly-added notes at the end, as well, on how to identify the tables holding the multivalued/repeating fields associated with Cataloging records or any other specific record type ...) Here's some more background on CollectionSpace's data model, thanks to Richard and Yousuf: https://wiki.collectionspace.org/cq/viewquestion.action?id=163840480&questionTitle=is-there-or-does-anyone-have-a-current-data-model-collectionspace (Accessing the above link requires logging into the CollectionSpace wiki <https://wiki.collectionspace.org/display/collectionspace/Wikis>.) > Also, when creating reports, what is the best way to reference an image? Is it via url or do I have to convert a binary to image? AFAIK, for static images, at least, you can use a URL. That's how the CollectionSpace logo is referenced in some demonstration reports; e.g.: https://github.com/collectionspace/services/blob/9f4ee01df5992cd85ac69c24db845de11f57e77d/services/report/3rdparty/jasper-cs-report/src/main/resources/acq_basic.jrxml#L73-L76 For images associated with Media Handling records, I'm hoping someone else might respond here ... On Wed, Aug 31, 2016 at 4:11 PM, toolhater <toolhater@yahoo.com> wrote: > Guys, > > I'm trying to find out where everything i see on the front end goes in the > back end. Some things are easier to find based on their names, things like > acquisitions and groups. However, I can't find a table for items in the > catalogue. Also, when creating reports, what is the best way to reference > an image? Is it via url or do I have to convert a binary to image? > > Thanks! > > -chris > > _______________________________________________ > Talk mailing list > Talk@lists.collectionspace.org > http://lists.collectionspace.org/mailman/listinfo/talk_ > lists.collectionspace.org > >