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.