Hi all,

I have a couple technical questions about the location of dimensions data
in collectionspace.

If the entry for an object's dimensions is not in dimensions_common or
measuredpartgroup, where else would it be? I know the individual parts are
stored in dimensionsubgroup, but it would be nice it the full string/entry
was together.

I'm also looking for some help with the table join for dimensionsubgroup
with collectionobjects_common, in the event that I need to combined all
parts into one for each object.

Thanks for any help!
Jonathan

Jonathan,

We just noticed that no one ever responded to your post to the Talk list.  I'll take a look right now and see if I can answer your questions.  Look for another message from me either today or tomorrow morning.

Thank you,

Richard

From: Talk talk-bounces@lists.collectionspace.org on behalf of Jonathan Benoit jbenoit9882@gmail.com
Sent: Monday, April 25, 2016 8:49 AM
To: talk@lists.collectionspace.org
Cc: Jonathan Benoit
Subject: [Talk] dimensions data

Hi all,

I have a couple technical questions about the location of dimensions data in collectionspace.

If the entry for an object's dimensions is not in dimensions_common or measuredpartgroup, where else would it be? I know the individual parts are stored in dimensionsubgroup, but it would be nice it the full string/entry was together.

I'm also looking for some help with the table join for dimensionsubgroup with collectionobjects_common, in the event that I need to combined all parts into one for each object.

Thanks for any help!
[https://ssl.gstatic.com/ui/v1/icons/mail/images/cleardot.gif]
Jonathan

Very nice.  Thanks for reply.

From: Jonathan Benoit jbenoit9882@gmail.com
Sent: Tuesday, May 10, 2016 9:35 AM
To: Richard Millet
Cc: talk@lists.collectionspace.org
Subject: Re: [Talk] dimensions data

Hi Richard,

I was able to figure this one out. In case anyone is curious:

Select string_agg(dimension || ' ' || value || ' ' || measurementunit, '; ')
FROM (SELECT  dimension,value,measurementunit,
rank() over (order by h.pos asc,d.measurementunit desc) rnk
FROM  hierarchy h,dimensionsubgroup d,measuredpartgroup p,hierarchy h2,collectionobjects_common co
where d.idhttp://d.id/ = h.idhttp://h.id/
and p.idhttp://p.id/ = h.parentid
and p.idhttp://p.id/ = h2.idhttp://h2.id/
and  co.idhttp://co.id/ = h2.parentid
and co.idhttp://co.id/ = 'e9d08b3e-fc7b-4451-b48c-5ca88fd60161'
) x

Thanks
Jonathan

On Tue, May 10, 2016 at 12:31 PM, Richard Millet <richard.millet@lyrasis.orgmailto:richard.millet@lyrasis.org> wrote:

Jonathan,

We just noticed that no one ever responded to your post to the Talk list.  I'll take a look right now and see if I can answer your questions.  Look for another message from me either today or tomorrow morning.

Thank you,

Richard

From: Talk <talk-bounces@lists.collectionspace.orgmailto:talk-bounces@lists.collectionspace.org> on behalf of Jonathan Benoit <jbenoit9882@gmail.commailto:jbenoit9882@gmail.com>
Sent: Monday, April 25, 2016 8:49 AM
To: talk@lists.collectionspace.orgmailto:talk@lists.collectionspace.org
Cc: Jonathan Benoit
Subject: [Talk] dimensions data

Hi all,

I have a couple technical questions about the location of dimensions data in collectionspace.

If the entry for an object's dimensions is not in dimensions_common or measuredpartgroup, where else would it be? I know the individual parts are stored in dimensionsubgroup, but it would be nice it the full string/entry was together.

I'm also looking for some help with the table join for dimensionsubgroup with collectionobjects_common, in the event that I need to combined all parts into one for each object.

Thanks for any help!
[https://ssl.gstatic.com/ui/v1/icons/mail/images/cleardot.gif]
Jonathan