Handy Library Manager
 for Windows


Help, how to topics > Library Main Catalogue > How to display library new items that were entered today?


How to display library new items that were entered today?

To switch to the All Library Materials display mode, click on Display Each Copy (1). Each bibliographic record includes not only the title, author, and ISBN number but also details about each individual copy of the item, such as the barcode number, call number, price, and entry date.


  • Advanced Search (1) gives access to copy related data fields (for example: barcode, call number, date added, cost, acquisition date, loan status).

  • Select DATE_ADDED (1) in the Field box.
  • Select Is Equal To (2) in the Condition box.
  • Select any date (3) in the Value box.
  • Click Include (4).
  • Search condition is displayed in the Search Conditions box (5).

  • Delete the date "09/10/2016" and enter CURRENT_DATE. CURRENT_DATE is the SQL function that returns the current date value. This search will display library materials created today.
  • The content of the Search Condition box:
    DATE_ADDED=CURRENT_DATE

  • Click Search (1).
  • Review results (2). New library items, added today, will be displayed.
  • Click Save (3) to save the search (query definition) for future use. Handy Library Catalogue lets you to save the most often used queries for future use.

new library items
  • Enter search name (Items Added Today) (1) into the Filter Name box.
  • Click Save (2).

library materials added today
  • Click View to display all predefined searches. The new search definition (query) is listed in the View box. Select Items Added Today (1)
  • Use this view in the following situations:
    - print barcode labels for library materials that were added today
    - print spine labels for library materials that were added today
    - print inventory list report for library items that were added today
    - use this view to create a new view
    (Yesterdays items will be defined as:
    DATE_ADDED=CURRENT_DATE-1)

Question:
I am trying to print labels for new entries to our library database. Can I select a group of new books and print the labels on a single page?

Answer:
Define the search criteria and conditions specifically for the DATE_ADDED field to display only new entries. You can then print labels for the displayed records. Additionally, you can sort your records by the DATE_ADDED field or by ID, ensuring that the records are listed in order of their entry. Select the starting record, and when printing labels, use the option "print from the selected record".


Copyright © 2024 · All Rights Reserved · PrimaSoft PC