I never set up the alert, so I have nothing to export and share, but I did do a little bit of sql in that direction.
This is pending moves 2 weeks out by system user, so it’s looking only for the moves scheduled by the current logged in user. This may not be
what you want, but maybe it gives you a starting place? I scanned it and it looks like it’s not dependent on any views particular to PMA, so you might be able to plug and play.
If you do create an alert, or if anyone else does so, I would definitely like to see the results!
--Jessica
select
distinct c.componentnumber
,convert(varchar(10),ol.transdate,121)
as PendingDate,
case
when l.[External]=0
then
substring(l.LocationString,charindex(',
',l.locationstring,1)+2,LEN(l.locationstring))
else l.LocationString
end
as MoveToLocation
, ol.requestedby
from objlocations
as ol
inner
join locations as l
on ol.locationid
= l.locationid
left
outer join objcomponents
as c on c.componentid
= ol.componentid
inner
join objects
as o on c.objectid
= o.objectid
where ol.transstatusid
= 0
and
datediff(week,getdate(),convert(datetime,ol.transdate,121))
between 0 and 2
and
(ol.transcodeid
> 7 and ol.transcodeid
< 10)
and ol.loginid
= (
select top 5
substring(system_user,
charindex('\',system_user)+1
,
len(system_user))
as [login])
order
by pendingdate, movetolocation, c.componentnumber
Jessica Milby
Assistant Director for Collection Information
t
215-684-7283
f
215-235-0035
Philadelphia Museum of Art
PO Box 7646, Philadelphia, PA 19101-7646
www.philamuseum.org
From: The Museum System (TMS) Users [mailto:[log in to unmask]]
On Behalf Of Kimberly Koons
Sent: Thursday, November 12, 2015 9:49 AM
To: [log in to unmask]
Subject: alert for scheduled moves
Listserv -
Change of strategy on my recent query searching for an alert on exhibit rotations (no response). Since this will likely need to be object-by-object, it seems scheduled moves would be a better way to go at
this.
Anyone have an alert out there that lets you know x days ahead of a scheduled move?
--
Kimberly Koons, Presidential Libraries Museum Collections Officer
National Archives & Records Administration
700 Pennsylvania Ave., NW
Washington, D.C. 20408
202-357-5082
301-837-0873
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.
signoff TMSUSERS
// eoj
You will receive a confirmation that your subscription has been removed.