June 6, 2023.

• Adapt to incomplete custom queries and reservation processes.
• Added SQLite table trigger item_borrower_trigger.
• Added volume_number field to book category. GitHub ticket #227.
• Allow pasting of images into Back and Front cover image containers. GitHub ticket #284.
• Allow resetting of highlight colors: Other Options -> Custom Query.
• Android and Qt 6.2 LTS.
• Archived release notes.
• Avoid creating expensive program objects if they are not necessary: Members Browser -> Print Selected Member's Reserved Items.
• Batch returns. GitHub ticket #280.
• Book import template 2 was missing alternate_id_1.
• Center PDF progress dialogs.
• Copy Browser did not contain the correct number of reserved non-book items. The process was incomplete. Completed!
• Corrected Custom Query syntax colors table sorting.
• Corrected printing of books.
• Custom query favorite and shortcut. See also Other Options -> Shortcuts. GitHub ticket #279.
• Display a gentle and persistent reminder in the status bar if a new version of BiblioteQ is available.
• Display brief summaries in favorite actions.
• Enable clear button for many text fields.
• Enable sorting for table widgets in Other Options.
• Final Windows x86 packaged release. Future Windows releases will include Qt 6 LTS and Windows x86-64.
• For new installations, the following options will be enabled: Populate Administrator Browser On Display, Populate Database Enumerations Browser On Display, and Populate Members Browser On Display.
• Include target audience in book view. GitHub ticket #294.
• Infinite intelligent Custom Query windows.
• LTS release! Several accumulated bundles included.
• Native dialogs and menus. File dialogs remain non-native.
• New Year's End convenience widget in patron information. GitHub ticket #297.
• On-top Member's Reservation History window. GitHub discussion #248.
• On-top Members Browser window. GitHub discussion #248.
• Optional member reservation history for SQLite databases.
• PostgreSQL and compression. See SQL/postgresql_update_schema.sql.
• Qt 5.15.9 for MacOS. Some releases do not include this item in their release notes but will in the future.
• Qt 6.5 LTS compliant.
• Removed SQL keywords for highlighting: INSERT INTO, INSERT INTO SELECT, and SELECT INTO.
• Replaced error() with errorOccurred() in Qt 5.15 and newer for QNetworkReply.
• Reset post-query highlight colors for books, journals, and magazines as necessary.
• SQLite upgrade tool: all or recent. Please see Tools menu. Always create a copy of the SQLite file before upgrading!
• Set highlights of Custom Query text immediately after colors are configured and saved.
• Unlimited queries for PostgreSQL. Please be careful!
• YAZ 5.34; W32.

March 15, 2023.

• C++17.
• Initialize visible Members Browser columns.
• Some containers may be intentionally empty. Added label reminders.

March 10, 2023.

• Options -> Select Global Font is now available on MacOS.
• Visible Members Browser columns: Other Options -> Members -> Visible Columns. GitHub ticket #246.

March 3, 2023.

• Initialize Other Options -> Items -> Item Fields. GitHub ticket #276.
• New biblioteq-darkmode.bat Windows file.

February 25, 2023.

• Improved processing of duplicate cover images. Decreased memory consumption.
• Improved recording of SQL syntax colors. Example INI value: keyword=color. Existing values will not be ported. Apologies!
• Intelligent woody trees.
• Preserve boldness of fonts, if possible.
• Remove trailing semicolons from custom-query search strings. The semicolons produce errors in SQLite.
• Reviewed all UNION statements. Replaced UNION with UNION ALL. Separate sets do not require pruning.
• Show query completion time in the main window's status bar. Not all queries are measured.
• Validate Reservations Minimum Days integer input in Database Enumerations Browser.

February 20, 2023.

• Added find function for and to the main table.
• Custom Query SQL language highlights. GitHub ticket #246.
• New Custom Query Other Options panel. GitHub ticket #246.

January 25, 2023.

• Ability to export member history as a CSV file. GitHub discussion #274.

January 16, 2023.

• Allow renaming of Custom Query favorites. GitHub discussion #255.
• Batch Activities Browser: do not display a file dialog if an export would be empty.
• Book SRU query results: set Alternate Identifier to control field 003's ark value if Alternate Identifier is empty. GitHub discussion #268.
• CSV Import Browser: empty ISBN-10 and ISBN-13 substitutions. Values may be prepared manually.
• Completed GitHub ticket #228. Allow UPDATE queries on selected items.
• Custom queries executed via the Custom Query menu will be executed through the same logic as the Custom Query browser.
• Do not convert ISBN-13 to ISBN-10 unless the prefix is 978 (biblioteq_misc_functions::isbn13to10()). GitHub ticket #269.
• Do not disconnect the current database if a future database does not have a database driver.
• Happy New Year!
• Item field colors. New options in Other Options. GitHub ticket #272.
• Publication Date Formats are now open. Correct formats are expected. See Other Options. GitHub ticket #270.
• Replaced all instaces of MM/dd/yyyy with biblioteq::s_databaseDateFormat. GitHub ticket #270.
• Show a warning label if the selected database's driver does not exist in Branch Selection.
• Some operators believe that BiblioteQ should correct their malformed data regardless of the effort, interest, and time. Modified the import mechanism such that it attempts to correct publication dates. GitHub ticket #270.
• Source-only release! Preparing release files requires a significant effort and an interest. Requests for release files will be ignored! Apologies. The tar bundle for Linux is created in Ubuntu 20.04.

December 25, 2022.

• Added book_target_audiences to Custom Query tree widget.
• Added book_target_audiences to Merge SQLite Databases.
• Added member_history_dnt to Custom Query tree widget.
• Allow null ISBN book searches.
• Audio and Batch Activities Browser. Multimedia system required.
• Avoid searching of duplicate items in Batch Activities Browser.
• Bottom-scroll-on-add added to Batch Activities Browser. Setting is ephemeral.
• Close and reset the Merge SQLite Databases window upon a database disconnect.
• Completed Qt 6.2 LTS regular expressions. Some glitches may remain.
• Corrected discovery of grey literature items in the Batch Activities Browser. Problem caused by referencing incorrect database field.
• Corrected grey literature searches. The query was missing fields.
• Corrected magazine searches. The query was missing a space character.
• Corrected queries which include single quotes for SQLite and PostgreSQL.
• Corrected section scrolling order in Database Enumerations Browser.
• Custom queries and favorites. Please see Custom Query and View menu.
• Do not include empty myoid information in the Merge SQLite Databases utility during error reporting.
• Export missing items function in Batch Activities Browser's Discover panel.
• Hyperlinks for SQLite. Please activate a link by pressing and holding the Alt key while clicking on the link. Also functional on editable PostgreSQL entries.
• Ignore empty scanned input in Batch Activities Browser.
• Improved error reporting of biblioteq_misc_functions::getNextCopy().
• Include item title in the Discover portion of the Batch Activities Browser.
• New database tables book_conditions, book_originality. Please upgrade the databases. Static values have been removed from relevant widgets.
• Removed Poppler (PDF), PostgreSQL, and YAZ from MacOS.
• Removed SQLite libraries and source. Qt provides sufficient SQLite services.
• Removed duplicate tool tips from Other Options.
• Reset numerous panels after a database is closed.
• Revised text on numerous menu items.
• Save tear-off menus setting only if Automatically Save Settings On Exit is active or the settings are explicitly saved.
• This will be the final package release. Future releases will include source only. Good luck!
• Woody tree widgets. Collapse / expand trees.

January 1, 2002.

• BiblioteQ, or XBook, is introduced.