Help, how to topics > Custom Views > Predefined SQL queries (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 definition from the text box.
Paste the definition into the Custom View Definition box.
Click Display to test the custom view.
Click Save View to save for future use.
Items Never Loaned Out
Items never loaned out: this view displays the list of items from your equipment-tool inventory that were never loaned out.
Number of items with total cost by TYPE
Number of items with total cost by TYPE.
Review query result.
Number of items with total cost by TYPE (only items that cost less than 100)
This is the same query as above, but is using additional condition: use only items that cost less than 100.
Questions:
We offer Handy Library Manager application for libraries that includes the same custom views/statistics functionality. In addition, you can find more how-to and sample topics in the Handy Library-Custom Views-Stats help section.
Latest equipment tracking how to articles:
How to email overdue notices to borrowers?
How to predefine email messages?
How to set automated emails with your Gmail account?
How to set automated emails with your Office365 account?
How to display checked out items in the equipment main inventory?
How to modify due dates for the checked out equipment?
Customized check-out receipt, include all items.
How to send email messages to all equipment users?
How to print group-by reports where each group starts on a new page?
How to export data from a custom view?
How to print, email check-out receipts?
How to modify the grid (number of columns, column size, column position)?
Handy Equipment Management with Check In/Out:
Handy Equipment-Tool Manager
tour
features
try now
cloud
Equpiment, tool tracking software solutions:
- office inventory tracking with check in/out
- equipment tracking, tool crib tracking with check in/out
- av, media equipment with check in/out
- police equipment
- prison, equipment tracking with check in/out
- athletic, sport equipment tracking review
- calibration management software
library software packages (included with handy e-t software):
school library
church library
non-profit org. library
business library
community library
small public library
Copyright © 2023 · All Rights Reserved · PrimaSoft PC