[Workflowtoolkit-l] Routing Rules for Copyright Clearance

[Newman, Lorna (newmanla)]

We created separate routing rules for each instance - example: all requests from users with Department ENGR or CEAS go to a separate queue.

(u.department = 'Engr' or u.department like '%CEAS%') and t.RequestType = 'Article' and len(t.PhotoJournalYear) = 4 and t.PhotoJournalYear < convert(varchar(4),(datepart(year,getdate()) - 5))

You could use the same logic and just add to the beginning of your existing string.  You need to create separate rules because the new transaction status would be the queue you want the requests to go to.

Hope this is helpful.


Lorna Newman
Head, Interlibrary Services and Government Documents Dept.
Langsam Library
University of Cincinnati
P.O. Box 210033
Cincinnati, OH  45221-0033
513-556-1885
e-mail: lorna.newman at uc.edu<mailto:lorna.newman at uc.edu>



From: workflowtoolkit-l-bounces at geneseo.edu [mailto:workflowtoolkit-l-bounces at geneseo.edu] On Behalf Of Frank Haulgren
Sent: Thursday, August 11, 2011 2:08 PM
To: ILLiad Best Practices Workflow Toolkit
Subject: [Workflowtoolkit-l] Routing Rules for Copyright Clearance

The IDS Toolkit has a number of suggestions for routing rules.  One of them allows article requests older than 5 years to bypass the copyright clearance queue and routes those transactions directly to Awaiting Request Processing.  Has anyone modified this routing rule to send those older article requests to multiple queues?  For example we maintain separate queues for faculty and extended ed students and would rather not end up with all of the routed transactions in the more generic Awaiting Request Processing queue.

Seems to me like the suggested matching string:

t.RequestType = 'Article' and len(t.PhotoJournalYear) = 4 and t.PhotoJournalYear < convert(varchar(4),(datepart(year,getdate()) - 5))

Would need to include user status info and perhaps a separate rule would be required for each status exception.

Frank Haulgren
Western Libraries, Western Washington University

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.geneseo.edu/pipermail/workflowtoolkit-l/attachments/20110811/1e4a1beb/attachment-0001.html>