Handy Library Manager, tutorial: how to sort library databases

Library Software for Windows

Handy Library Manager
for Windows

Library Software / Handy Library Manager
Get Free Trial Buy Now

Help, how to topics > Library Main Catalogue > Sorting the library databases.

ask a question, report a problem, ...

< library item fields, things to know

library grid >

Sorting the library databases.

Sorting records involves changing the order in which they are displayed and printed, while the underlying data structure of the file remains unchanged.

Our library application can perform either one-level or multi-level sorting, depending on the number of fields included in the sorting criteria.

You can access the sort functions through the Default Sort Options, the Popup Sort Commands, or by clicking on the Column Grid.

Click the Sort (1) button to open the Default Sort Options.
Move a mouse cursor over the Sort button to display popup message with the default ordering message (2).
Set the default order in the Default Sort Options window. The default order is applied to the data every time you open the table.

Set the default order in the Default Sort Options window. The default order is applied to the data every time you open the table.
The sample window displays two level sort definition for the library main catalog. The TITLE is a primary sort field, and the AUTHOR is the secondary sort field.

One-Level Quick Sorting:
To sort a column, click the left mouse button on the column header. Clicking again will toggle the sort order between ascending and descending.

One-Level Multi-Level Quick Sorting:
To access multi-level sorting options, right-click on the column header to display a popup menu. The sorting commands in the popup allow you to organize your data by any column (data field) displayed in the grid. Select "Sort Ascending" or "Sort Descending" to set a single-level sort. For multi-level sorting, choose "Add Sort Ascending" or "Add Sort Descending" to include additional levels of sorting.

These quick sorting commands enable you to establish a new order based on any of the data fields visible in the grid.

Question:
Is it possible to generate a report sorted by multiple fields? If so, how do I do this? I want a report that has ID number, title, author, category and call number, sorted first by category and then id number.

Answer:
Organize (sort) your records by category and then by ID number for the Library report. This sort order will be reflected in the final report.

Question:
I noticed today some of the book titles are missing from our new database. I would like to sort the library database sort by barcode so I can check my two databases. Please let me know how to sort by barcode.

Answer:
You can define the sorting options in the sort window by selecting the BARCODE. Additionally, you can add the BARCODE data field to the grid and click the column header to sort by this field.