Thanks, Rupert. I will give this a try. We just (as of yesterday) upgraded to TMS 2018. I'm test-piloting it to make sure everything still works fine for us, then having our IT people port everyone else over.
Best,
Aaron
NASHER MUSEUM OF ART AT DUKE UNIVERSITY<http://www.nasher.duke.edu/>
box 90732 durham nc 27708-0732
t +1 919 684 1971
f +1 919 681 8624
e [log in to unmask]<mailto:[log in to unmask]>
________________________________
From: The Museum System (TMS) Users <[log in to unmask]> on behalf of Shepherd, Rupert <[log in to unmask]>
Sent: Tuesday, December 11, 2018 4:26 AM
To: [log in to unmask]
Subject: Re: Reporting on media-related constituents
Try ConXrefs.TableID = 322.
23 would be linking constituents to constituents, which is handled in the Associations table.
I usually refer to the schema diagrams to confirm the relevant joins; they'll be in your folder of upgrade files, though I think were last issued in 2014: the ones I use (and we're on 2016 R2) are in ..\TMS2014_(from_2012)\Documentation\Data Dictionary\TMS 2014 Schema diagrams.
Hope this helps!
Rupert
Rupert Shepherd, PhD FSA
Collection Information Manager
[log in to unmask]<mailto:[log in to unmask]>
Tel: +44 (0)20 7747 5921
-----Original Message-----
From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Aaron Zalonis
Sent: 11 December 2018 02:13
To: [log in to unmask]<mailto:[log in to unmask]>
Subject: Re: Reporting on media-related constituents
I'm working with this but I'm a little confused; there is no tableID = 23 in ConXrefs.TableID.
Best,
Aaron
-----Original Message-----
From: The Museum System (TMS) Users <[log in to unmask]> On Behalf Of Smith, Jeffrey
Sent: Monday, December 10, 2018 3:17 PM
To: [log in to unmask]<mailto:[log in to unmask]>
Subject: Re: Reporting on media-related constituents
Attached is a picture of the table linking you'll need to use. Selection formula must include {ConXrefs.TableID} = 23 (meaning constituents) and {ConXrefDetails.UnMasked} = True.
-----Original Message-----
From: The Museum System (TMS) Users <[log in to unmask]> On Behalf Of Aaron Zalonis
Sent: Monday, December 10, 2018 1:37 PM
To: [log in to unmask]<mailto:[log in to unmask]>
Subject: Reporting on media-related constituents
Hi, all,
Has anyone ever created a report that reports on media-related constituents? Despite all my efforts, I'm failing miserably at this. Any advice or actual reports is greatly appreciated.
All my best,
Aaron
AARON ZALONIS
ASSISTANT REGISTRAR / DATABASE MANAGER
NASHER MUSEUM OF ART AT DUKE UNIVERSITY
box 90732 durham nc 27708-0732
To unsubscribe, send an email to [log in to unmask]<mailto:[log in to unmask]> with the following commands in the body of the email:
signoff TMSUSERS
// eoj
You will receive a confirmation that your subscription has been removed.
To unsubscribe, send an email to [log in to unmask]<mailto:[log in to unmask]> with the following commands in the body of the email:
signoff TMSUSERS
// eoj
You will receive a confirmation that your subscription has been removed.
To unsubscribe, send an email to [log in to unmask]<mailto:[log in to unmask]> with the following commands in the body of the email:
signoff TMSUSERS
// eoj
You will receive a confirmation that your subscription has been removed.
To unsubscribe, send an email to [log in to unmask]<mailto:[log in to unmask]> with the following commands in the body of the email:
signoff TMSUSERS
// eoj
You will receive a confirmation that your subscription has been removed.
To unsubscribe, send an email to [log in to unmask] with the following commands in the body of the email:
signoff TMSUSERS
// eoj
You will receive a confirmation that your subscription has been removed.