Allow RapidR borrowing renewals to be sent in batch by the Send OCLC Renewal Requests button
Currently, the Send OCLC Renewal Requests button will send out renewals for all requests in the status of "Renewed by Customer to MM/DD/YYYY", but it only works on requests with a SystemID of OCLC. Now that RapidR allows renewals within ILLiad, it would be helpful to be able to batch send requests to Rapid using the same button, so that renewals can be sent out regardless of the System ID.
The query that populates the ESPUpdate table is currently:
"SELECT t.TransactionNumber, t.ILLNumber, t.SystemID FROM Transactions t JOIN Users u ON (t.Username = u.Username) " +
"WHERE ((t.TransactionStatus LIKE N'Renewed by Customer to%') OR (t.TransactionStatus LIKE N'Renewed by ILL Staff to%') OR (t.TransactionStatus = N'Renewal Requested')) " +
"AND t.SystemID = N'OCLC'"
It seems like it could be a simple fix to add Rapid to this string.
ellen abbott commented