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