It can - Set the hierarchy control on the locations field to the appropriate hierarchy value, and that should make it more secure. On Fri, Apr 1, 2016 at 1:21 PM, Smith, Jeffrey <[log in to unmask]> wrote: > 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 > > *To:* [log in to unmask] > *Subject:* Re: Current Location in a List View > > > > 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: > > https://msdn.microsoft.com/en-us/library/ms188043.aspx > > > > And here: > > > http://www.sql-server-helper.com/tips/tip-of-the-day.aspx?tkey=3934817c-1a03-4ac9-a0ba-55b2bfbaea0f&tkw=uses-of-the-stuff-string-function > > > > 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 > > T 617-496-8275 F 617-495-0559 > > > > *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. > 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.