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.