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 +277 -583 5.5.40 → 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.8
5 -Requires PHP: 7.0
6 -Stable tag: 5.5.40
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
@@ -117,513 +131,193 @@
117 131 And you're all set! 🚀
118 132
119 133 == Changelog ==
120 134
121 -= 5.5.40 =
122 -* Released 2025-04-18
123 -* Added: Previous and next row buttons to data entry form
124 -* Added: Map integration to Table Builder
125 -* Added: View maps and charts besides each other in header or footer dock
126 -* Added: Spy popup to default where clause
127 -* Added: Slovenian language support
128 -* Added: Parameter support to chart apps
129 -* Added: Parameter support to map apps
130 -* Changed: Media parameters to optional
131 -* Changed: Powered by hidden by default (added tooltip to UI)
132 -* Fixed: Map height incorrect when run from shortcode
133 -* Fixed: Column filter default not working with server-side processing
134 -* Fixed: Chart data columns expecting length
135 -* Fixed: Images not shown correctly on Safari (macOS and iOS)
136 -* Fixed: Incorrect table height on Safari (macOS and iOS)
137 -* Fixed: Numeric and null values not handle correctly in CSV + JSON export
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
138 145
139 -= 5.5.37 =
140 -* Released 2025-04-02
141 -* Added: New app type MAP
142 -* Added: Root property control to setColumnStyle
143 -* Added: Type-checking to reducers and actions
144 -* Added: Support for spatial columns in tables and forms
145 -* Added: Support for multiple custom shortcode parameters
146 -* Improved: Replaced textarea with CodeMirror for SQL editing
147 -* Fixed: Vulnerability shortcode parameter filter field
148 -* Fixed: Chart Builder menu uses old format
149 -* Fixed: Add column data type to all requests
150 -* Fixed: Added null values to Query Builder CSV export
151 -* Fixed: Shortcode arguments not processed
152 -* Fixed: Missing table header border
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
153 158
154 -= 5.5.36 =
155 -* Released 2025-03-17
156 -* Added: Form hooks
157 -* Added: Builtins to table and form hooks
158 -* Added: OK and CANCEL buttons to full-screen code editor
159 -* Added: Allow hiding title bar on web page via shortcode parameter
160 -* Added: Table hook postQuery
161 -* Added: Allow empty value selection from drop-down list (client-side processing only)
162 -* Fixed: Table hook onAppOpen not working
163 -* Fixed: Slovak app language falls back to English
164 -* Fixed: Removed unused buttons from actions menu
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
165 178
166 -= 5.5.35 =
167 -* Released 2025-02-24
168 -* Added: Key icon to primary key fields
169 -* Improved: Layout hook settings
170 -* Fixed: Allow hiding mandatory fields that have a default value
171 -* Fixed (with limitations): Media library window shows behind modal form window
172 -* Fixed: Changing grid settings requires reload
173 -* Fixed: Table footer not visible in full-screen 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
174 198
175 -= 5.5.34 =
176 -* Released 2025-02-17
177 -* Updated: Documentation links
178 -* Fixed: Charts showing Chart Builder icon for non-admin users
179 -* Fixed: Row export to SQL not working from Data Explorer
180 -* Fixed: Builder icon visibility fails with multiple shortcodes on same page
181 -* Fixed: Start app in fullscreen mode
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
182 215
183 -= 5.5.33 =
184 -* Released 2025-02-06
185 -* Added: Element ID's to improve end-to-end testing
186 -* Added: Autocompletion to column filter
187 -* Improved: Add metadata server side to improve app load time on public pages
188 -* Improved: Skip LOV rest api call with client-side processing
189 -* Improved: State management large table support
190 -* Improved: State management server/client-side processing
191 -* Fixed: Invalid row count after insert and delete with server-side processing
192 -* Fixed: Invalid row count update with search panes and server-side processing
193 -* Fixed: Invalid row count on search with client side processing
194 -* Fixed: Multi-select column filter and search panes not working with client-side processing
195 -* Fixed: Search panes for lookups not working with client-side processing
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
196 222
197 -= 5.5.32 =
198 -* Released 2025-01-27
199 -* Added: Chart configuration to Table Settings
200 -* Added: Chart integration with data table
201 -* Added: Link to online roadmap
202 -* Improved: On open form jump, to form top
203 -* Improved: Hints on copy and export app
204 -* Removed: Hooks, Charts and Theme from Data Explorer menu
205 -* Fixed: Predefined search builder criteria not working
206 -* Fixed: Column Filters shown twice when HEADER selected
207 -* Fixed: Cannot use multiple URL parameters in where clause
208 -* Fixed: Popup height incorrect in Firefox
209 -* Fixed: Column filter update performs server request with client-side processing
210 -* Fixed: Column filter update not seeing empty string with server-side processing
211 -* Fixed: Column sorting performs server request with client-side processing
212 -* Fixed: Pagination update performs server request with client-side processing
213 -* Fixed: Inline-editing in Data Explorer returns Error 400
214 -* Updated: Freemius SDK
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)
215 234
216 -= 5.5.31 =
217 -* Released 2025-01-16
218 -* Added: Allow user to interactively change table column order
219 -* Added: Show | hide table header and footer
220 -* Added: Sticky header and footer
221 -* Added: Limit input size textarea
222 -* Added: Redirect user after registration completed
223 -* Added: Labels and hints to attachment/upload fields
224 -* Added: Open form in modal window
225 -* Added: Aggregation calculation hint text
226 -* Added: Install function wpda_get_wp_user_id() from Data Explorer - Manage Databases
227 -* Fixed: Alignment of several types of input fields
228 -* Fixed: Client-Side processing not working in Data Explorer
229 -* Fixed: Date fields not localized in PDF export
230 -* Fixed: Import detail apps not working with MySQL V8
231 -* Fixed: Undefined rest api action causes Data Explorer crash
232 -* Fixed: Empty theme settings panel shown for relationships
233 -* Fixed: External CSS overwrites fieldset and legend styles
234 -* Fixed: Missing super-admin capabilities
235 -* Fixed: Blocked aria-hidden on an element because its descendant retained focus
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
236 255
237 -= 5.5.30 =
238 -* Released 2025-01-02
239 -* Fixed: PDF export not working with inline editing enabled columns
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
240 268
241 -= 5.5.29 =
242 -* Released 2024-12-31
243 -* Added: Client-Side processing
244 -* Added: Export all rows (client-side processing)
245 -* Added: Duration input element for storing durations up to 99 hours in the MySQL time format
246 -* Added: Hide powered by label in PDF footer
247 -* Fixed: Math function requires two values
248 -* Fixed: Computed field output in PDF
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
249 275
250 -= 5.5.25 =
251 -* Released 2024-12-28
252 -* Fixed: Lookups blank in PDF
253 -* Fixed: Handle local storage exceptions
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
254 281
255 -= 5.5.24 =
256 -* Released 2024-12-24
257 -* Added: New onAppOpen and onAppClose hooks
258 -+ Added: Requery table programmatically
259 -* Improved: PDF export and user interface
260 -* Fixed: Expanded rows not closed on page change
261 -* Fixed: Aggregation decimals
262 -* Fixed: NO_TABLE_OPTIONS is deprecated in MySQL V8
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
263 300
264 -= 5.5.23 =
265 -* Released 2024-12-18
266 -* Added: Enable|disable embedded HTML in text columns
267 -* Added: Customizable height for multi line text fields
268 -* Added: Default user adjustable column filter value
269 -* Fixed: Cannot save legacy tool status with free version
270 -* Fixed: Lovs not unescaping HTML characters
271 -* Fixed: Lookups not unescaping HTML characters
272 -* Fixed: Input font sizing not working
273 -* Fixed: When adding a new row, dropdown fields that set to be non-editable or hidden still appear visible and editable
274 -* Fixed: Date localization UK not working correctly
275 -* Fixed: Selection checkboxes visibility not toggled when fullscreen toggled
276 -* Fixed: Plain text hyperlink not processed correctly
277 -* Fixed: App type search not working when text search is empty
278 -* Fixed: Form not showing if default where contains error
279 -* Fixed: Give a proper console error when table lookup fails
280 -* Fixed: 1:1 relationship issues
281 -* Fixed: Search & replace gives no results for remote databases
282 -* Fixed: Invalid hyperlink format throws error and shows blank screen
283 -* Fixed: Change order direction handling
284 -* Changed: Builder menu structure to accommodate more menu items
285 -* Changed: Math library to reduce bundle size
286 -* Optimized: Client bundle
287 -* Optimized: Store handling
288 -* Optimized: Lazy load language files
289 -* Updated: Freemius SDK
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
290 321
291 -= 5.5.22 =
292 -* Released 2024-11-28
293 -* Added: Table component reference to table hooks
294 -* Added: Parameter pp-page to jump to specific page on page load
295 -* Added: Allow inline editing with row update disabled
296 -* Added: Save button to table header for inline updates
297 -* Added: Hide auto-increment columns during insert if visibility = off
298 -* Fixed: Missing form column code causes fatal error
299 -* Fixed: WPDAVAR and WDPATMP no longer working in SQL Query Builder
300 -* Fixed: Insert fails when primary key contains and auto_increment and additional columns
301 -* Fixed: Global search not working in free version
302 -* Fixed: Less than character not unescaped
303 -* Fixed: Lookup wizard update does not update related tables and columns
304 -* Changed: Freemius SDK integration
305 -* Optimized: Bundles and store
306 -
307 -= 5.5.20 =
308 -* Released 2024-11-15
309 -* Fixed: Apply + OK buttons not working after closing Form Builder
310 -* Fixed: Null value validation not triggered on update
311 -* Fixed: All legacy tools removed from toolbar
312 -
313 -= 5.5.19 =
314 -* Released 2024-11-15
315 -* Added: Enable | Disable legacy tools from tool guide page
316 -* Added: Allow server side default values on insert
317 -* Moved: Dashboards and Charts menu items to legacy tools section
318 -* Fixed: Tool guide header too wide on small devices
319 -* Fixed: Hidden elements using dashboard space
320 -* Fixed: Trailing comma causing error with PHP7
321 -* Fixed: Selector returns different results when called with same arguments
322 -* Fixed: Join Builder and Relation Builder button access
323 -
324 -= 5.5.17 =
325 -* Released 2024-11-07
326 -* Added: Charts to App Builder
327 -* Added: Rename database feature
328 -* Added: Allow computed fields in forms as own element (instead of inside an input element)
329 -* Added: Tip to improve performance on first table load
330 -* Improved: Usability builder column icons
331 -* Fixed: Pagination issue, next button not clickable on second page
332 -* Fixed: Fields with inline editing enabled reflect first row value when second row is filtered
333 -* Fixed: Column header to wide when inline search in header is enabled
334 -* Fixed: Default full screen not defined
335 -* Fixed: Row count issue with large table support
336 -* Fixed: Missing mandatory column does not show error on insert
337 -* Fixed: Passing incorrect form mode
338 -* Fixed: Disable inline editing for parent ID column
339 -* Fixed: Populating M2M list returns unknown column in field list
340 -* Fixed: Insert M2M form using auto increment column
341 -* Fixed: Lookup relation tables returning bad request
342 -* Fixed: Mandatory columns not in forms prevent saving data
343 -* Updated: Freemius SDK
344 -
345 -= 5.5.16 =
346 -* Released 2024-10-16
347 -* Added: Registration form
348 -* Added: Save view selection in App Builder
349 -* Added: Cascading app deletion
350 -* Added: Allow user to show | hide table columns
351 -* Optimized: Hook editor updates to prevent unnecessary re-renders
352 -* Changed: Bulk action column selection showing labels instead of column names
353 -* Fixed: Join and relation table settings not saved correctly
354 -* Fixed: Class names for styles not applied to lookup fields
355 -* Fixed: XML export not processing null values correctly
356 -* Fixed: App copy missing multi-level relationships
357 -* Fixed: App export missing multi-level relationships
358 -* Fixed: App export missing WordPress table prefix
359 -* Fixed: App copy Data App missing detail apps
360 -* Fixed: App export Data App missing detail apps
361 -* Fixed: Responsiveness of data tables also set to scroll for views
362 -* Fixed: Column filter layout when field layout is filled
363 -* Fixed: Default detail panel overflow on mobile devices
364 -* Fixed: Media button labels in Form Builder DELETE and SELECT not translated
365 -* Fixed: Disable column render hook for computed fields
366 -* Fixed: Border radius first line App Builder and Data Explorer incorrect
367 -* Fixed: Color button labels in header
368 -* Fixed: Border radius incorrect App Builder and Data Explorer
369 -* Fixed: Null pointer exception on toLowerCase
370 -* Fixed: Handle references to deleted apps
371 -* Fixed: Cannot open table builder for data explorer
372 -* Fixed: Show more button relation table
373 -* Fixed: Cleanup relation table references on cancel
374 -* Fixed: Column filter processing join and relation table columns
375 -* Fixed: App crashes when filter is changed on detail table
376 -* Fixed: Special characters added to column label end are moved to the front in detail view
377 -* Fixed: Searchbox highlight replicating selected values
378 -* Fixed: Last column disappears when it is invisible and a computed field is added
379 -* Removed: Refresh icon from table table when inline editing is enabled
380 -* Removed: Copy/export data apps (copy only real containers)
381 -* Removed: Redundant free code from premium version (does not affect free version)
382 -* Updated: Opt-in icons
383 -* Updated: Freemius SDK
384 -
385 -= 5.5.14 =
386 -* Released 2024-09-17
387 -* Added: Manage relationships from Table Builder and Form Builder
388 -* Added: Selectable density state to App Builder and Data Explorer
389 -* Added: Force aggregations to use column localization settings
390 -* Added: Start apps in full screen mode
391 -* Fixed: Reapply theme settings to app after switching
392 -* Fixed: App Builder record lists subtract 1 day from date fields
393 -* Fixed: Fatal error when disabling full lookup on startup
394 -* Fixed: Column border missing in table and form builder
395 -* Fixed: Lookup value substitution not working correctly when lookup return just one value
396 -* Fixed: Computed field duplicated when applied multiple times on creation
397 -* Fixed: Menu item not focusable
398 -* Fixed: Row selection checkbox shown above row action icons when scrolling
399 -* Fixed: Hidden columns shown when responsiveness is set to scrollbar
400 -* Changed: Row selection column no longer pinned
401 -* Changed: Show icon buttons on toolbar instead of buttons on small devices
402 -* Changed: App Builder layout
403 -* Updated: Freemius SDK
404 -
405 -== Changelog ==
406 -= 5.5.13 =
407 -* Released 2024-09-08
408 -* Fixed: Events on computed fields lost
409 -* Fixed: Textarea padding
410 -* Fixed: Responsive column hiding
411 -* Fixed: Padding right TH, TD
412 -* Fixed: Table overflow issues
413 -
414 -= 5.5.12 =
415 -* Released 2024-09-05
416 -* Fixed: Relation table not shown when using artificial primary key
417 -* Fixed: Relation table join condition missing table names
418 -* Fixed: Date not localized
419 -* Fixed: Explicitly set background fixed columns
420 -* Fixed: Removed migration message from Data Designer toolbar
421 -* Fixed: Auto complete internal key mismatch
422 -* Fixed: Image size in data table
423 -* Added: Export to PDF icon to detail panel
424 -* Added: Column selection in bulk actions exports
425 -* Added: A number of hooks to customize data table layout and behaviour
426 -* Changed: Detail panel layout
427 -* Changed: App Builder layout
428 -* Changed: Data Explorer layout
429 -
430 -= 5.5.11 =
431 -* Released 2024-08-22
432 -* Fixed: Super admin cannot access sub site
433 -* Fixed: Divi styling issues
434 -* Fixed: Elementor styling issues
435 -* Fixed: Cannot read properties of null (reading 'toLocaleLowerCase')
436 -* Fixed: Full screen data app not showing table correctly
437 -* Fixed: Inline auto save columns not saving properly
438 -* Fixed: Cannot use % character in where clause lookups
439 -* Fixed: Pagination rows per page setting not updated
440 -* Fixed: M:M relationships losing primary key values
441 -* Added: View Data Apps structure in App Builder
442 -* Added: Copy shortcode to App Builder actions
443 -* Added: App actions menu to the App Builder
444 -* Added: Pagination display options: top, bottom, or both
445 -* Added: Support for thousand and decimal separators in numeric input fields
446 -* Added: Enhanced language support for date, time, and numeric fields
447 -* Added: CodeMirror integration for writing computed field implementations
448 -* Added: JavaScript and HTML support to Code Mirror
449 -* Added: Hint to old table and form builders to prevent confusion
450 -* Added: Inline data viewing with a detail panel
451 -* Added: WordPress and plugin table information to the Data Explorer
452 -* Changed: Builder resizing behaviour
453 -* Removed: View row id from data table
454 -* Removed: App foreign key constraints
455 -* Updated: Freemius SDK
456 -
457 -= 5.5.9 =
458 -* Released 2024-07-30
459 -* Fixed: Localization not available for date columns
460 -* Fixed: Increase specificity table style
461 -* Fixed: Form Builder icon always visible for master-detail relationships
462 -* Fixed: Highlighting not working if inline HTML is enabled
463 -* Fixed: React findDOMNode is deprecated in StrictMode
464 -* Fixed: Invalid data type on column filter
465 -* Fixed: Cannot reorder details
466 -* Fixed: Cannot add column filter for hidden columns
467 -* Fixed: Relationship display type updates not detected
468 -* Fixed: App Manager asking for confirmation after shortcode generation
469 -* Fixed: Inline field settings not applied
470 -* Fixed: Undefined table settings on multi level master-detail
471 -* Fixed: App pages on back-end missing CSS styling
472 -* Moved: Changelog to readme (making it available online)
473 -* Added: New app type "app container" to bundle apps into one main app
474 -* Added: Apps to repository backup and restore
475 -* Added: Tool replacement info.
476 -* Added: Premium color gold to plugin menu icon.
477 -* Added: Tool guide page also containing FAQs
478 -* Added: Let import container wait until all databases are loaded
479 -* Added: Added lookup placeholders to computed fields
480 -* Added: Custom shortcode parameter support
481 -* Added: Make computed field label in Form editable from columns list
482 -* Added: Container ID to increase CSS specificity
483 -* Added: Classname pp-fullscreen to body element when entering full screen mode
484 -
485 -= 5.5.7 =
486 -* Released 2024-07-16
487 -* Fixed: Adding a search pane to a column with lookup requires a full table reload
488 -* Fixed: Page scrolls down when keys f, s, t, v pressed in search boxes
489 -* Fixed: Autocomplete not correctly showing for lookup columns with field layout set to filled or standard
490 -* Fixed: Null value in LOV returns an empty list item
491 -* Fixed: Filter mode 'between inclusive' for datetime not working correctly (same results as inclusive)
492 -* Improved: Language files loaded moved to JSON format and loaded at runtime to improve performance
493 -* Improved: Many textual improvements (hints, examples, labels)
494 -* Improved: Uniformized layout and style of all field types and modes
495 -* Improved: Computed field calculations and display
496 -* Added: Several CSS classes for custom styling
497 -* Added: Customize column filters width
498 -* Added: Customize column filters ordering
499 -* Added: Customize default page size
500 -* Added: Customize available page sizes
501 -* Added: Search panes
502 -* Added: Cascading searches for lookups and lovs
503 -* Added: Custom color picker to theme settings
504 -* Added: HTML and JS support to computed fields
505 -* Added: URL parameter support
506 -* Added: Shortcode parameter support
507 -* Added: Ability to disable full screen mode
508 -* Added: Workaround for app preview not loading styles in Divi Visual Builder (showing no preview message instead)
509 -* Updated: Freemius SDK
510 -
511 -= 5.5.6 =
512 -* Released 2024-07-02
513 -* Fixed: Lookup search
514 -* Fixed: User can hide column filter by clicking on filter icon even when hiding is disabled
515 -* Fixed: Filter match highlight
516 -* Added: Shortcode parameter to disable builders on front-end
517 -* Added: Show column filters in table column header
518 -* Added: Lookups missing to export
519 -* Added: Computed fields to export
520 -* Added: Filter match highlight to lookup columns
521 -* Added: Column alignment to PDF export
522 -* Added: PDF orientation and style selection
523 -* Added: Full app localization (containing 35 languages)
524 -* Added: Export apps
525 -* Updated: Freemius SDK
526 -
527 -= 5.5.5 =
528 -* Released 2024-06-20
529 -* Post fix: Copy app not copying details
530 -* Post fix: New record added twice for m:m relationship
531 -* Fixed: Force user to select at least one column on app creation or update
532 -* Fixed: Force user to select at least one column on lookup creation or update
533 -* Fixed: Force user to select at least one column on relationship creation or update
534 -* Fixed: Plugin does not register lookup changes
535 -* Fixed: Empty detail blocks visible on master insert
536 -* Fixed: Wrong (local) date in data table (converted to UTC)
537 -* Fixed: Row selection toggled on inline editing fields
538 -* Fixed: Builder buttons on detail form visible to non admins
539 -* Fixed: Media Library window appears behind the form when triggered
540 -* Changed: Export table or app name instead of app id
541 -* Added: Copy app link and icon
542 -* Added: Bulk actions for views
543 -* Added: M:m relation to App Builder
544 -* Added: Kill token property to chart widget
545 -
546 -= 5.5.4 =
547 -* Released 2024-05-28
548 -* Fixed: Lookup values not shown in exports
549 -* Fixed: Export to pdf adds an empty column
550 -* Fixed: Details not shown to non admin users
551 -* Fixed: View action for tables without primary key and views
552 -* Fixed: Table cell colors incorrect with multiple apps on one page
553 -* Fixed: WordPress media library usage not working on insert
554 -* Fixed: Rename view not working
555 -* Fixed: Drop view not working
556 -* Fixed: Link tooltips in Data Explorer not completely visible
557 -* Fixed: Media type update not working
558 -* Fixed: Server side updates not synced on client
559 -* Fixed: Sending non-updatable fields to server
560 -* Fixed: Column filters empty and not empty not working with lookups
561 -* Fixed: Column positioning not working with full screen master-detail
562 -* Fixed: Reduce margin bottom of error panel in Data Explorer
563 -* Added: Alter table action to new Data Explorer
564 -* Added: Change PDS refresh interval to new Data Explorer
565 -* Added: Manage databases to Data Explorer
566 -* Added: Premium Data Services access to new Data Explorer
567 -* Added: Change font size of input fields, labels and hints
568 -* Added: Monitor updates in App Manager
569 -* Added: Refresh columns button to App Manager
570 -* Added: Adjustable elevation to app containers
571 -* Added: Use WordPress date and time format in tables
572 -* Added: Sync root app theme with detail app theme in real time
573 -* Added: SQL and ZIP file import to Data Explorer
574 -* Added: Bulk actions to Data Explorer
575 -* Added: Elevation to Papers, Cards and App Bars
576 -* Added: Persistent search criteria in Data Explorer and App Builder
577 -
578 -= 5.5.3 =
579 -* Released 2024-05-15
580 -* Improved: Column filter support
581 -* Improved: Several builder hints
582 -* Improved: App responsiveness
583 -* Fixed: Cannot use view in lookups
584 -* Fixed: Master-detail key issue
585 -* Fixed: Database column default constraints not used
586 -* Fixed: Lookups not used in global search
587 -* Fixed: Multi select drop down list not working
588 -* Fixed: Position apps list when opening App Builder
589 -* Fixed: Error on column filter change
590 -* Fixed: Cannot open computed field accordion
591 -* Fixed: Column filter between not working
592 -* Fixed: JSON parse error in Data Explorer
593 -
594 -= 5.5.2 =
595 -* Released 2024-05-08
596 -* Added: Inherited font family from page
597 -* Added: Show more|less button
598 -* Added: Column default value
599 -* Added: Master-detail display type
600 -* Added: Inline HTML support to table cells
601 -* Added: Examples to setting blocks
602 -* Improved: Relationship configuration
603 -* Improved: Lookup configuration
604 -* Fixed: Date/time localization not working
605 -* Fixed: Prefill parent data in child component
606 -* Fixed: Lookup not respecting required constraint
607 -
608 -= 5.5.1 =
609 -* Released 2024-04-19
610 -* Added: 1:1 and 1:n relationships to App Builder
611 -* Fixed: Added client version number to prevent caching old client files
612 -* Fixed: Geomap not working with block-based themes (Ian)
613 -* Updated: Freemius SDK
614 -
615 -= 5.5.0 =
616 -* Released 2024-04-18
617 -* Added: Pre-release new App Builder
618 -* Fixed: URL parameter % usage
619 -
620 -= 5.4.0 =
621 -* Released 2024-01-25
622 -* Added: Pre-release new Data Explorer
623 -* Added: REST API drop-down multi-select inline search
624 -* Added: REST API drop-down inline search
625 -* Changed: REST API inline search and estimated row count
626 -* Updated: Freemius SDK
627 -
628 -= < 5.4.0 =
629 -* See changelog.txt in plugin folder
322 += < 5.5.72 =
323 +* See changelog.txt