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.