We have this view, but I'm not sure the best way to send it?
SELECT TOP (100) PERCENT ObjectID AS ID, ObjectNumber, SortNumber, ObjectName, Dated, Title AS [Scott Number], Medium, CreditLine, Description,
dbo.Concat_LocationString(ObjectID, 1) AS Location, ObjectCount
FROM dbo.Objects AS O
ORDER BY SortNumber
Caitlin Badowski
TMS Administrator
Smithsonian National Postal Museum
2 Massachusetts Avenue NE, MRC 570
Washington, DC 20013-7012
(202) 633-8735
[log in to unmask]<mailto:[log in to unmask]>
[NPM Logo for Signature Block]
From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Rob Morgan
Sent: Friday, April 01, 2016 11:24 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]<mailto:[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.
|