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

    How to add more quick limit options

    • Product: Voyager

    Question

    How to add additional quick limits available on Basic search page?

    Answer

    1. cd /m1/voyager/xxxdb/tomcat/vwebv/context/vwebv/ui/<skin>
    2. Open webvoyage.properties for editing.
    3. Find the "Limit To" section and add additional limits in format specified in file.
    4. Save changes.

    Additional Information

    Example lines to add for limit to specific location:

    page.search.limitTo.Main=
    page.search.limitTo.Main.limit=LOCA=Main
    page.search.limitTo.Main.order=5
    page.search.limitTo.Main.text=Main Library
    

    Where LOCA= value is the Location Limit Group name in System Administration

     

    You can use this handy SQL query in Prepackaged Access Reports to identify the Voyager Locations that are associated with Location Limit Groups:

    SELECT LOCATION_LIMIT.LIMIT_NAME, LOCATION_LIMIT.LIMIT_CODE, 
    LOCATION_LIMIT.SUPPRESS_IN_OPAC, LOCATION.LOCATION_DISPLAY_NAME, 
    LOCATION.LOCATION_NAME, LOCATION.LOCATION_CODE
    FROM (LOCATION_LIMIT INNER JOIN LOCATION_LIMIT_LOCS 
    ON LOCATION_LIMIT.LOCATION_LIMIT_ID = LOCATION_LIMIT_LOCS.LOCATION_LIMIT_ID) 
    INNER JOIN LOCATION ON LOCATION_LIMIT_LOCS.LOCATION_ID = LOCATION.LOCATION_ID
    ORDER BY LOCATION_LIMIT.LIMIT_NAME, LOCATION.LOCATION_DISPLAY_NAME;

     

    Constructing custom SQL queries by request and troubleshooting unexpected results from customer-created SQL queries falls outside the scope of Support. The above has been posted for informational purposes.  Voyager-L and Developer Network are useful resources for finding helpful custom SQL or obtaining assistance from peers in troubleshooting custom queries.

     

    See the WebVoyage Architecture Overview and Configuration guide, Chapter 4.


    • Article last edited: 15-Jun-2020
    • Was this article helpful?