Handy Library Manager
 for Windows


Help, how to topics > Reservations > How to display future reservations?


Future Reservations

How can future reservations be displayed and processed? Utilize the Advanced Search features to limit the number of reservations shown in the Manage Reservation window.


future reservation, advanced search, next month

To display future reservations, use the Advanced Search feature.

For instance, if today is April 2018 and you want to view only the reservations for May 2018, set your search conditions in the Search Condition box (1).


future reservation, advanced search, use sql

Utilize CURRENT_DATE (1) and manually define the search criteria.

This search will consistently use and compare today's date (as defined by CURRENT_DATE) with the RESERVEDON date. It will only show records where:
- Reserved On is greater than today's date
- Reserved On is less than today's date plus 21 days

You can save (2) the search definition, and it will be listed in the View (3) box for easy access.



Question:



How to use advanced search effectively. How to display reservations for the upcoming month. How to utilize CURRENT_DATE in the search function.

Copyright © 2024 · All Rights Reserved · PrimaSoft PC