Skip to main content
  • Subscribe by RSS
  • Ex Libris Knowledge Center

    Unable to sort by Patron ID in Search Borrowing requests

    • Product: Voyager
    • Product Version: 6.0.2


    Users receive an error when performing a borrowing request search that includes archived requests and sorts by PatronID.

    Defect Status

    Issue VYG-4596/16384-20049 is currently in Development.

    Replication steps

    1. Go to ILL Management>Go To Borrowing>Search Borrowing Requests
    2. Check "Include Requests from the archive"
    3. Select "Sort by: PatronID"
    4. Click "Find them now"
    5. Receive error: "The ORDER BY expression (Patron1) includes fields that are not selected by the query. Only those fields requested in the first query can be included in an ORDER BY expression."

    • Article last edited: 08-Oct-2013