Thanks, Chad – that’s very helpful. Question – doesn’t showing locations in a List View get around the security for those who aren’t allowed to see locations?
From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Chad Petrovay
Sent: Friday, April 01, 2016 12:20 PM
Rob, The best way is to use the STUFF function in SQL Server.
SELECT ObjectID
,ISNULL(STUFF((SELECT '; ' + L.LocationString
FROM ObjCurLocView OCL
LEFT JOIN Locations L ON OCL.CurLocationID = L.LocationID
WHERE OCL.ObjectID = O.ObjectID
ORDER BY SortNumber
FOR XML PATH('')), 1, 2, ''),'No location') AS CurrentLocation
FROM Objects O
That's a quick and dirty solution for showing all the locations for all components. You can experiment to develop something more sophisticated for your exact needs. You can find out more about the STUFF function here:
And here:
On Fri, Apr 1, 2016 at 12:02 PM, Rob Morgan <[log in to unmask]> wrote:
Hi Chad,
I want to display the current location for all active components.
Would I need a primary component?
I imagine the user could just sort on component number. For us, ‘primary’ component number = object number. Thus, the secondary, tertiary components would sort after the primary components (our non-primary components are numbered with the obj# followed by text, e.g., 1950.1_frame) .
- Rob
From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Chad Petrovay
Sent: Friday, April 01, 2016 11:33 AM
To: [log in to unmask]
Subject: Re: Current Location in a List View
Yes. But the SQL depends upon what you want in the List View.
If an object has multiple components - do you want to display all the locations or only the location for the primary component. How do you define the primary component (usually the primary has the same component number as the object number)?
These impact how to write the script.
On Fri, Apr 1, 2016 at 11:27 AM, Welsh, Sylvia C. <[log in to unmask]> wrote:
I would be interested in this as well.
Thank you!
Sylvia,
_____________________________
Sylvia Welsh, MS LIS, CSI, LEED AP BD+C
Harvard Planning & Project Management
1350 Massachusetts Avenue, 573
Cambridge, MA 02138
From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Rob Morgan
Sent: Friday, April 01, 2016 11:23 AM
To: [log in to unmask]
Subject: Current Location in a List View
Hello TMS Community,
Has anybody successfully placed current location in a list view? If so, can you send me the SQL script?
Thanks everyone,
Rob Morgan
Collections Database Administrator
The Baltimore Museum of Art
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.
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.
signoff TMSUSERS
// eoj
You will receive a confirmation that your subscription has been removed.