Hmmm, I took out the last line, selected “Loans” for Modules, and pressed “save”.  It’s not doing anything…  Updated SQL:

 

Select Loans.LoanNumber, Constituents.DisplayName As 'Lender/Borrower', Loans.EndISODate as EndDate

from Loans inner join vConXrefs_Classic on Loans.PrimaryConXrefID=vconxrefs_classic.ConXrefID

inner join Constituents on vConXrefs_Classic.ConstituentID=Constituents.ConstituentID

where  len(Loans.EndISOdate) = 10 /*if len is 10, date has year and month and day*/

and datediff(week,getdate(),convert(datetime,loans.EndISODate)) between 0 and 8

 

 

Best Regards,

Sarah Gillis | Assistant Registrar, Image Management

WORCESTER ART MUSEUM / www.worcesterart.org
fifty-five salisbury street / worcester, massachusetts 01609
508.799.4406/ direct 508.793.4427 / fax 508.799.8638

 

 

 

*****************************************************************************

Please contact Bridgeman or Davis Art Images for High Resolution Images for Publication Needs:

Bridgeman Art Library

 

Davis Art Images

 

**Temporarily Disabled Due to Higgins Integration**

Our image reproduction application is now available online!

Image Reproduction Request

 

Want to own your own custom reproduction of a Worcester Art Museum masterpiece? Visit our partner Rudinec & Assoc. today!

RequestAPrint

Introducing: Zazzle! Our online museum shop where you can purchase custom merchandise containing images from our permanent collection!  Check it out today!

Worcester Art Museum - Zazzle Shop

 

 

From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Hansen, Stephanie
Sent: Monday, February 24, 2014 3:54 PM
To: [log in to unmask]
Subject: Re: Loan Alerts

 

Hi Sarah,

I think it's a problem to use the "order by" for alerts. Take that out and I bet it will work.

Best,

Stephanie

Stephanie Hansen 

Database Administrator / Assistant Registrar for Exhibitions & Loans

Milwaukee Art Museum 
700 N. Art Museum Dr.  |  Milwaukee, WI 53202 
Tel. 414.224.3273   |   Fax. 414.271.7588  |   [log in to unmask]

 

On Mon, Feb 24, 2014 at 2:49 PM, Sarah Gillis <[log in to unmask]> wrote:

Hello TMS-ers:

 

I have a question about an alert that was used in the Loan Module prior to 2012, which has stopped working.  A previous co-worker wrote it and has since moved on to other projects.  Below is the SQL code:

 

Select Loans.LoanNumber, Constituents.DisplayName As 'Lender/Borrower', Loans.EndISODate as EndDate

from Loans inner join vConXrefs_Classic on Loans.PrimaryConXrefID=vconxrefs_classic.ConXrefID

inner join Constituents on vConXrefs_Classic.ConstituentID=Constituents.ConstituentID

where  len(Loans.EndISOdate) = 10 /*if len is 10, date has year and month and day*/

and datediff(week,getdate(),convert(datetime,loans.EndISODate)) between 0 and 8

Order By Loans.EndISODate

 

 

When I select “Loans” for the Module, it freaks out and doesn’t like the last line of the SQL code.  Can anyone help me or share with me one of their alerts that works well for them?  I’d be in your debt!

 

Best Regards,

Sarah Gillis | Assistant Registrar, Image Management

WORCESTER ART MUSEUM / www.worcesterart.org
fifty-five salisbury street / worcester, massachusetts 01609
508.799.4406/ direct 508.793.4427 / fax 508.799.8638

 

 

 

*****************************************************************************

Please contact Bridgeman or Davis Art Images for High Resolution Images for Publication Needs:

Bridgeman Art Library

 

Davis Art Images

 

**Temporarily Disabled Due to Higgins Integration**

Our image reproduction application is now available online!

Image Reproduction Request

 

Want to own your own custom reproduction of a Worcester Art Museum masterpiece? Visit our partner Rudinec & Assoc. today!

RequestAPrint

Introducing: Zazzle! Our online museum shop where you can purchase custom merchandise containing images from our permanent collection!  Check it out today!

Worcester Art Museum - Zazzle Shop

 

 

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.