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 +279 -528 5.5.35 → 5.5.85 View file →
@@ -1,102 +1,128 @@
1 -=== WP Data Access – App, Table, Form and Chart 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.35
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 powerful data-driven App Builder with an intuitive Table Builder, a highly customizable Form Builder and interactive chart support 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 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 your 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 -> Unlock the simplicity of building powerful apps with our **App Wizard**. Customize effortlessly with our suite of **Builders**, **Managers**, and **Wizards** for complete control.
16 +With the **intuitive App Builder**, you can create:
17 17
18 -* **Build dynamic, data-driven apps** for both front-end and back-end
19 -* **Run apps in 35 languages** to reach a global audience
20 -* **Create fully customizable data tables** for precise data display with the **Table Builder**
21 -* **Design grid-based forms** for streamlined data management with the **Form Builder**
22 -* **Add multi-level master-detail relationships** effortlessly with the **Relationship Wizard**
23 -* **Edit data instantly with inline editing**
24 -* **Create lookups in a snap** with the **Lookup Wizard**
25 -* **Implement real-time, updatable computed fields** with the **Computed Field Wizard**
26 -* **Enable real-time aggregations** for up-to-the-minute insights
27 -* **Customize apps seamlessly** with theme support with the **Theme Builder**
28 -* **Powerful filtering options** on global and column levels
29 -* **Integrate charts** for robust data analysis
30 -* **Add custom JavaScript hooks for advanced customization**
31 -* **Manage roles and permissions** with WordPress-based user authorization
32 -* **Access the WordPress media library** for enhanced functionality
33 -* **Export to PDF, CSV, JSON, XML, SQL, and Excel**
34 -* **Real-time build and run capabilities**
35 -* **Optimized for large tables**
36 -* **Connect to local and remote databases** through a visual interface
37 -* **Execute SQL queries directly** from the WordPress dashboard
38 -* **Enjoy a fully responsive design** for any device
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
39 23
40 -== Data Explorer ==
41 -> 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.
42 25
43 -* Effortlessly **manage data across local and remote databases**
44 -* **Global search and replace** across multiple databases and tables
45 -* [Easily **import SQL and CSV files**, with ZIP support for handling large datasets](https://wpdataaccess.com/docs/data-explorer-manage/imports-sql-csv/)
46 -* [**Export data in various formats**, including SQL, CSV, JSON, and XML—even for large tables](https://wpdataaccess.com/docs/data-explorer-actions/actions/)
47 -* Perform essential **table actions** like rename, copy, truncate, drop, optimize, and alter
48 -* [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/)
49 -* **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 🌍
50 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 +
51 73 == SQL Query Builder ==
52 -> **Run SQL queries directly within WordPress.**
74 +> **Run and schedule SQL queries** effortlessly from your WordPress dashboard.
53 75
54 -* [Execute multiple SQL queries with **tabbed workflows** for seamless multitasking](https://wpdataaccess.com/docs/sql-query-builder/query-builder-tutorials/)
55 -* **Save and reuse queries** for data tables and charts
56 -* **Built-in safeguards to protect WordPress tables** and data integrity
57 -* [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 🎨
58 83
59 -== Premium Data Services ==
60 -> **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**.
61 86
62 -* **Seamlessly compatible with all plugin features**
63 -* [Premium Remote Connection Wizard for fast, no-fuss setup](https://wpdataaccess.com/docs/remote-connection-wizard/remote-wizard/)
64 - * **Remote Databases**: Connect to SQL Server, Oracle, PostgreSQL, MariaDB, MySQL, and MS Access (file-based)
65 - * **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 ✔
66 93
67 -== Plugin Settings ==
68 -> Detailed settings for **managing the user interface and behavior**.
94 +== Premium Data Services ==
95 +> **Connect, sync, and manage remote databases and data files.**
69 96
70 -* 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) 📄
71 101
72 102 == Legacy Tools ==
73 -> Soon replaced by the **App Builder**.
103 +> Will be replaced by the **App Builder**.
74 104
75 -* Available until at least summer 2025
76 -* Use to maintain old solutions
77 -* 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/))
78 114
79 -== Dashboards and Widgets ==
80 -> Customizable widgets for dashboards (back-end), webpages (front-end), and external websites. **(functionality will be moved to App Builder)**
81 -
82 -* Centralized data management
83 -* Share data widgets anywhere
84 -* Give specific users and user groups access to locked dashboards
85 -* Support for user-created dashboards
86 -* Cost-effective Business Intelligence solution
87 -
88 -== Geolocation search ==
89 -> Create searchable geolocation maps from database tables. **(functionality will be moved to App Builder)**
90 -
91 -* Google Maps integration – Seamlessly incorporate Google Maps for geolocation features
92 -* Customizable settings – Tailor map settings for each database table to fit your needs
93 -* [DataTables integration – Combine with DataTables for enhanced functionality](https://wpdataaccess.com/publication-using-geolocation/)
94 -* [Adjustable radius search map – Enable users to perform searches within a customizable radius](https://wpdataaccess.com/demos/geolocation-demo/)
95 -
96 115 == Useful Links ==
97 116 - [Plugin Website](https://wpdataaccess.com/)
98 -- [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/)
99 125
100 126 == Installation ==
101 127 (1) Upload the WP Data Access plugin to your WordPress site
102 128 (2) Activate the plugin
@@ -101,472 +127,197 @@
101 127 (1) Upload the WP Data Access plugin to your WordPress site
102 128 (2) Activate the plugin
103 129 (3) Navigate to the WP Data Access menu
104 130
105 -And you're all set!
131 +And you're all set! 🚀
106 132
107 133 == Changelog ==
108 134
109 -= 5.5.35 =
110 -* Released 2025-02-24
111 -* Added: Key icon to primary key fields
112 -* Improved: Layout hook settings
113 -* Fixed: Allow hiding mandatory fields that have a default value
114 -* Fixed (with limitations): Media library window shows behind modal form window
115 -* Fixed: Changing grid settings requires reload
116 -* Fixed: Table footer not visible in full-screen mode
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
117 145
118 -= 5.5.34 =
119 -* Released 2025-02-17
120 -* Updated: Documentation links
121 -* Fixed: Charts showing Chart Builder icon for non-admin users
122 -* Fixed: Row export to SQL not working from Data Explorer
123 -* Fixed: Builder icon visibility fails with multiple shortcodes on same page
124 -* Fixed: Start app in fullscreen mode
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
125 158
126 -= 5.5.33 =
127 -* Released 2025-02-06
128 -* Added: Element ID's to improve end-to-end testing
129 -* Added: Autocompletion to column filter
130 -* Improved: Add metadata server side to improve app load time on public pages
131 -* Improved: Skip LOV rest api call with client-side processing
132 -* Improved: State management large table support
133 -* Improved: State management server/client-side processing
134 -* Fixed: Invalid row count after insert and delete with server-side processing
135 -* Fixed: Invalid row count update with search panes and server-side processing
136 -* Fixed: Invalid row count on search with client side processing
137 -* Fixed: Multi-select column filter and search panes not working with client-side processing
138 -* Fixed: Search panes for lookups not working with client-side processing
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
139 178
140 -= 5.5.32 =
141 -* Released 2025-01-27
142 -* Added: Chart configuration to Table Settings
143 -* Added: Chart integration with data table
144 -* Added: Link to online roadmap
145 -* Improved: On open form jump, to form top
146 -* Improved: Hints on copy and export app
147 -* Removed: Hooks, Charts and Theme from Data Explorer menu
148 -* Fixed: Predefined search builder criteria not working
149 -* Fixed: Column Filters shown twice when HEADER selected
150 -* Fixed: Cannot use multiple URL parameters in where clause
151 -* Fixed: Popup height incorrect in Firefox
152 -* Fixed: Column filter update performs server request with client-side processing
153 -* Fixed: Column filter update not seeing empty string with server-side processing
154 -* Fixed: Column sorting performs server request with client-side processing
155 -* Fixed: Pagination update performs server request with client-side processing
156 -* Fixed: Inline-editing in Data Explorer returns Error 400
157 -* Updated: Freemius SDK
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
158 198
159 -= 5.5.31 =
160 -* Released 2025-01-16
161 -* Added: Allow user to interactively change table column order
162 -* Added: Show | hide table header and footer
163 -* Added: Sticky header and footer
164 -* Added: Limit input size textarea
165 -* Added: Redirect user after registration completed
166 -* Added: Labels and hints to attachment/upload fields
167 -* Added: Open form in modal window
168 -* Added: Aggregation calculation hint text
169 -* Added: Install function wpda_get_wp_user_id() from Data Explorer - Manage Databases
170 -* Fixed: Alignment of several types of input fields
171 -* Fixed: Client-Side processing not working in Data Explorer
172 -* Fixed: Date fields not localized in PDF export
173 -* Fixed: Import detail apps not working with MySQL V8
174 -* Fixed: Undefined rest api action causes Data Explorer crash
175 -* Fixed: Empty theme settings panel shown for relationships
176 -* Fixed: External CSS overwrites fieldset and legend styles
177 -* Fixed: Missing super-admin capabilities
178 -* Fixed: Blocked aria-hidden on an element because its descendant retained focus
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
179 215
180 -= 5.5.30 =
181 -* Released 2025-01-02
182 -* Fixed: PDF export not working with inline editing enabled columns
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
183 222
184 -= 5.5.29 =
185 -* Released 2024-12-31
186 -* Added: Client-Side processing
187 -* Added: Export all rows (client-side processing)
188 -* Added: Duration input element for storing durations up to 99 hours in the MySQL time format
189 -* Added: Hide powered by label in PDF footer
190 -* Fixed: Math function requires two values
191 -* Fixed: Computed field output in PDF
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)
192 234
193 -= 5.5.25 =
194 -* Released 2024-12-28
195 -* Fixed: Lookups blank in PDF
196 -* Fixed: Handle local storage exceptions
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
197 255
198 -= 5.5.24 =
199 -* Released 2024-12-24
200 -* Added: New onAppOpen and onAppClose hooks
201 -+ Added: Requery table programmatically
202 -* Improved: PDF export and user interface
203 -* Fixed: Expanded rows not closed on page change
204 -* Fixed: Aggregation decimals
205 -* Fixed: NO_TABLE_OPTIONS is deprecated in MySQL V8
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
206 268
207 -= 5.5.23 =
208 -* Released 2024-12-18
209 -* Added: Enable|disable embedded HTML in text columns
210 -* Added: Customizable height for multi line text fields
211 -* Added: Default user adjustable column filter value
212 -* Fixed: Cannot save legacy tool status with free version
213 -* Fixed: Lovs not unescaping HTML characters
214 -* Fixed: Lookups not unescaping HTML characters
215 -* Fixed: Input font sizing not working
216 -* Fixed: When adding a new row, dropdown fields that set to be non-editable or hidden still appear visible and editable
217 -* Fixed: Date localization UK not working correctly
218 -* Fixed: Selection checkboxes visibility not toggled when fullscreen toggled
219 -* Fixed: Plain text hyperlink not processed correctly
220 -* Fixed: App type search not working when text search is empty
221 -* Fixed: Form not showing if default where contains error
222 -* Fixed: Give a proper console error when table lookup fails
223 -* Fixed: 1:1 relationship issues
224 -* Fixed: Search & replace gives no results for remote databases
225 -* Fixed: Invalid hyperlink format throws error and shows blank screen
226 -* Fixed: Change order direction handling
227 -* Changed: Builder menu structure to accommodate more menu items
228 -* Changed: Math library to reduce bundle size
229 -* Optimized: Client bundle
230 -* Optimized: Store handling
231 -* Optimized: Lazy load language files
232 -* Updated: Freemius SDK
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
233 275
234 -= 5.5.22 =
235 -* Released 2024-11-28
236 -* Added: Table component reference to table hooks
237 -* Added: Parameter pp-page to jump to specific page on page load
238 -* Added: Allow inline editing with row update disabled
239 -* Added: Save button to table header for inline updates
240 -* Added: Hide auto-increment columns during insert if visibility = off
241 -* Fixed: Missing form column code causes fatal error
242 -* Fixed: WPDAVAR and WDPATMP no longer working in SQL Query Builder
243 -* Fixed: Insert fails when primary key contains and auto_increment and additional columns
244 -* Fixed: Global search not working in free version
245 -* Fixed: Less than character not unescaped
246 -* Fixed: Lookup wizard update does not update related tables and columns
247 -* Changed: Freemius SDK integration
248 -* Optimized: Bundles and store
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
249 281
250 -= 5.5.20 =
251 -* Released 2024-11-15
252 -* Fixed: Apply + OK buttons not working after closing Form Builder
253 -* Fixed: Null value validation not triggered on update
254 -* Fixed: All legacy tools removed from toolbar
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
255 300
256 -= 5.5.19 =
257 -* Released 2024-11-15
258 -* Added: Enable | Disable legacy tools from tool guide page
259 -* Added: Allow server side default values on insert
260 -* Moved: Dashboards and Charts menu items to legacy tools section
261 -* Fixed: Tool guide header too wide on small devices
262 -* Fixed: Hidden elements using dashboard space
263 -* Fixed: Trailing comma causing error with PHP7
264 -* Fixed: Selector returns different results when called with same arguments
265 -* Fixed: Join Builder and Relation Builder button access
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
266 321
267 -= 5.5.17 =
268 -* Released 2024-11-07
269 -* Added: Charts to App Builder
270 -* Added: Rename database feature
271 -* Added: Allow computed fields in forms as own element (instead of inside an input element)
272 -* Added: Tip to improve performance on first table load
273 -* Improved: Usability builder column icons
274 -* Fixed: Pagination issue, next button not clickable on second page
275 -* Fixed: Fields with inline editing enabled reflect first row value when second row is filtered
276 -* Fixed: Column header to wide when inline search in header is enabled
277 -* Fixed: Default full screen not defined
278 -* Fixed: Row count issue with large table support
279 -* Fixed: Missing mandatory column does not show error on insert
280 -* Fixed: Passing incorrect form mode
281 -* Fixed: Disable inline editing for parent ID column
282 -* Fixed: Populating M2M list returns unknown column in field list
283 -* Fixed: Insert M2M form using auto increment column
284 -* Fixed: Lookup relation tables returning bad request
285 -* Fixed: Mandatory columns not in forms prevent saving data
286 -* Updated: Freemius SDK
287 -
288 -= 5.5.16 =
289 -* Released 2024-10-16
290 -* Added: Registration form
291 -* Added: Save view selection in App Builder
292 -* Added: Cascading app deletion
293 -* Added: Allow user to show | hide table columns
294 -* Optimized: Hook editor updates to prevent unnecessary re-renders
295 -* Changed: Bulk action column selection showing labels instead of column names
296 -* Fixed: Join and relation table settings not saved correctly
297 -* Fixed: Class names for styles not applied to lookup fields
298 -* Fixed: XML export not processing null values correctly
299 -* Fixed: App copy missing multi-level relationships
300 -* Fixed: App export missing multi-level relationships
301 -* Fixed: App export missing WordPress table prefix
302 -* Fixed: App copy Data App missing detail apps
303 -* Fixed: App export Data App missing detail apps
304 -* Fixed: Responsiveness of data tables also set to scroll for views
305 -* Fixed: Column filter layout when field layout is filled
306 -* Fixed: Default detail panel overflow on mobile devices
307 -* Fixed: Media button labels in Form Builder DELETE and SELECT not translated
308 -* Fixed: Disable column render hook for computed fields
309 -* Fixed: Border radius first line App Builder and Data Explorer incorrect
310 -* Fixed: Color button labels in header
311 -* Fixed: Border radius incorrect App Builder and Data Explorer
312 -* Fixed: Null pointer exception on toLowerCase
313 -* Fixed: Handle references to deleted apps
314 -* Fixed: Cannot open table builder for data explorer
315 -* Fixed: Show more button relation table
316 -* Fixed: Cleanup relation table references on cancel
317 -* Fixed: Column filter processing join and relation table columns
318 -* Fixed: App crashes when filter is changed on detail table
319 -* Fixed: Special characters added to column label end are moved to the front in detail view
320 -* Fixed: Searchbox highlight replicating selected values
321 -* Fixed: Last column disappears when it is invisible and a computed field is added
322 -* Removed: Refresh icon from table table when inline editing is enabled
323 -* Removed: Copy/export data apps (copy only real containers)
324 -* Removed: Redundant free code from premium version (does not affect free version)
325 -* Updated: Opt-in icons
326 -* Updated: Freemius SDK
327 -
328 -= 5.5.14 =
329 -* Released 2024-09-17
330 -* Added: Manage relationships from Table Builder and Form Builder
331 -* Added: Selectable density state to App Builder and Data Explorer
332 -* Added: Force aggregations to use column localization settings
333 -* Added: Start apps in full screen mode
334 -* Fixed: Reapply theme settings to app after switching
335 -* Fixed: App Builder record lists subtract 1 day from date fields
336 -* Fixed: Fatal error when disabling full lookup on startup
337 -* Fixed: Column border missing in table and form builder
338 -* Fixed: Lookup value substitution not working correctly when lookup return just one value
339 -* Fixed: Computed field duplicated when applied multiple times on creation
340 -* Fixed: Menu item not focusable
341 -* Fixed: Row selection checkbox shown above row action icons when scrolling
342 -* Fixed: Hidden columns shown when responsiveness is set to scrollbar
343 -* Changed: Row selection column no longer pinned
344 -* Changed: Show icon buttons on toolbar instead of buttons on small devices
345 -* Changed: App Builder layout
346 -* Updated: Freemius SDK
347 -
348 -== Changelog ==
349 -= 5.5.13 =
350 -* Released 2024-09-08
351 -* Fixed: Events on computed fields lost
352 -* Fixed: Textarea padding
353 -* Fixed: Responsive column hiding
354 -* Fixed: Padding right TH, TD
355 -* Fixed: Table overflow issues
356 -
357 -= 5.5.12 =
358 -* Released 2024-09-05
359 -* Fixed: Relation table not shown when using artificial primary key
360 -* Fixed: Relation table join condition missing table names
361 -* Fixed: Date not localized
362 -* Fixed: Explicitly set background fixed columns
363 -* Fixed: Removed migration message from Data Designer toolbar
364 -* Fixed: Auto complete internal key mismatch
365 -* Fixed: Image size in data table
366 -* Added: Export to PDF icon to detail panel
367 -* Added: Column selection in bulk actions exports
368 -* Added: A number of hooks to customize data table layout and behaviour
369 -* Changed: Detail panel layout
370 -* Changed: App Builder layout
371 -* Changed: Data Explorer layout
372 -
373 -= 5.5.11 =
374 -* Released 2024-08-22
375 -* Fixed: Super admin cannot access sub site
376 -* Fixed: Divi styling issues
377 -* Fixed: Elementor styling issues
378 -* Fixed: Cannot read properties of null (reading 'toLocaleLowerCase')
379 -* Fixed: Full screen data app not showing table correctly
380 -* Fixed: Inline auto save columns not saving properly
381 -* Fixed: Cannot use % character in where clause lookups
382 -* Fixed: Pagination rows per page setting not updated
383 -* Fixed: M:M relationships losing primary key values
384 -* Added: View Data Apps structure in App Builder
385 -* Added: Copy shortcode to App Builder actions
386 -* Added: App actions menu to the App Builder
387 -* Added: Pagination display options: top, bottom, or both
388 -* Added: Support for thousand and decimal separators in numeric input fields
389 -* Added: Enhanced language support for date, time, and numeric fields
390 -* Added: CodeMirror integration for writing computed field implementations
391 -* Added: JavaScript and HTML support to Code Mirror
392 -* Added: Hint to old table and form builders to prevent confusion
393 -* Added: Inline data viewing with a detail panel
394 -* Added: WordPress and plugin table information to the Data Explorer
395 -* Changed: Builder resizing behaviour
396 -* Removed: View row id from data table
397 -* Removed: App foreign key constraints
398 -* Updated: Freemius SDK
399 -
400 -= 5.5.9 =
401 -* Released 2024-07-30
402 -* Fixed: Localization not available for date columns
403 -* Fixed: Increase specificity table style
404 -* Fixed: Form Builder icon always visible for master-detail relationships
405 -* Fixed: Highlighting not working if inline HTML is enabled
406 -* Fixed: React findDOMNode is deprecated in StrictMode
407 -* Fixed: Invalid data type on column filter
408 -* Fixed: Cannot reorder details
409 -* Fixed: Cannot add column filter for hidden columns
410 -* Fixed: Relationship display type updates not detected
411 -* Fixed: App Manager asking for confirmation after shortcode generation
412 -* Fixed: Inline field settings not applied
413 -* Fixed: Undefined table settings on multi level master-detail
414 -* Fixed: App pages on back-end missing CSS styling
415 -* Moved: Changelog to readme (making it available online)
416 -* Added: New app type "app container" to bundle apps into one main app
417 -* Added: Apps to repository backup and restore
418 -* Added: Tool replacement info.
419 -* Added: Premium color gold to plugin menu icon.
420 -* Added: Tool guide page also containing FAQs
421 -* Added: Let import container wait until all databases are loaded
422 -* Added: Added lookup placeholders to computed fields
423 -* Added: Custom shortcode parameter support
424 -* Added: Make computed field label in Form editable from columns list
425 -* Added: Container ID to increase CSS specificity
426 -* Added: Classname pp-fullscreen to body element when entering full screen mode
427 -
428 -= 5.5.7 =
429 -* Released 2024-07-16
430 -* Fixed: Adding a search pane to a column with lookup requires a full table reload
431 -* Fixed: Page scrolls down when keys f, s, t, v pressed in search boxes
432 -* Fixed: Autocomplete not correctly showing for lookup columns with field layout set to filled or standard
433 -* Fixed: Null value in LOV returns an empty list item
434 -* Fixed: Filter mode 'between inclusive' for datetime not working correctly (same results as inclusive)
435 -* Improved: Language files loaded moved to JSON format and loaded at runtime to improve performance
436 -* Improved: Many textual improvements (hints, examples, labels)
437 -* Improved: Uniformized layout and style of all field types and modes
438 -* Improved: Computed field calculations and display
439 -* Added: Several CSS classes for custom styling
440 -* Added: Customize column filters width
441 -* Added: Customize column filters ordering
442 -* Added: Customize default page size
443 -* Added: Customize available page sizes
444 -* Added: Search panes
445 -* Added: Cascading searches for lookups and lovs
446 -* Added: Custom color picker to theme settings
447 -* Added: HTML and JS support to computed fields
448 -* Added: URL parameter support
449 -* Added: Shortcode parameter support
450 -* Added: Ability to disable full screen mode
451 -* Added: Workaround for app preview not loading styles in Divi Visual Builder (showing no preview message instead)
452 -* Updated: Freemius SDK
453 -
454 -= 5.5.6 =
455 -* Released 2024-07-02
456 -* Fixed: Lookup search
457 -* Fixed: User can hide column filter by clicking on filter icon even when hiding is disabled
458 -* Fixed: Filter match highlight
459 -* Added: Shortcode parameter to disable builders on front-end
460 -* Added: Show column filters in table column header
461 -* Added: Lookups missing to export
462 -* Added: Computed fields to export
463 -* Added: Filter match highlight to lookup columns
464 -* Added: Column alignment to PDF export
465 -* Added: PDF orientation and style selection
466 -* Added: Full app localization (containing 35 languages)
467 -* Added: Export apps
468 -* Updated: Freemius SDK
469 -
470 -= 5.5.5 =
471 -* Released 2024-06-20
472 -* Post fix: Copy app not copying details
473 -* Post fix: New record added twice for m:m relationship
474 -* Fixed: Force user to select at least one column on app creation or update
475 -* Fixed: Force user to select at least one column on lookup creation or update
476 -* Fixed: Force user to select at least one column on relationship creation or update
477 -* Fixed: Plugin does not register lookup changes
478 -* Fixed: Empty detail blocks visible on master insert
479 -* Fixed: Wrong (local) date in data table (converted to UTC)
480 -* Fixed: Row selection toggled on inline editing fields
481 -* Fixed: Builder buttons on detail form visible to non admins
482 -* Fixed: Media Library window appears behind the form when triggered
483 -* Changed: Export table or app name instead of app id
484 -* Added: Copy app link and icon
485 -* Added: Bulk actions for views
486 -* Added: M:m relation to App Builder
487 -* Added: Kill token property to chart widget
488 -
489 -= 5.5.4 =
490 -* Released 2024-05-28
491 -* Fixed: Lookup values not shown in exports
492 -* Fixed: Export to pdf adds an empty column
493 -* Fixed: Details not shown to non admin users
494 -* Fixed: View action for tables without primary key and views
495 -* Fixed: Table cell colors incorrect with multiple apps on one page
496 -* Fixed: WordPress media library usage not working on insert
497 -* Fixed: Rename view not working
498 -* Fixed: Drop view not working
499 -* Fixed: Link tooltips in Data Explorer not completely visible
500 -* Fixed: Media type update not working
501 -* Fixed: Server side updates not synced on client
502 -* Fixed: Sending non-updatable fields to server
503 -* Fixed: Column filters empty and not empty not working with lookups
504 -* Fixed: Column positioning not working with full screen master-detail
505 -* Fixed: Reduce margin bottom of error panel in Data Explorer
506 -* Added: Alter table action to new Data Explorer
507 -* Added: Change PDS refresh interval to new Data Explorer
508 -* Added: Manage databases to Data Explorer
509 -* Added: Premium Data Services access to new Data Explorer
510 -* Added: Change font size of input fields, labels and hints
511 -* Added: Monitor updates in App Manager
512 -* Added: Refresh columns button to App Manager
513 -* Added: Adjustable elevation to app containers
514 -* Added: Use WordPress date and time format in tables
515 -* Added: Sync root app theme with detail app theme in real time
516 -* Added: SQL and ZIP file import to Data Explorer
517 -* Added: Bulk actions to Data Explorer
518 -* Added: Elevation to Papers, Cards and App Bars
519 -* Added: Persistent search criteria in Data Explorer and App Builder
520 -
521 -= 5.5.3 =
522 -* Released 2024-05-15
523 -* Improved: Column filter support
524 -* Improved: Several builder hints
525 -* Improved: App responsiveness
526 -* Fixed: Cannot use view in lookups
527 -* Fixed: Master-detail key issue
528 -* Fixed: Database column default constraints not used
529 -* Fixed: Lookups not used in global search
530 -* Fixed: Multi select drop down list not working
531 -* Fixed: Position apps list when opening App Builder
532 -* Fixed: Error on column filter change
533 -* Fixed: Cannot open computed field accordion
534 -* Fixed: Column filter between not working
535 -* Fixed: JSON parse error in Data Explorer
536 -
537 -= 5.5.2 =
538 -* Released 2024-05-08
539 -* Added: Inherited font family from page
540 -* Added: Show more|less button
541 -* Added: Column default value
542 -* Added: Master-detail display type
543 -* Added: Inline HTML support to table cells
544 -* Added: Examples to setting blocks
545 -* Improved: Relationship configuration
546 -* Improved: Lookup configuration
547 -* Fixed: Date/time localization not working
548 -* Fixed: Prefill parent data in child component
549 -* Fixed: Lookup not respecting required constraint
550 -
551 -= 5.5.1 =
552 -* Released 2024-04-19
553 -* Added: 1:1 and 1:n relationships to App Builder
554 -* Fixed: Added client version number to prevent caching old client files
555 -* Fixed: Geomap not working with block-based themes (Ian)
556 -* Updated: Freemius SDK
557 -
558 -= 5.5.0 =
559 -* Released 2024-04-18
560 -* Added: Pre-release new App Builder
561 -* Fixed: URL parameter % usage
562 -
563 -= 5.4.0 =
564 -* Released 2024-01-25
565 -* Added: Pre-release new Data Explorer
566 -* Added: REST API drop-down multi-select inline search
567 -* Added: REST API drop-down inline search
568 -* Changed: REST API inline search and estimated row count
569 -* Updated: Freemius SDK
570 -
571 -= < 5.4.0 =
572 -* See changelog.txt in plugin folder
322 += < 5.5.72 =
323 +* See changelog.txt