Home / Library Software / Handy Library Manager / Tutorials: Library data analysis, ready-to-use sql queries

Handy Library Manager  for Windows

Help, how to topics > Custom Views > Free, ready-to-use custom views


This topic explains:

  • gives access to ready-to-use custom views
  • includes short explanation about the view

Custom Views, ready-to-use:

  • Review the list.
  • Copy the text from the box. Paste the text into the Custom View Definition box. Click Display to test the custom view. Click Save View to save for future use. (How to save a new custom view?)

Items Never Loaned Out

Items never loaned out: this view displays the list of items from your library that were never loaned out.


Number of Loans By Year_Month

Your library has loan transactions processed over several years. You would like to see the number of circulations by month together with the year (example "2018 / 01").

Explanation: the SQL query extracts month number from the loan date (January will be 1), to have results in order the month number is converted to 01.

library circulation transactions by month plus year, sql query


Library Replace Cost Of Not Returned Items

What is the cost of the not returned library items? How to list the not returned library items together with the replace cost?

library replace cost of not returned items, sql query
library replace cost of not returned items, report

Questions:


Handy Library Manager

software
tour
features
try now
cloud

Copyright © 2018 · All Rights Reserved · PrimaSoft PC