PluginProbe
WP Data Access – App Builder for Tables, Forms, Charts, Maps & Dashboards / 5.5.85
WP Data Access – App Builder for Tables, Forms, Charts, Maps & Dashboards v5.5.85
5.5.85 5.5.84 5.5.83 5.5.82 5.5.81 5.5.80 5.5.79 5.5.77 5.5.76 5.5.75 5.5.73 5.5.72 5.5.22 5.5.23 5.5.29 5.5.3 5.5.31 5.5.32 5.5.34 5.5.35 5.5.36 5.5.37 5.5.4 5.5.40 5.5.41 All 161 releases
← All changes | readme.txt +278 -566 5.5.37 → 5.5.85 View file →
@@ -1,114 +1,128 @@
1 -=== WP Data Access – App, Table, Form, Chart & Map Builder plugin ===
2 -Contributors: peterschulznl, maxxschulz, kimmyx, freemius
3 -Tags: table builder plugin, form builder plugin, tables, data management, charts
4 -Tested up to: 6.7
5 -Requires PHP: 7.0
6 -Stable tag: 5.5.37
1 +=== WP Data Access – App Builder for Tables, Forms, Charts, Maps & Dashboards ===
2 +Plugin URI: https://wpdataaccess.com/
3 +Contributors: wpdataaccess, peterschulznl, maxxschulz, kimmyx, freemius
4 +Tags: table builder, data table, datatable, app builder, dashboard
5 +Tested up to: 7.1
6 +Requires PHP: 7.4
7 +Stable tag: 5.5.85
7 8 License: GPLv2 or later
8 9 License URI: http://www.gnu.org/licenses/gpl-2.0.html
9 10
10 -A data-driven App Builder with an intuitive Table Builder, a customizable Form Builder, and interactive maps and charts — available in 35 languages
11 +Turn your data into WordPress apps with tables, forms, charts & maps — no code required, with optional hooks for developers. Supports 35+ languages.
11 12
12 13 == Description ==
13 -A powerful data-driven **App Builder** with an intuitive **Table Builder**, a highly customizable **Form Builder** and **interactive Map and Chart support**. Apps can operate on both the **back-end** and **front-end**, with simple **authorization management based on WordPress user and role principles**. The **App Builder** supports **35 languages** to localize apps.
14 +**WP Data Access** transforms your WordPress site into a platform for building **data-driven applications** — without writing a single line of code.
14 15
15 -== App Builder ==
16 -> A data-driven Rapid Application Development tool featuring **Builders**, **Managers**, and **Wizards** for effortless app creation and **Hooks** for ultimate customization.
16 +With the **intuitive App Builder**, you can create:
17 17
18 -* **Table Builder**
19 - * Many powerful static and dynamic **filtering options**
20 - * **Real-time, updatable computed fields**
21 - * **Real-time aggregations** for up-to-the-minute insights
22 - * **Integrate charts** for robust data analysis
23 - * **JavaScript hooks** to customize layout and behavior
24 - * A **Lookup Wizard** to create lookups in a snap
25 - * Edit data instantly with **inline editing**
26 - * Export to **PDF, CSV, JSON, XML, SQL, and Excel**
27 - * **WordPress media library** integration
28 -* **Form Builder**
29 - * **Grid-based forms** for streamlined data management
30 - * **Multi-level master-detail relationships**
31 - * A **Lookup Wizard** to create lookups in a snap
32 - * A **Computed Field Wizard** to implement **custom fields**
33 - * **JavaScript hooks** to add custom business rules
34 - * **JavaScript hooks** to perform custom validations
35 - * **JavaScript hooks** to customize layout
36 - * Interactive client-side **validations based on database constraints**
37 - * Access the **WordPress media library** for enhanced functionality
38 -* **Chart Builder**
39 - * **Google Charts** integration
40 - * Create **charts** from **SQL queries**
41 - * Interactively adjustable **charts configuration**
42 - * **Print/export charts**
43 -* **Map Builder**
44 - * **Google Maps** integration
45 - * **Visualize location data** using **SQL queries**
46 - * Interactively adjustable **search radius**
47 - * Customizable **marker content and layout**
48 -* **Theme Builder**
49 - * **Customize app layout seamlessly**
50 -* **App Manager**
51 - * **Authorization management based on WordPress user and role principles**
52 - * Make app available from **back-end dashboard menu**
53 - * Add app to **front-end** using shortcodes
54 - * **Safe mode** support (to temporarily disable hooks)
55 -* **Build dynamic, data-driven apps** for both **front-end** and **back-end**
56 -* **Run apps in 35 languages** to reach a global audience
57 -* **Connect to local and remote databases**
58 -* **Real-time build and run capabilities**
18 +* **Interactive Data Tables** – manage and display data with ease
19 +* **Custom Data Forms** – collect and process input seamlessly
20 +* **Charts, Maps & Dashboards** – visualize data beautifully
21 +* **Role-Based Access** – control who can view or manage your data
22 +* **Multilingual Support** – 35+ languages ready to use
59 23
60 -== Data Explorer ==
61 -> Take control of your data with our intuitive, **GUI-driven Data Explorer** that lets you seamlessly **manage both local and remote databases right from your WordPress dashboard**.
24 +WP Data Access is designed as a **true no-code builder**: everything works out of the box, intuitive and effortless. For those who want more, a full set of **developer hooks** makes it possible to fine-tune behavior, extend functionality, or integrate with custom workflows. Hooks are completely optional and invisible to no-code users, but a powerful bonus for developers.
62 25
63 -* Effortlessly **manage data across local and remote databases**
64 -* **Global search and replace** across multiple databases and tables
65 -* [Easily **import SQL and CSV files**, with ZIP support for handling large datasets](https://wpdataaccess.com/docs/data-explorer-manage/imports-sql-csv/)
66 -* [**Export data in various formats**, including SQL, CSV, JSON, and XML—even for large tables](https://wpdataaccess.com/docs/data-explorer-actions/actions/)
67 -* Perform essential **table actions** like rename, copy, truncate, drop, optimize, and alter
68 -* [Unlock **advanced table and column options**, such as geolocation, inline editing, and enhanced search](https://wpdataaccess.com/docs/data-explorer-settings/table-and-view-settings/)
69 -* **Transform data management from complex to effortless with a tool designed for both flexibility and precision**
26 +== App Builder ❤️ ==
27 +> The ultimate **data-driven Rapid Application Development tool**. Build dynamic, interactive apps in minutes with **Builders**, **Managers**, and **Wizards** — all fully customizable with Hooks.
28 +> * Build dynamic, data-driven apps for both front-end and back-end 📱
29 +> * Connect to local and remote databases ⚡
30 +> * Real-time build and run capabilities 💻
31 +> * Run apps in 35+ languages to reach a global audience 🌍
70 32
33 +* **Table Builder** - Create powerful, interactive data tables effortlessly
34 + * Add static and dynamic data table filtering options 🔍
35 + * Real-time computed fields and aggregations for instant insights 📈
36 + * A Lookup Wizard to add lookups to your data table 🧙
37 + * Inline editing for instant updates 📝
38 + * Integrates with the WordPress media library for rich content 📷🎞
39 + * Export data tables to PDF, CSV, JSON, XML, SQL, and Excel 📄
40 + * Add charts and maps to your data table header and footer 📊
41 + * JavaScript hooks to customize data table layout and behavior 🔧
42 +* **Form Builder** - Design forms that adapt to your workflow
43 + * Grid-based layouts for precise control ➕➖
44 + * Master-detail relationships for multi-level data structures 🔄
45 + * Lookup and Computed Field Wizards to add functionality instantly 🧙
46 + * Interactive client-side validations tied to your database constraints ✅
47 + * Full access to the WordPress media library 📷🎞
48 + * JavaScript hooks to customize business rules, validations and layout 🔧
49 +* **Chart Builder** - Transform your data into visual insights
50 + * Google Charts integration 📊
51 + * Create charts from SQL queries 📑
52 + * Interactively adjustable chart configurations ✔
53 + * Print/export charts 🖨📄
54 +* **Map Builder** - Visualize your data geographically
55 + * Google Maps integration for location-based apps 🌎
56 + * Query-driven location visualizations 📍
57 + * Interactively adjustable search radius 🔍
58 + * Customizable marker content and layout 📌
59 +* **Dashboard Builder** - Centralize insights with customizable widgets
60 + * Combine all app types into cohesive dashboards ✅
61 + * Customize dashboard layouts with flexible positioning and sizing ➕➖
62 + * Customizable widgets presenting dynamic and static data
63 + * Mix real-time data with fixed information for comprehensive overviews 📊
64 +* **Theme Builder** - Make your app truly yours
65 + * Personalize your app’s appearance with ease 🎨
66 +* **App Manager** - Control your apps with confidence
67 + * Authorization management based on WordPress user and role principles 🔒
68 + * Add apps to back-end menus or front-end pages via shortcodes 🔽🌐
69 + * Safe mode to temporarily disable hooks without breaking functionality 🔧
70 +
71 +[youtube https://www.youtube.com/watch?v=j0MJvuMG7k8]
72 +
71 73 == SQL Query Builder ==
72 -> **Run SQL queries directly within WordPress.**
74 +> **Run and schedule SQL queries** effortlessly from your WordPress dashboard.
73 75
74 -* [Execute multiple SQL queries with **tabbed workflows** for seamless multitasking](https://wpdataaccess.com/docs/sql-query-builder/query-builder-tutorials/)
75 -* **Save and reuse queries** for data tables and charts
76 -* **Built-in safeguards to protect WordPress tables** and data integrity
77 -* [Ready to optimize? Explore the intuitive **Visual Query Builder** for easy query creation, even without SQL expertise](https://wpdataaccess.com/docs/sql-query-builder/visual-query-builder/)
76 +* Schedule queries to run automatically at defined intervals 🕝
77 +* Run **batch jobs** for **automated data exchange** across multiple databases 🤝
78 +* AI Assistant to generate queries and fix common errors 🤖
79 +* Tabbed interface for running multiple queries in parallel ▶
80 +* Save and reuse queries - privately or globally 🔄
81 +* Built-in safeguards to protect core WordPress tables and ensure data integrity 🔒
82 +* Visual Query Builder to create complex queries without writing SQL 🎨
78 83
79 -== Premium Data Services ==
80 -> **Effortlessly connect, sync, and manage remote databases and data files.**
84 +== Data Explorer ==
85 +> Take full control of your data with a **GUI-driven interface**.
81 86
82 -* **Seamlessly compatible with all plugin features**
83 -* [Premium Remote Connection Wizard for fast, no-fuss setup](https://wpdataaccess.com/docs/remote-connection-wizard/remote-wizard/)
84 - * **Remote Databases**: Connect to SQL Server, Oracle, PostgreSQL, MariaDB, MySQL, and MS Access (file-based)
85 - * **Remote Data Files**: Sync with CSV, JSON, and XML files for dynamic updates (e.g., Google Sheets sync)
87 +* Manage local and remote data 🗺
88 +* Perform global search and replace across multiple databases and tables 🔍
89 +* Import SQL and CSV files, with ZIP support for handling large datasets 📄
90 +* Export data in various formats, including SQL, CSV, JSON, and XML 📄
91 +* Rename, copy, truncate, drop, optimize, or alter tables 👤
92 +* Advanced table and column options, such as geolocation, and enhanced search ✔
86 93
87 -== Plugin Settings ==
88 -> Detailed settings for **managing the user interface and behavior**.
94 +== Premium Data Services ==
95 +> **Connect, sync, and manage remote databases and data files.**
89 96
90 -* Tailor your experience with a wide range of detailed settings to control both the user interface and functionality of the plugin
97 +* Compatible with all plugin features ✅
98 +* Premium Remote Connection Wizard 🧙
99 + * Remote Databases: Connect to SQL Server, Oracle, PostgreSQL, MariaDB, MySQL, and MS Access (file-based) 💻
100 + * Remote Data Files: Sync with CSV, JSON, and XML files for dynamic updates (e.g., Google Sheets sync) 📄
91 101
92 102 == Legacy Tools ==
93 103 > Will be replaced by the **App Builder**.
94 104
95 -* Available until at least december 2026
96 -* Use to maintain old solutions
97 -* Use **App Builder** for new projects
105 +* Featuring
106 + * Data Tables 🔍 - Replace with Data Table app.
107 + * Data Forms ✅ - Replace with Data Management app or Registration Form.
108 + * Maps 🌎 - Replace with Map app.
109 + * Charts 📊 - Replace with Chart app.
110 + * Dashboards 🎛️ - Replace with Dashboard app.
111 +* Use to maintain old solutions 🙏
112 +* Use App Builder for new projects 🚀
113 +* You can continue to use the legacy tools by staying on the latest Version 5.x ([Read more →](https://docs.legacy.wpdataaccess.com/docs/deprecating/))
98 114
99 -== Dashboards and Widgets ==
100 -> Customizable widgets for dashboards (back-end), webpages (front-end), and external websites. **(functionality will be moved to App Builder)**
101 -
102 -* Centralized data management
103 -* Share data widgets anywhere
104 -* Give specific users and user groups access to locked dashboards
105 -* Support for user-created dashboards
106 -* Cost-effective Business Intelligence solution
107 -
108 115 == Useful Links ==
109 116 - [Plugin Website](https://wpdataaccess.com/)
110 -- [Documentation](https://wpdataaccess.com/documentation/)
117 +- [Demos](https://wpdataaccess.com/demos/)
118 +- [Tutorials](https://wpdataaccess.com/tutorials/)
119 +- [App Builder Documentation](https://docs.rad.wpdataaccess.com/)
120 +- [Video Tutorials](https://www.youtube.com/@wpdataaccess)
121 +- [SQL Query Builder Documentation](https://docs.sql.wpdataaccess.com/)
122 +- [Plugin Settings Documentation](https://docs.settings.wpdataaccess.com/)
123 +- [Tool Guide Documentation](https://docs.wpdataaccess.com/)
124 +- [Legacy Documentation](https://docs.legacy.wpdataaccess.com/)
111 125
112 126 == Installation ==
113 127 (1) Upload the WP Data Access plugin to your WordPress site
114 128 (2) Activate the plugin
@@ -113,499 +127,197 @@
113 127 (1) Upload the WP Data Access plugin to your WordPress site
114 128 (2) Activate the plugin
115 129 (3) Navigate to the WP Data Access menu
116 130
117 -And you're all set!
131 +And you're all set! 🚀
118 132
119 133 == Changelog ==
120 134
121 -= 5.5.37 =
122 -* Released 2025-04-02
123 -* Added: New app type MAP
124 -* Added: Root property control to setColumnStyle
125 -* Added: Type-checking to reducers and actions
126 -* Added: Support for spatial columns in tables and forms
127 -* Added: Support for multiple custom shortcode parameters
128 -* Improved: Replaced textarea with CodeMirror for SQL editing
129 -* Fixed: Vulnerability shortcode parameter filter field
130 -* Fixed: Chart Builder menu uses old format
131 -* Fixed: Add column data type to all requests
132 -* Fixed: Added null values to Query Builder CSV export
133 -* Fixed: Shortcode arguments not processed
134 -* Fixed: Missing table header border
135 += 5.5.85 =
136 +* Released 2026-09-23
137 +* Removed unsed code
138 +* Added: Exclude columns from export
139 +* Added: Aggregation translations
140 +* Fixed: Default values not applied to M:M relationships
141 +* Fixed: Enum and set drop-down height
142 +* Fixed: Removed column still available for export
143 +* Fixed: Access parameter validation
144 +* Fixed: Cannot open hooks menu for relation table
135 145
136 -= 5.5.36 =
137 -* Released 2025-03-17
138 -* Added: Form hooks
139 -* Added: Builtins to table and form hooks
140 -* Added: OK and CANCEL buttons to full-screen code editor
141 -* Added: Allow hiding title bar on web page via shortcode parameter
142 -* Added: Table hook postQuery
143 -* Added: Allow empty value selection from drop-down list (client-side processing only)
144 -* Fixed: Table hook onAppOpen not working
145 -* Fixed: Slovak app language falls back to English
146 -* Fixed: Removed unused buttons from actions menu
146 += 5.5.84 =
147 +* Released 2026-09-17
148 +* Restructured table column renderer
149 +* Removed unsed code
150 +* Added: Column pinning to data tables
151 +* Added: Rename database to app menu
152 +* Added: Class name to lookup popup
153 +* Added: Data label to lookup items
154 +* Added: Show hidden columns on tablets and mobiles
155 +* Fixed: setColumnStyle on lookup columns
156 +* Fixed: Map markers not working in Data Table and Data Admin apps
157 +* Fixed: Scheduled tasks deleted on version update
147 158
148 -= 5.5.35 =
149 -* Released 2025-02-24
150 -* Added: Key icon to primary key fields
151 -* Improved: Layout hook settings
152 -* Fixed: Allow hiding mandatory fields that have a default value
153 -* Fixed (with limitations): Media library window shows behind modal form window
154 -* Fixed: Changing grid settings requires reload
155 -* Fixed: Table footer not visible in full-screen mode
159 += 5.5.83 =
160 +* Released 2026-09-09
161 +* Added: Default column name based class names to form fields
162 +* Removed old Query Builder
163 +* Removed import from legacy list table
164 +* Fixed: Query Builder fails rebuilding multiple tabs
165 +* Fixed: WPDAVAR not working in Query Builder
166 +* Fixed: Chart legend position top wrapped
167 +* Fixed: Initial "skip relation table pre-search step" setting not processed correctly
168 +* Fixed: Auto increment column value missing in insert m:m relationship
169 +* Fixed: Custom classes not applied in forms
170 +* Fixed: App not correct exported when regexp is used in a hook
171 +* Fixed: Confirm dialog alignment
172 +* Fixed: Unicode characters not imported correct on app transfer
173 +* Fixed: Lookup value not synchronized on update with client side processing enabled
174 +* Fixed: Cannot zoom in|out in maps
175 +* Fixed: Null values added to unselected columns on insert
176 +* Fixed: CSS Form Editor help link
177 +* Fixed: Shortcode parameter vulnerability in legacy data tables
156 178
157 -= 5.5.34 =
158 -* Released 2025-02-17
159 -* Updated: Documentation links
160 -* Fixed: Charts showing Chart Builder icon for non-admin users
161 -* Fixed: Row export to SQL not working from Data Explorer
162 -* Fixed: Builder icon visibility fails with multiple shortcodes on same page
163 -* Fixed: Start app in fullscreen mode
179 += 5.5.82 =
180 +* Released 2026-08-26
181 +* Added: App context to computed form fields
182 +* Added: Localize WordPress standard date format
183 +* Added: Skip relation table pre-search step
184 +* Changed: Query Builder tab styling
185 +* Fixed: Class name not added to computed field
186 +* Fixed: Disable media action buttons for anonymous users
187 +* Fixed: Media library not launched in fullscreen mode
188 +* Fixed: Removed unused columns from response
189 +* Fixed: Reevaluation of already substituted placeholders
190 +* Fixed: Table settings crash when changing media to secure document
191 +* Fixed: Theme font size does not size table cells
192 +* Fixed: Media columns missing class names
193 +* Fixed: Dynamic lookup over multiple columns not populated in insert mode
194 +* Fixed: Query not scheduled
195 +* Fixed: Numeric columns labels not processed correctly in Query Builder
196 +* Fixed: Numeric columns labels not processed correctly in charts
197 +* Fixed: Inline editing global save not working
164 198
165 -= 5.5.33 =
166 -* Released 2025-02-06
167 -* Added: Element ID's to improve end-to-end testing
168 -* Added: Autocompletion to column filter
169 -* Improved: Add metadata server side to improve app load time on public pages
170 -* Improved: Skip LOV rest api call with client-side processing
171 -* Improved: State management large table support
172 -* Improved: State management server/client-side processing
173 -* Fixed: Invalid row count after insert and delete with server-side processing
174 -* Fixed: Invalid row count update with search panes and server-side processing
175 -* Fixed: Invalid row count on search with client side processing
176 -* Fixed: Multi-select column filter and search panes not working with client-side processing
177 -* Fixed: Search panes for lookups not working with client-side processing
199 += 5.5.81 =
200 +* Released 2026-08-18
201 +* Removed old Data Explorer
202 +* Changed global search & replace
203 +* Changed tool guide page
204 +* Added: Secure document storage
205 +* Added: Form separators with title feature
206 +* Added: CSS Form Editor
207 +* Added: Data Explorer documentation
208 +* Fixed: Allow admins only to configure lookups
209 +* Fixed: Check authorization for wildcard exports
210 +* Fixed: Database administration page shows invalid database list
211 +* Fixed: Missing scale in hint
212 +* Fixed: Reevaluation of already substituted placeholders
213 +* Fixed: Cannot add new table design
214 +* Fixed: Scheduled query not correctly returning rows affected
178 215
179 -= 5.5.32 =
180 -* Released 2025-01-27
181 -* Added: Chart configuration to Table Settings
182 -* Added: Chart integration with data table
183 -* Added: Link to online roadmap
184 -* Improved: On open form jump, to form top
185 -* Improved: Hints on copy and export app
186 -* Removed: Hooks, Charts and Theme from Data Explorer menu
187 -* Fixed: Predefined search builder criteria not working
188 -* Fixed: Column Filters shown twice when HEADER selected
189 -* Fixed: Cannot use multiple URL parameters in where clause
190 -* Fixed: Popup height incorrect in Firefox
191 -* Fixed: Column filter update performs server request with client-side processing
192 -* Fixed: Column filter update not seeing empty string with server-side processing
193 -* Fixed: Column sorting performs server request with client-side processing
194 -* Fixed: Pagination update performs server request with client-side processing
195 -* Fixed: Inline-editing in Data Explorer returns Error 400
196 -* Updated: Freemius SDK
216 += 5.5.80 =
217 +* Released 2026-08-06
218 +* Added: Progressive web apps
219 +* Fixed: Escaped titles and links in table output and shortcode
220 +* Fixed: Hide inline editing feature when update is not allowed
221 +* Fixed: Table incorrectly styled after abandoning card view
197 222
198 -= 5.5.31 =
199 -* Released 2025-01-16
200 -* Added: Allow user to interactively change table column order
201 -* Added: Show | hide table header and footer
202 -* Added: Sticky header and footer
203 -* Added: Limit input size textarea
204 -* Added: Redirect user after registration completed
205 -* Added: Labels and hints to attachment/upload fields
206 -* Added: Open form in modal window
207 -* Added: Aggregation calculation hint text
208 -* Added: Install function wpda_get_wp_user_id() from Data Explorer - Manage Databases
209 -* Fixed: Alignment of several types of input fields
210 -* Fixed: Client-Side processing not working in Data Explorer
211 -* Fixed: Date fields not localized in PDF export
212 -* Fixed: Import detail apps not working with MySQL V8
213 -* Fixed: Undefined rest api action causes Data Explorer crash
214 -* Fixed: Empty theme settings panel shown for relationships
215 -* Fixed: External CSS overwrites fieldset and legend styles
216 -* Fixed: Missing super-admin capabilities
217 -* Fixed: Blocked aria-hidden on an element because its descendant retained focus
223 += 5.5.79 =
224 +* Released 2026-07-29
225 +* Added: Legacy tools message (widget and notice)
226 +* Added: Network errors to app messages for improved troubleshooting
227 +* Fixed: Cannot disable global filter for columns with client-side processing
228 +* Fixed: Client-side cascading column filter count
229 +* Fixed: Styling issues with column filter popup
230 +* Fixed: Client-side drop-down column filters not showing alternative values
231 +* Fixed: Clicking the create table design icon returns unauthorized
232 +* Fixed: Button style overwritten by theme CSS
233 +* Extended nonce action (Farid)
218 234
219 -= 5.5.30 =
220 -* Released 2025-01-02
221 -* Fixed: PDF export not working with inline editing enabled columns
235 += 5.5.77 =
236 +* Released 2026-07-17
237 +* Added: Gutenberg block support for [wpda_app] shortcode
238 +* Added: Display multiple cards per row
239 +* Added: Missing parameters for shortcode generation
240 +* Added: Check for unsaved changes in Visual Query Builder on close
241 +* Changed: Inline editing now requires update enabled (use option "hide edit icon")
242 +* Changed: Cascading column filter behavior
243 +* Fixed: Cascading column filters with client-side processing
244 +* Fixed: CSV import button icons alignment
245 +* Fixed: Lazy loaded lookups not rerendering when open
246 +* Fixed: Visual Query conversion
247 +* Fixed: Visual Query Builder column row layout
248 +* Fixed: Visual Query Builder alias not editable
249 +* Fixed: Visual Query Builder missing plus icon button
250 +* CSS Table Editor now available to free users
251 +* Added css class pp-table-detail-panel-container to detail panel
252 +* Code review
253 +* Extended nonce action
254 +* Updated freemius SDK
222 255
223 -= 5.5.29 =
224 -* Released 2024-12-31
225 -* Added: Client-Side processing
226 -* Added: Export all rows (client-side processing)
227 -* Added: Duration input element for storing durations up to 99 hours in the MySQL time format
228 -* Added: Hide powered by label in PDF footer
229 -* Fixed: Math function requires two values
230 -* Fixed: Computed field output in PDF
256 += 5.5.76 =
257 +* Released 2026-07-07
258 +* Added: Extended pagination button support for all data tables
259 +* Fixed: Column filter popup should only count rows with client-side processing enabled
260 +* Fixed: Update fails after navigating to other row for 1:1 relationships
261 +* Fixed: Last pagination button missing
262 +* Fixed: Search list not updated
263 +* Fixed: Cross-Site Scripting (XSS) vulnerability - patchstack
264 +* Fixed: Function setColumnStyle has no effect on first column
265 +* Fixed: Cascade drop-down lists not taking global filter into account with client-side processing enabled
266 +* Fixed: Cannot position column filters above
267 +* Updated freemius SDK
231 268
232 -= 5.5.25 =
233 -* Released 2024-12-28
234 -* Fixed: Lookups blank in PDF
235 -* Fixed: Handle local storage exceptions
269 += 5.5.75 =
270 +* Released 2026-06-25
271 +* Added: New Visual Query Builder
272 +* Added: Column filters popup positioning
273 +* Added: Class names to action buttons
274 +* Updated freemius SDK
236 275
237 -= 5.5.24 =
238 -* Released 2024-12-24
239 -* Added: New onAppOpen and onAppClose hooks
240 -+ Added: Requery table programmatically
241 -* Improved: PDF export and user interface
242 -* Fixed: Expanded rows not closed on page change
243 -* Fixed: Aggregation decimals
244 -* Fixed: NO_TABLE_OPTIONS is deprecated in MySQL V8
276 += 5.5.74 =
277 +* Released 2026-05-21
278 +* Fixed: Expand column filters on startup not available for POPUPs
279 +* Fixed: Must manually enable "show column filters in compact mode" for POPUPs
280 +* Fixed: Border between column filters on left to fat
245 281
246 -= 5.5.23 =
247 -* Released 2024-12-18
248 -* Added: Enable|disable embedded HTML in text columns
249 -* Added: Customizable height for multi line text fields
250 -* Added: Default user adjustable column filter value
251 -* Fixed: Cannot save legacy tool status with free version
252 -* Fixed: Lovs not unescaping HTML characters
253 -* Fixed: Lookups not unescaping HTML characters
254 -* Fixed: Input font sizing not working
255 -* Fixed: When adding a new row, dropdown fields that set to be non-editable or hidden still appear visible and editable
256 -* Fixed: Date localization UK not working correctly
257 -* Fixed: Selection checkboxes visibility not toggled when fullscreen toggled
258 -* Fixed: Plain text hyperlink not processed correctly
259 -* Fixed: App type search not working when text search is empty
260 -* Fixed: Form not showing if default where contains error
261 -* Fixed: Give a proper console error when table lookup fails
262 -* Fixed: 1:1 relationship issues
263 -* Fixed: Search & replace gives no results for remote databases
264 -* Fixed: Invalid hyperlink format throws error and shows blank screen
265 -* Fixed: Change order direction handling
266 -* Changed: Builder menu structure to accommodate more menu items
267 -* Changed: Math library to reduce bundle size
268 -* Optimized: Client bundle
269 -* Optimized: Store handling
270 -* Optimized: Lazy load language files
271 -* Updated: Freemius SDK
282 += 5.5.73 =
283 +* Released 2026-05-19
284 +* Added: Feedback to compact column filter buttons
285 +* Added: Show column filters in popup
286 +* Added: Single-select search panes
287 +* Added: Selectable plus|min icons for numeric fields
288 +* Added: Disable plus|min icons for numeric fields
289 +* Improved column filters UI
290 +* Improved bulk actions UI
291 +* Optimized column filter handling
292 +* Fixed: Cannot start table with docked chart in fullscreen mode
293 +* Fixed: Search fields containing two clear icon buttons
294 +* Fixed: Highlighting fails for wildcards
295 +* Fixed: Dynamic conditions not available after lookup update
296 +* Fixed: Default column search fails if URL parameter does not exist
297 +* Fixed: Dynamic lookup fails with unequal column names
298 +* Fixed: Column filters not consistently working with async lookups
299 +* Fixed: Cascading search for search boxes
272 300
273 -= 5.5.22 =
274 -* Released 2024-11-28
275 -* Added: Table component reference to table hooks
276 -* Added: Parameter pp-page to jump to specific page on page load
277 -* Added: Allow inline editing with row update disabled
278 -* Added: Save button to table header for inline updates
279 -* Added: Hide auto-increment columns during insert if visibility = off
280 -* Fixed: Missing form column code causes fatal error
281 -* Fixed: WPDAVAR and WDPATMP no longer working in SQL Query Builder
282 -* Fixed: Insert fails when primary key contains and auto_increment and additional columns
283 -* Fixed: Global search not working in free version
284 -* Fixed: Less than character not unescaped
285 -* Fixed: Lookup wizard update does not update related tables and columns
286 -* Changed: Freemius SDK integration
287 -* Optimized: Bundles and store
301 += 5.5.72 =
302 +* Released 2026-05-04
303 +* Added: Clear all column filters button to compact vertically placed column filters container
304 +* Added: Automatically open column filter list when user opens a column filter in compact mode
305 +* Added: Multiple calculation types to table chart
306 +* Added: Start app on back-end in fullscreen mode
307 +* Added: Default column filter via URL parameter
308 +* Added: Plus and minus buttons to numeric input fields
309 +* Added: Subtitles to row actions
310 +* Added: Rename translation
311 +* Fixed: Column filters interfering on tabs
312 +* Fixed: Actions column too wide when bulk actions enabled and row actions disabled
313 +* Fixed: Removed disabled fields from chart popup (free version only)
314 +* Fixed: Resize chart when popup is resized (free version only)
315 +* Fixed: Match map and chart popup UIs (free version only)
316 +* Fixed: Chart returns an error when no data found
317 +* Fixed: Rows not exporting the correct rows when selected with Bulk Select after filtering
318 +* Fixed: Table not sorted correctly on lookup column when server-side processing is enabled
319 +* Fixed: Removed "number of decimals displayed" if field has no decimals
320 +* Fixed: Scheduled queries don't send out attachments if queries are written in uppercase
288 321
289 -= 5.5.20 =
290 -* Released 2024-11-15
291 -* Fixed: Apply + OK buttons not working after closing Form Builder
292 -* Fixed: Null value validation not triggered on update
293 -* Fixed: All legacy tools removed from toolbar
294 -
295 -= 5.5.19 =
296 -* Released 2024-11-15
297 -* Added: Enable | Disable legacy tools from tool guide page
298 -* Added: Allow server side default values on insert
299 -* Moved: Dashboards and Charts menu items to legacy tools section
300 -* Fixed: Tool guide header too wide on small devices
301 -* Fixed: Hidden elements using dashboard space
302 -* Fixed: Trailing comma causing error with PHP7
303 -* Fixed: Selector returns different results when called with same arguments
304 -* Fixed: Join Builder and Relation Builder button access
305 -
306 -= 5.5.17 =
307 -* Released 2024-11-07
308 -* Added: Charts to App Builder
309 -* Added: Rename database feature
310 -* Added: Allow computed fields in forms as own element (instead of inside an input element)
311 -* Added: Tip to improve performance on first table load
312 -* Improved: Usability builder column icons
313 -* Fixed: Pagination issue, next button not clickable on second page
314 -* Fixed: Fields with inline editing enabled reflect first row value when second row is filtered
315 -* Fixed: Column header to wide when inline search in header is enabled
316 -* Fixed: Default full screen not defined
317 -* Fixed: Row count issue with large table support
318 -* Fixed: Missing mandatory column does not show error on insert
319 -* Fixed: Passing incorrect form mode
320 -* Fixed: Disable inline editing for parent ID column
321 -* Fixed: Populating M2M list returns unknown column in field list
322 -* Fixed: Insert M2M form using auto increment column
323 -* Fixed: Lookup relation tables returning bad request
324 -* Fixed: Mandatory columns not in forms prevent saving data
325 -* Updated: Freemius SDK
326 -
327 -= 5.5.16 =
328 -* Released 2024-10-16
329 -* Added: Registration form
330 -* Added: Save view selection in App Builder
331 -* Added: Cascading app deletion
332 -* Added: Allow user to show | hide table columns
333 -* Optimized: Hook editor updates to prevent unnecessary re-renders
334 -* Changed: Bulk action column selection showing labels instead of column names
335 -* Fixed: Join and relation table settings not saved correctly
336 -* Fixed: Class names for styles not applied to lookup fields
337 -* Fixed: XML export not processing null values correctly
338 -* Fixed: App copy missing multi-level relationships
339 -* Fixed: App export missing multi-level relationships
340 -* Fixed: App export missing WordPress table prefix
341 -* Fixed: App copy Data App missing detail apps
342 -* Fixed: App export Data App missing detail apps
343 -* Fixed: Responsiveness of data tables also set to scroll for views
344 -* Fixed: Column filter layout when field layout is filled
345 -* Fixed: Default detail panel overflow on mobile devices
346 -* Fixed: Media button labels in Form Builder DELETE and SELECT not translated
347 -* Fixed: Disable column render hook for computed fields
348 -* Fixed: Border radius first line App Builder and Data Explorer incorrect
349 -* Fixed: Color button labels in header
350 -* Fixed: Border radius incorrect App Builder and Data Explorer
351 -* Fixed: Null pointer exception on toLowerCase
352 -* Fixed: Handle references to deleted apps
353 -* Fixed: Cannot open table builder for data explorer
354 -* Fixed: Show more button relation table
355 -* Fixed: Cleanup relation table references on cancel
356 -* Fixed: Column filter processing join and relation table columns
357 -* Fixed: App crashes when filter is changed on detail table
358 -* Fixed: Special characters added to column label end are moved to the front in detail view
359 -* Fixed: Searchbox highlight replicating selected values
360 -* Fixed: Last column disappears when it is invisible and a computed field is added
361 -* Removed: Refresh icon from table table when inline editing is enabled
362 -* Removed: Copy/export data apps (copy only real containers)
363 -* Removed: Redundant free code from premium version (does not affect free version)
364 -* Updated: Opt-in icons
365 -* Updated: Freemius SDK
366 -
367 -= 5.5.14 =
368 -* Released 2024-09-17
369 -* Added: Manage relationships from Table Builder and Form Builder
370 -* Added: Selectable density state to App Builder and Data Explorer
371 -* Added: Force aggregations to use column localization settings
372 -* Added: Start apps in full screen mode
373 -* Fixed: Reapply theme settings to app after switching
374 -* Fixed: App Builder record lists subtract 1 day from date fields
375 -* Fixed: Fatal error when disabling full lookup on startup
376 -* Fixed: Column border missing in table and form builder
377 -* Fixed: Lookup value substitution not working correctly when lookup return just one value
378 -* Fixed: Computed field duplicated when applied multiple times on creation
379 -* Fixed: Menu item not focusable
380 -* Fixed: Row selection checkbox shown above row action icons when scrolling
381 -* Fixed: Hidden columns shown when responsiveness is set to scrollbar
382 -* Changed: Row selection column no longer pinned
383 -* Changed: Show icon buttons on toolbar instead of buttons on small devices
384 -* Changed: App Builder layout
385 -* Updated: Freemius SDK
386 -
387 -== Changelog ==
388 -= 5.5.13 =
389 -* Released 2024-09-08
390 -* Fixed: Events on computed fields lost
391 -* Fixed: Textarea padding
392 -* Fixed: Responsive column hiding
393 -* Fixed: Padding right TH, TD
394 -* Fixed: Table overflow issues
395 -
396 -= 5.5.12 =
397 -* Released 2024-09-05
398 -* Fixed: Relation table not shown when using artificial primary key
399 -* Fixed: Relation table join condition missing table names
400 -* Fixed: Date not localized
401 -* Fixed: Explicitly set background fixed columns
402 -* Fixed: Removed migration message from Data Designer toolbar
403 -* Fixed: Auto complete internal key mismatch
404 -* Fixed: Image size in data table
405 -* Added: Export to PDF icon to detail panel
406 -* Added: Column selection in bulk actions exports
407 -* Added: A number of hooks to customize data table layout and behaviour
408 -* Changed: Detail panel layout
409 -* Changed: App Builder layout
410 -* Changed: Data Explorer layout
411 -
412 -= 5.5.11 =
413 -* Released 2024-08-22
414 -* Fixed: Super admin cannot access sub site
415 -* Fixed: Divi styling issues
416 -* Fixed: Elementor styling issues
417 -* Fixed: Cannot read properties of null (reading 'toLocaleLowerCase')
418 -* Fixed: Full screen data app not showing table correctly
419 -* Fixed: Inline auto save columns not saving properly
420 -* Fixed: Cannot use % character in where clause lookups
421 -* Fixed: Pagination rows per page setting not updated
422 -* Fixed: M:M relationships losing primary key values
423 -* Added: View Data Apps structure in App Builder
424 -* Added: Copy shortcode to App Builder actions
425 -* Added: App actions menu to the App Builder
426 -* Added: Pagination display options: top, bottom, or both
427 -* Added: Support for thousand and decimal separators in numeric input fields
428 -* Added: Enhanced language support for date, time, and numeric fields
429 -* Added: CodeMirror integration for writing computed field implementations
430 -* Added: JavaScript and HTML support to Code Mirror
431 -* Added: Hint to old table and form builders to prevent confusion
432 -* Added: Inline data viewing with a detail panel
433 -* Added: WordPress and plugin table information to the Data Explorer
434 -* Changed: Builder resizing behaviour
435 -* Removed: View row id from data table
436 -* Removed: App foreign key constraints
437 -* Updated: Freemius SDK
438 -
439 -= 5.5.9 =
440 -* Released 2024-07-30
441 -* Fixed: Localization not available for date columns
442 -* Fixed: Increase specificity table style
443 -* Fixed: Form Builder icon always visible for master-detail relationships
444 -* Fixed: Highlighting not working if inline HTML is enabled
445 -* Fixed: React findDOMNode is deprecated in StrictMode
446 -* Fixed: Invalid data type on column filter
447 -* Fixed: Cannot reorder details
448 -* Fixed: Cannot add column filter for hidden columns
449 -* Fixed: Relationship display type updates not detected
450 -* Fixed: App Manager asking for confirmation after shortcode generation
451 -* Fixed: Inline field settings not applied
452 -* Fixed: Undefined table settings on multi level master-detail
453 -* Fixed: App pages on back-end missing CSS styling
454 -* Moved: Changelog to readme (making it available online)
455 -* Added: New app type "app container" to bundle apps into one main app
456 -* Added: Apps to repository backup and restore
457 -* Added: Tool replacement info.
458 -* Added: Premium color gold to plugin menu icon.
459 -* Added: Tool guide page also containing FAQs
460 -* Added: Let import container wait until all databases are loaded
461 -* Added: Added lookup placeholders to computed fields
462 -* Added: Custom shortcode parameter support
463 -* Added: Make computed field label in Form editable from columns list
464 -* Added: Container ID to increase CSS specificity
465 -* Added: Classname pp-fullscreen to body element when entering full screen mode
466 -
467 -= 5.5.7 =
468 -* Released 2024-07-16
469 -* Fixed: Adding a search pane to a column with lookup requires a full table reload
470 -* Fixed: Page scrolls down when keys f, s, t, v pressed in search boxes
471 -* Fixed: Autocomplete not correctly showing for lookup columns with field layout set to filled or standard
472 -* Fixed: Null value in LOV returns an empty list item
473 -* Fixed: Filter mode 'between inclusive' for datetime not working correctly (same results as inclusive)
474 -* Improved: Language files loaded moved to JSON format and loaded at runtime to improve performance
475 -* Improved: Many textual improvements (hints, examples, labels)
476 -* Improved: Uniformized layout and style of all field types and modes
477 -* Improved: Computed field calculations and display
478 -* Added: Several CSS classes for custom styling
479 -* Added: Customize column filters width
480 -* Added: Customize column filters ordering
481 -* Added: Customize default page size
482 -* Added: Customize available page sizes
483 -* Added: Search panes
484 -* Added: Cascading searches for lookups and lovs
485 -* Added: Custom color picker to theme settings
486 -* Added: HTML and JS support to computed fields
487 -* Added: URL parameter support
488 -* Added: Shortcode parameter support
489 -* Added: Ability to disable full screen mode
490 -* Added: Workaround for app preview not loading styles in Divi Visual Builder (showing no preview message instead)
491 -* Updated: Freemius SDK
492 -
493 -= 5.5.6 =
494 -* Released 2024-07-02
495 -* Fixed: Lookup search
496 -* Fixed: User can hide column filter by clicking on filter icon even when hiding is disabled
497 -* Fixed: Filter match highlight
498 -* Added: Shortcode parameter to disable builders on front-end
499 -* Added: Show column filters in table column header
500 -* Added: Lookups missing to export
501 -* Added: Computed fields to export
502 -* Added: Filter match highlight to lookup columns
503 -* Added: Column alignment to PDF export
504 -* Added: PDF orientation and style selection
505 -* Added: Full app localization (containing 35 languages)
506 -* Added: Export apps
507 -* Updated: Freemius SDK
508 -
509 -= 5.5.5 =
510 -* Released 2024-06-20
511 -* Post fix: Copy app not copying details
512 -* Post fix: New record added twice for m:m relationship
513 -* Fixed: Force user to select at least one column on app creation or update
514 -* Fixed: Force user to select at least one column on lookup creation or update
515 -* Fixed: Force user to select at least one column on relationship creation or update
516 -* Fixed: Plugin does not register lookup changes
517 -* Fixed: Empty detail blocks visible on master insert
518 -* Fixed: Wrong (local) date in data table (converted to UTC)
519 -* Fixed: Row selection toggled on inline editing fields
520 -* Fixed: Builder buttons on detail form visible to non admins
521 -* Fixed: Media Library window appears behind the form when triggered
522 -* Changed: Export table or app name instead of app id
523 -* Added: Copy app link and icon
524 -* Added: Bulk actions for views
525 -* Added: M:m relation to App Builder
526 -* Added: Kill token property to chart widget
527 -
528 -= 5.5.4 =
529 -* Released 2024-05-28
530 -* Fixed: Lookup values not shown in exports
531 -* Fixed: Export to pdf adds an empty column
532 -* Fixed: Details not shown to non admin users
533 -* Fixed: View action for tables without primary key and views
534 -* Fixed: Table cell colors incorrect with multiple apps on one page
535 -* Fixed: WordPress media library usage not working on insert
536 -* Fixed: Rename view not working
537 -* Fixed: Drop view not working
538 -* Fixed: Link tooltips in Data Explorer not completely visible
539 -* Fixed: Media type update not working
540 -* Fixed: Server side updates not synced on client
541 -* Fixed: Sending non-updatable fields to server
542 -* Fixed: Column filters empty and not empty not working with lookups
543 -* Fixed: Column positioning not working with full screen master-detail
544 -* Fixed: Reduce margin bottom of error panel in Data Explorer
545 -* Added: Alter table action to new Data Explorer
546 -* Added: Change PDS refresh interval to new Data Explorer
547 -* Added: Manage databases to Data Explorer
548 -* Added: Premium Data Services access to new Data Explorer
549 -* Added: Change font size of input fields, labels and hints
550 -* Added: Monitor updates in App Manager
551 -* Added: Refresh columns button to App Manager
552 -* Added: Adjustable elevation to app containers
553 -* Added: Use WordPress date and time format in tables
554 -* Added: Sync root app theme with detail app theme in real time
555 -* Added: SQL and ZIP file import to Data Explorer
556 -* Added: Bulk actions to Data Explorer
557 -* Added: Elevation to Papers, Cards and App Bars
558 -* Added: Persistent search criteria in Data Explorer and App Builder
559 -
560 -= 5.5.3 =
561 -* Released 2024-05-15
562 -* Improved: Column filter support
563 -* Improved: Several builder hints
564 -* Improved: App responsiveness
565 -* Fixed: Cannot use view in lookups
566 -* Fixed: Master-detail key issue
567 -* Fixed: Database column default constraints not used
568 -* Fixed: Lookups not used in global search
569 -* Fixed: Multi select drop down list not working
570 -* Fixed: Position apps list when opening App Builder
571 -* Fixed: Error on column filter change
572 -* Fixed: Cannot open computed field accordion
573 -* Fixed: Column filter between not working
574 -* Fixed: JSON parse error in Data Explorer
575 -
576 -= 5.5.2 =
577 -* Released 2024-05-08
578 -* Added: Inherited font family from page
579 -* Added: Show more|less button
580 -* Added: Column default value
581 -* Added: Master-detail display type
582 -* Added: Inline HTML support to table cells
583 -* Added: Examples to setting blocks
584 -* Improved: Relationship configuration
585 -* Improved: Lookup configuration
586 -* Fixed: Date/time localization not working
587 -* Fixed: Prefill parent data in child component
588 -* Fixed: Lookup not respecting required constraint
589 -
590 -= 5.5.1 =
591 -* Released 2024-04-19
592 -* Added: 1:1 and 1:n relationships to App Builder
593 -* Fixed: Added client version number to prevent caching old client files
594 -* Fixed: Geomap not working with block-based themes (Ian)
595 -* Updated: Freemius SDK
596 -
597 -= 5.5.0 =
598 -* Released 2024-04-18
599 -* Added: Pre-release new App Builder
600 -* Fixed: URL parameter % usage
601 -
602 -= 5.4.0 =
603 -* Released 2024-01-25
604 -* Added: Pre-release new Data Explorer
605 -* Added: REST API drop-down multi-select inline search
606 -* Added: REST API drop-down inline search
607 -* Changed: REST API inline search and estimated row count
608 -* Updated: Freemius SDK
609 -
610 -= < 5.4.0 =
611 -* See changelog.txt in plugin folder
322 += < 5.5.72 =
323 +* See changelog.txt