Handy Library Manager  for Windows


Help, how to topics > Custom Views > How many copies per title or title+author are there in my library?


How many copies per title or title+author are there in my library?


How many copies per title + author are there in my library?

This view displays TITLE, AUTHOR, and NUMBER OF COPIES.

number of copies per title and author

Copy the text from the above box. Paste the text into the custom view box. Click Save to save the view.


How many copies per title are there in my library?

This view displays TITLE and NUMBER OF COPIES.

number of copies per title

Copy the text from the above box. Paste the text into the custom view box. Click Save to save the view.


How many copies per title are there in my library?

This view displays TITLE and NUMBER OF COPIES.

number of copies per title with range

Copy the text from the above box. Paste the text into the custom view box. Click Save to save the view.



Question: How to display items with the same title?

Question: Is this specific SQL language? My question is how can I design and run reports including and using the Count(*) element, to include number of copies. I'd like to include data in addition to Title and Count in the statistics report. Volunteer Librarian

Question: Could you show me where to find information on what and how the SQL definitions under Statistics, Custom View Assistant work, specifically the "copies per title" sort process? Cannot find anything in the online support pages.

Question: Under the statistics tab, there are a selection of reports available including Copies Per Title. This report appears to list the actual number of copies of each book by title in the library.

Answer: To define query with grouping and more data fields in separate columns you have to group by all those fields. Example:
SELECT B.TITLE, B.AUTHOR, B.PUBLISHER, COUNT(*) FROM LIB_COPIES A JOIN LIBRARY B ON A.IDNO=B.IDNO GROUP BY B.TITLE, B.AUTHOR, B.PUBLISHER ORDER BY B.TITLE

Answer: Our library system is using Firebird SQL.



Copyright © 2019 · All Rights Reserved · PrimaSoft PC