Hi Ed,
The address fields on person and org records are located on a separate contact record. In the database, contacts_common.initem will contain the csid of the person or org that the contact belongs to. So if you have the csid of a person or org, this will get you to the address fields:
SELECT ag.*
FROM contacts_common cc
INNER JOIN hierarchy h
ON h.parentid = cc.id AND h.name = 'contacts_common:addressGroupList'
INNER JOIN addressgroup ag
ON ag.id = h.id
WHERE cc.initem = '[person or org csid]';
Ray
From: Talk talk-bounces@lists.collectionspace.org on behalf of edmundhaardt@halosecuritysystems.com edmundhaardt@halosecuritysystems.com
Sent: Monday, June 3, 2019 11:02:09 AM
To: talk@lists.collectionspace.org
Subject: [Talk] Nuxeo Database Table Relations and Nomenclature
Hello again everyone.
I have a Nuxeo Default database table relations question.
How are the Persons and Addressgroup tables linked? I am trying to link a Donor name to their corresponding address in Jaspersoft Studio for a JRXML report and I cannot find any pertinent documentation anywhere on the matter. I have looked in the Relations Common table and found nothing that pertains to persons.
Also, could someone please forward me the information on nomenclature integration? R&L has contacted Lyrasis to confirm purchase and I’m nearly finished with my report customization. Megan has already forwarded the updated spreadsheet file. I merely require the integration instructions.
The Nomenclature integration will be the final step before I deploy the new instance of CollectionSpace at our museum.
Thank you all again for your kind assistance.
EDMUND HAARDT
Hi Ed,
The address fields on person and org records are located on a separate contact record. In the database, contacts_common.initem will contain the csid of the person or org that the contact belongs to. So if you have the csid of a person or org, this will get you to the address fields:
SELECT ag.*
FROM contacts_common cc
INNER JOIN hierarchy h
ON h.parentid = cc.id AND h.name = 'contacts_common:addressGroupList'
INNER JOIN addressgroup ag
ON ag.id = h.id
WHERE cc.initem = '[person or org csid]';
Ray
________________________________________
From: Talk <talk-bounces@lists.collectionspace.org> on behalf of edmundhaardt@halosecuritysystems.com <edmundhaardt@halosecuritysystems.com>
Sent: Monday, June 3, 2019 11:02:09 AM
To: talk@lists.collectionspace.org
Subject: [Talk] Nuxeo Database Table Relations and Nomenclature
Hello again everyone.
I have a Nuxeo Default database table relations question.
How are the Persons and Addressgroup tables linked? I am trying to link a Donor name to their corresponding address in Jaspersoft Studio for a JRXML report and I cannot find any pertinent documentation anywhere on the matter. I have looked in the Relations Common table and found nothing that pertains to persons.
Also, could someone please forward me the information on nomenclature integration? R&L has contacted Lyrasis to confirm purchase and I’m nearly finished with my report customization. Megan has already forwarded the updated spreadsheet file. I merely require the integration instructions.
The Nomenclature integration will be the final step before I deploy the new instance of CollectionSpace at our museum.
Thank you all again for your kind assistance.
EDMUND HAARDT
