Return to Card Catalog Search

Table Use Guidelines

General Search Tips

To search, simply type in your search term in the “Search table” field just above the first column. To reset the table, just remove the search term.

After a search runs, the total number of records retrieved will be displayed at the lower left below the table, e.g., “Showing 1 to 10 of 177 entries”.
Pagination is at the lower right below the table. Click on a page number to go to that page, or use the < and > symbols to move through the pages one by one. Use the << symbol to go all the way back to the first page and the >> symbol to go to the last page.

The term entered in the Search box looks in all fields and finds all records that contain the combination of letters entered. So typing in “Smith” would also return “Smithfield” as one of the results, as well as records in which the first name contains “Smith”.

In some search engines you might use an asterisk as a wild card, e.g., Smith*, to find all records that begin with “Smith”, which would include names such as “Smithfield”.
There is no need to use wild card symbols such as this to search this table.

The table displays a default of 10 rows. You can adjust this using the “Show # entries” dropdown at the top of the table.
Important! If you change “Show # Entries” to show “All Entries”, be sure to change it back to show the default 10 entries before doing another search. Failure to do so will most likely result in an error message.
In general, it is good practice in any case to return to the default prior to doing a new search.

Filtering Initial Results

The main Search box will return all results with that string of letters, so you get both exact matches and partial matches.

By default, the table is sorted by the first column, which will show a dark purple background. Titles that begin with special characters, like quotation marks, are listed alphabetically before titles without leading special characters.

An initial search based will probably return a great many results.
For example, typing “smith” in the main Search box will return results in which “smith” appears anywhere in the record. You can further refine this by typing in one of the filter boxes. For example, typing in “smith” in the Author Last Name box will refine the results to only those records with that author’s name.

All other fields showing a text box with the column title repeated in grayed out text below the column title may be used for further filtering.
These filters are not ‘exact match’, so all records that even partially match what you type in will be returned.

Use of a filter is slower to return results than the main Search box.

The ‘Clear filters’ link in the Table Tools bar above the table will remove any filters you have typed in.
This will not clear your search. To completely reset, remove the name you typed in the Search box earlier.

Table Tools for Exporting

The export tools only use the visible rows. If you have more records than are shown in the default 10 visible rows, you can sequence through each page and repeat the export operation, or you can adjust the number of rows shown using the “Show entries” dropdown above the table.
If you have considerably more than 100 records, it is recommended you only select 100 from the dropdown, export that, then move to the next page and export again.
Important! If you change “Show # Entries” to show “All Entries”, be sure to change it back to show the default 10 entries before doing another search. Failure to do so will most likely result in an error message.
In general, it is good practice in any case to return to the default prior to doing a new search.

Print – Hides all the elements on the page except for the table. The results may look weird for some themes, but it will work correctly for most, and make the view of the page “printable”.

Excel export – Generates an Excel file (not customizable) with the visible table data.

CSV export – Generates a new file that can be opened in a browser or third party spreadsheet editing software. If it is opened in a browser, the file will be in the “Comma-Separated-Values” format out of the table and calls the browser’s “Save as …” dialog so you can choose a path for your file. All the values from your table will be exported including the headers. The cells will be separated by commas, and rows will be separated by line breaks.

Copy to clipboard – Copies all the rows that exist in the page to your OS clipboard, and you can later paste it into some other software. Once you click it, you get a popup with a notification on how many rows were copied to the clipboard, e.g., “Copied 20 rows to the clipboard”. All the rows are copied to the clipboard, including the tab-separated headings. You can then paste it to MS Excel, for example.

PDF export – Generates a new PDF document from the table and calls the browser’s “Save as …” dialog so you can choose a path for your file. It is a very basic PDF document, with the page title, and the table with simple formatting.

Permanent link to this article: https://www.obcgs.com/library/card-catalog-search/table-use-guidelines/