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]
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]
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]
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]
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] 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.
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.
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.