dbFront v1.2.6.4185

Released: Jun 14, 2023

v1.2.6.4185 での更新項目

機能

  • AdvancedSearch: Extended the length of the search field from 50 to 200.
  • CustomSearch:
    • Added the ability to set constant values and ranges or NULL.
    • Added 'Custom Search' action buttons.
    • Added support for Prompt Fields and optional Range Fields.
    • Added support for Search SQL Expressions.
    • Added the option to Clear, Overwrite or Merge with Advanced Search.
    • Users can now create/edit their own search buttons.
  • Layout: Added 'TableOnly' layout. Currently requires disabling insert.
  • MassUpdate/Delete:
    • Updated to handle search filters based on Filter Buttons.
    • Updated to handle search filters based on Related Views.
  • SystemMonitor: Rebuilt IP based activity monitoring and layout.
  • Table: Added the ability to set 'Sticky' table columns that remain on screen.
  • WebRequest: Added the option to call Stored Procedure to process the results.

不具合の修正

  • Access: Ignore access errors to databases not requested by the current user.
  • AdvancedSearch: Fixed oversized search keywords breaking the layout.
  • Attachments: Automatically handle PDF files migrated from Sharepoint.
  • Buttons: ButtonAccess(visibility) fixed to be more consistent and logical.
  • Buttons: ButtonAccess(visibility) fixed to enable on readonly records.
  • Buttons: Fixed "Overrides Access" to allow override of row-level security.
  • Buttons: Fixed handling of read-only dialog fields where the form was editable.
  • Buttons: Fixes to handling of non-default read-only fields.
  • Buttons: Improved handling of existing changes when a Action Button is pressed.
  • Buttons: Updates to Config UI for WebRequest with Procedure.
  • Caching: Removed Cache trimming since it was causing more issues.
  • ClientErrors: Log client browser type/version.
  • Config: Fixed XML error loading config from cache.
  • Cookies: Compress and encrypt the JSON cookies.
  • Core: Fixed ability to overwrite invalid config.
  • Core: Improved Null handling.
  • Core: Reject field/object names that are only numeric.
  • Core: Upgraded to jQuery 3.6.2 from 3.4.1.
  • CustomSearch: Fixed use of Lookup fields as custom search parameters.
  • CustomView: Fixed the issue with the "My Layout" not saving.
  • ExcelExport: Fixed null handling.
  • ExcelExport: Improved automatic type handling, including images.
  • Focus: Fixes to improve the focus shift to the form on row click.
  • Focus: Updated to set the focus to QuickSearch if no active form.
  • FormCache: Fixed handling of new records on refresh.
  • Help: Added help text to "My Layout" button.
  • Help: Trimmed Informational Fields.
  • Home: Added classes to HTML to allow for better styling.
  • Import: Trim input and lookup values.
  • Layout: Added a CSS class and set default styling to mark My Layout.
  • Licensing: Ensure critical License/Version errors are not hidden for SSO users.
  • Licensing: Fixed handling and reporting of Support Expiry.
  • LogOut: Added a confirmation before logout.
  • LogViewer: Minor layout fixes.
  • NoPK: Fixed delete/update row security on tables without a PK.
  • NoPK: Optional ability to update duplicate records using RowLimit.
  • OpenUrl: Fixed handling of complex URLs that appeared to include parameters.
  • Report: Extended automatic field rename handling to reports.
  • SMTP/WebRequest: Support all system available SSL protocols (e.g. TLS 1.3, +).
  • SQLServer: Fixed handling of new rows when PK is generated type of numeric(x).
  • Table: Any change to the table config now automatically reloads the screen.
  • Table: Updated "No matching row found" to "No single matching row found".
  • TableOnly: Fixed TableOnly layout for child tables.
  • UI: Fixed FireFox error triggered by the updated jQuery libraries.
  • UI: Fixed issues where Form would revert to a New record after update.
  • UI: Improved Refresh Handling for both the Form and Table.
  • UI: Upgraded to jQueryUI 1.13.2 from 1.12.1.
  • URL: When deep-linking dbFront will use the best connection for the user/database/table.