=== WP Data Access – App, Table, Form, Chart & Map Builder plugin ===
Plugin URI: https://wpdataaccess.com/
Contributors: wpdataaccess, peterschulznl, maxxschulz, kimmyx, freemius
Tags: tables, table builder, form builder, data management, charts
Tested up to: 6.8
Requires PHP: 7.0
Stable tag: 5.5.49
License: GPLv2 or later
License URI: http://www.gnu.org/licenses/gpl-2.0.html

A data-driven App Builder with an intuitive Table Builder, a customizable Form Builder, and interactive maps and charts — supporting 35+ languages

== Description ==
WP Data Access features a powerful, data-driven **App Builder** equipped with an intuitive **Table Builder**, a flexible **Form Builder**, and interactive **Map** and **Chart** components. Apps can run on both the **front-end** and **back-end**, with easy-to-manage authorization based on WordPress users and roles. The App Builder supports **35+ languages**, making it easy to localize applications for a global audience.

Designed for advanced users, the **SQL Query Builder** enables you to **schedule SQL queries** to run automatically at defined intervals. Combined with **remote database connectivity**, it allows you to set up **batch jobs** for **automated data exchange** across multiple databases—ideal for syncing and integrating external data sources directly from your WordPress site.

== App Builder ❤️ ==
> A data-driven Rapid Application Development tool featuring **Builders**, **Managers**, and **Wizards** for effortless app creation and **Hooks** for ultimate customization.

* **Table Builder**
  * Many powerful static and dynamic filtering options 🔍
  * Real-time computed fields ➕
  * Live aggregations for instant insights 📈
  * Seamless chart integration 📊
  * JavaScript hooks to customize layout and behavior 🔧
  * A Lookup Wizard to create lookups in a snap 🧙
  * Inline editing for instant updates 📝
  * Export to PDF, CSV, JSON, XML, SQL, and Excel 📄
  * WordPress media library integration 📷🎞
* **Form Builder**
  * Grid-based forms ➕➖
  * Multi-level master-detail relationships 🔄
  * A Lookup Wizard to create lookups in a snap 🧙
  * A Computed Field Wizard to implement custom fields 🧙
  * JavaScript hooks to customize business rules, validations and layout 🔧
  * Interactive client-side validations based on database constraints ✅
  * Access the WordPress media library for enhanced functionality 📷🎞
* **Chart Builder**
  * Google Charts integration 📊
  * Create charts from SQL queries 📑
  * Interactively adjustable charts configuration ✔
  * Print/export charts 🖨📄
* **Map Builder**
  * Google Maps integration 🌎
  * Query-driven location visualizations 📍
  * Interactively adjustable search radius 🔍
  * Customizable marker content and layout 📌
* **Theme Builder**
  * Personalize your app’s appearance with ease 🎨
* **App Manager**
  * Authorization management based on WordPress user and role principles 🔒
  * Make apps available from back-end dashboard menu 🔽
  * Add apps to front-end using shortcodes 🌐
  * Use safe mode to disable hooks temporarily 🔧
* Build dynamic, data-driven apps for both front-end and back-end 📱
* Run apps in 35+ languages to reach a global audience 🌍
* Connect to local and remote databases 🗺
* Real-time build and run capabilities 💻

== SQL Query Builder ==
> **Run and schedule SQL queries** effortlessly from your WordPress dashboard - **powered by tabs and AI**.

* Schedule queries to run automatically at defined intervals 🕝
* AI Assistant to generate queries and fix common errors 🤖
* Tabbed interface for running multiple queries in parallel ▶
* Save and reuse queries - privately or globally 🔄
* Built-in safeguards to protect core WordPress tables and ensure data integrity 🔒
* Visual Query Builder to create complex queries without writing SQL 🎨

== Data Explorer ==
> Take full control of your data with a **GUI-driven interface**.

* Manage local and remote data 🗺
* Perform global search and replace across multiple databases and tables 🔍
* Import SQL and CSV files, with ZIP support for handling large datasets 📄
* Export data in various formats, including SQL, CSV, JSON, and XML 📄
* Rename, copy, truncate, drop, optimize, or alter tables 👤
* Advanced table and column options, such as geolocation, and enhanced search ✔

== Premium Data Services ==
> **Connect, sync, and manage remote databases and data files.**

* Compatible with all plugin features ✅
* Premium Remote Connection Wizard 🧙
  * Remote Databases: Connect to SQL Server, Oracle, PostgreSQL, MariaDB, MySQL, and MS Access (file-based) 💻
  * Remote Data Files: Sync with CSV, JSON, and XML files for dynamic updates (e.g., Google Sheets sync) 📄

== Legacy Tools ==
> Will be replaced by the **App Builder**.

* Available until at least december 2026 🕝
* Use to maintain old solutions 🙏
* Use App Builder for new projects 🚀

== Dashboards and Widgets ==
> Customizable widgets for dashboards (back-end), webpages (front-end), and external websites. (functionality will be moved to App Builder)

* Centralized data management
* Share data widgets anywhere
* Give specific users and user groups access to locked dashboards
* Support for user-created dashboards

== Useful Links ==
- [Plugin Website](https://wpdataaccess.com/)
- [Documentation](https://wpdataaccess.com/documentation/)
- [Visual Query Builder](https://wpdataaccess.com/docs/sql-query-builder/visual-query-builder/)
- [Premium Remote Connection Wizard](https://wpdataaccess.com/docs/remote-connection-wizard/remote-wizard/)

== Installation ==
(1) Upload the WP Data Access plugin to your WordPress site
(2) Activate the plugin
(3) Navigate to the WP Data Access menu

And you're all set! 🚀

== Changelog ==

= 5.5.49 =
* Released 2025-08-16
* Updated: Tooltips icon buttons toolbar
* Fixed: Hyperlinks in data tables not working
* Fixed: Multi level relationships missing builder buttons
* Fixed: Hook postFormSubmit does not fire after insert

= 5.5.48 =
* Released 2025-08-06
* Fixed: Export all rows with client-side processing exports only rows on current page
* Fixed: Show column filters on startup not working
* Fixed: Cursor exits inline editing field on user input
* Fixed: Detail table refreshed on every key press

= 5.5.47 =
* Released 2025-07-28
* Fixed: Column settings added via hooks lost on navigation
* Fixed: Column code variable returns undefined
* Fixed: Conditional lookup does not use arguments
* Fixed: Lookups loaded after (re)configuration
* Fixed: Removed HTML from PDF output

= 5.5.46 =
* Released 2025-07-26
* Fixed: Column filters not loading correctly

= 5.5.45 =
* Released 2025-07-20
* Added: Support for translation enables the modification of localized labels and hints
* Added: New hooks preInsert, postInsert, preUpdate, postUpdate, preDelete, postDelete, onFormOpen and onFormClose
* Added: Custom options and events to Chart Builder
* Added: Support for remote auto increment columns
* Added: Translation for column filters label
* Added: Disable APPLY button in Form Builder
* Added: Parent and row column value usage in dynamic lookup conditions
* Added: Automatically remove dropped columns from apps
* Improved: Loading language files dynamically
* Improved: Chart settings UI and performance
* Improved: Force plugin themes to overwrite generally styled elements by other plugins and themes
* Improved: Behavior of date and time data entry fields
* Improved: Dynamic CSS handling
* Changed: Row selection available through checkbox only
* Fixed: Table query performed twice with server-side processing
* Fixed: Data app hangs if no detail apps are defined
* Fixed: Update succeeds but DBMS reports 0 rows affected (CONNECT engine only)
* Fixed: Delete succeeds but DBMS reports 0 rows affected (CONNECT engine only)
* Fixed: Cannot update row directly after insert
* Fixed: "Add trailing zeros to days and month" should be "Add leading zeros to days and month"
* Fixed: Navigation buttons in form view doesn't show up for views or tables without primary key
* Fixed: Next row navigation button showing first row on previous page
* Fixed: The responseCode in the postFormSubmit hook is returned in lower case
* Fixed: Background color odd-even App Builder
* Fixed: App Builder not exporting map and chart settings
* Fixed: Theme twenty twenty-one styling issues
* Fixed: Data Explorer does not remove dropped columns
* Fixed: App Builder detail hover
* Updated: Freemius SDK

= 5.5.43 =
* Released 2025-06-19
* Added: Unattended scheduled exports to dashboard (+email notification +local files + ftp(s))
* Added: Show validation error message in popup
* Fixed: Refresh button returns partial dataset with client-side processing and search values
* Fixed: App function setInlineEditing has no effect
* Fixed: Some hooks still use numeric mode key instead of mode name
* Fixed: SQL Query Builder missing header with non query commands like "desc table" and "show tables"
* Fixed: Form setting preserveSpacesOnUpdate not working
* Fixed: Cannot delete hook on column with index 0
* Fixed: Cannot update hyperlink from hooks
* Fixed: Loosing tabs on small devices
* Fixed: Tables filtered using row selection export whole table instead of filtered rows only
* Fixed: Elevation not working for charts

= 5.5.42 =
* Released 2025-06-05
* Added: Plugin drives for local file system and ftp(s)
* Added: Run unattended exports to local file system and ftp(s)
* Added: New hook functions:
         app.getUsername(), app.userHasRole(),
         app.setGlobalSearch(), app.setColumnFilters(),
		 app.setInsert(), app.setUpdate(), app.setDelete(),
		 app.setInlineEditing(), app.setBulkActions()
* Added: Server filter to manage app access control
* Added: Delete scheduled plugin events on plugin deactivation
* Improved: Moved all plugin legacy settings to its own submenu
* Improved: SQL query scheduling
* Improved: Use empty label for null values and empty strings
* Fixed: SQL query parameters lost on control save
* Fixed: Left aligned column header too wide
* Fixed: First and last column headers missing border bottom
* Fixed: Column filter icon not immediately removed when column filtering is disabled
* Fixed: Media library not available on insert
* Fixed: SQL operators malformed after sanitization
* Fixed: Column filter mode update does not execute query immediately
* Fixed: Null value not correctly handle with localization
* Fixed: Hook onRowInit not executed on navigation actions in form
* Fixed: Data Explorer search field CSS

= 5.5.41 =
* Released 2025-05-22
* Added: New SQL Query Builder
* Added: MySQL date format editing
* Changed: Default table layout to fixed
* Merged: Row actions and row selection columns
* Fixed: Column too wide with inline HTML
* Fixed: Media not displayed for relation table columns
* Fixed: Norwegian date format incorrect
* Fixed: Decreasing screen width does not resize chart width in full screen mode
* Fixed: User denied Geolocation error not handled correctly
* Fixed: Cannot update record after navigating to different row in form
* Fixed: Enum column loses "Show values in setting when moved
* Fixed: Handle basic HTML markup in table cells
* Fixed: Search panes not sorted
* Fixed: Column filter icon shows for detail tables when no filterable columns are visible
* Fixed: Clickable area on column filter does not include caret
* Fixed: Form does not scroll correctly in full-screen mode
* Fixed: Modal form not handling column filters correctly
* Fixed: Code editor height incorrect in full-screen mode
* Fixed: Rename app database not working
* Fixed: Link to show examples in Default Where shows table SQL instead
* Fixed: REST API - Critical Error on wpda/table/select
* Removed: PREVIOUS | NEXT row buttons from form if table has no primary key
* Removed: WP Data Access from detail page footer
* Updated: Freemius SDK

= 5.5.40 =
* Released 2025-04-18
* Added: Previous and next row buttons to data entry form
* Added: Map integration to Table Builder
* Added: View maps and charts besides each other in header or footer dock
* Added: Spy popup to default where clause
* Added: Slovenian language support
* Added: Parameter support to chart apps
* Added: Parameter support to map apps
* Changed: Media parameters to optional
* Changed: Powered by hidden by default (added tooltip to UI)
* Fixed: Map height incorrect when run from shortcode
* Fixed: Column filter default not working with server-side processing
* Fixed: Chart data columns expecting length
* Fixed: Images not shown correctly on Safari (macOS and iOS)
* Fixed: Incorrect table height on Safari (macOS and iOS)
* Fixed: Numeric and null values not handle correctly in CSV + JSON export

= 5.5.37 =
* Released 2025-04-02
* Added: New app type MAP
* Added: Root property control to setColumnStyle
* Added: Type-checking to reducers and actions
* Added: Support for spatial columns in tables and forms
* Added: Support for multiple custom shortcode parameters
* Improved: Replaced textarea with CodeMirror for SQL editing
* Fixed: Vulnerability shortcode parameter filter field
* Fixed: Chart Builder menu uses old format
* Fixed: Add column data type to all requests
* Fixed: Added null values to Query Builder CSV export
* Fixed: Shortcode arguments not processed
* Fixed: Missing table header border

= 5.5.36 =
* Released 2025-03-17
* Added: Form hooks
* Added: Builtins to table and form hooks
* Added: OK and CANCEL buttons to full-screen code editor
* Added: Allow hiding title bar on web page via shortcode parameter
* Added: Table hook postQuery
* Added: Allow empty value selection from drop-down list (client-side processing only)
* Fixed: Table hook onAppOpen not working
* Fixed: Slovak app language falls back to English
* Fixed: Removed unused buttons from actions menu

= < 5.5.36 =
* See changelog.txt in plugin folder