| 1 |
### ChangeLog for WP Data Access |
| 2 |
|
| 3 |
#### 5.2 / 2022-06-24 |
| 4 |
|
| 5 |
Added: Copy table to other database |
| 6 |
Added: Premium data services |
| 7 |
Added: Promotion links |
| 8 |
Fixed: Error changing search panes in advance settings (Mark) |
| 9 |
Fixed: Responsive icon not shown in themes like DIVI that use their own IDs to style all page elements |
| 10 |
Fixed: Data Publisher returns a "CPT not found" error on publication creation |
| 11 |
Fixed: Icons missing after submit+list in Data Publisher |
| 12 |
Fixed: Fatal error "allowed memory size exhausted" during export of extremely large tables |
| 13 |
Fixed: Publication Search Builder correctly refreshes the table but not the geomap (Terry) |
| 14 |
Fixed: Publication Search Panes correctly refreshes the table but not the geomap (Terry) |
| 15 |
Updated: Dropbox backup working with refresh tokens |
| 16 |
|
| 17 |
#### 5.1.8 / 2022-05-19 |
| 18 |
|
| 19 |
Patched: Query Builder output not encoded (Frank) |
| 20 |
|
| 21 |
Fixed: Search panes not taking default where into account (Rahim) |
| 22 |
Fixed: Individual column search not working with client search (Philip) |
| 23 |
Fixed: URL parameters not working correctly with: /?wpda_search_column_a=%ac% (Marvin) |
| 24 |
Fixed: Cannot add a tab to the Query Builder (Charles) |
| 25 |
Added: Let Google Maps start in different modes (Terry) |
| 26 |
Changed: Type of password fields to hide password |
| 27 |
Changed: Option stateSave default value to false |
| 28 |
Updated: Dropbox backup app |
| 29 |
Removed: No longer using guzzle for remote requests (Andy) |
| 30 |
|
| 31 |
#### 5.1.7 / 2022-04-21 |
| 32 |
|
| 33 |
Changed: Center geo marker when user clicks on it (Jonathan) |
| 34 |
Added: Options "wpda_searchbox": "none" and "wpda_searchbox": "footer" (Charles) |
| 35 |
Added: Search clear icon to publication search boxes |
| 36 |
Fixed: URL parameter not working with "No search condition = show no rows" (Charles) |
| 37 |
Fixed: Visual Query Builder not working with remote databases (Hank) |
| 38 |
Fixed: Data Publisher showing unavailable columns in order by drop down list (tonysac123) |
| 39 |
Fixed: Query Builder not parsing like '%%ac%' correctly (Marvin) |
| 40 |
|
| 41 |
#### 5.1.6 / 2022-04-07 |
| 42 |
|
| 43 |
Patched: File upload not working on Windows |
| 44 |
|
| 45 |
Added: Advanced chart options (Iek) |
| 46 |
Added: CPT query support to Data Publisher |
| 47 |
Updated: External libraries |
| 48 |
Fixed: Insert fails on child of n:m relationship in remote database (Hank) |
| 49 |
Fixed: NL language typo |
| 50 |
Fixed: Add New button shown on registration page (Philip) |
| 51 |
Fixed: Add data type to Search Builder (Perry) |
| 52 |
Fixed: Limit does not work for custom queries in Query Builder (Steve) |
| 53 |
Fixed: Bad jQuery solector (@luk4) |
| 54 |
Fixed: Publication order by issue |
| 55 |
Fixed: Publication extensions column too small |
| 56 |
Fixed: Several publication styling issues |
| 57 |
Fixed: Error when opening view settings in Data Explorer |
| 58 |
|
| 59 |
#### 5.1.5 / 2022-03-25 |
| 60 |
|
| 61 |
Added: Create publication from custom query |
| 62 |
Added: Server side processing support to Search Panes |
| 63 |
Added: Checkbox server side processing to Data Publisher |
| 64 |
Added: User friendly interface for order by Data Publisher |
| 65 |
Updated: External libraries and library calls |
| 66 |
Updated: Disabled hints in Query Builder by default |
| 67 |
Fixed: Order by hint Data Publisher |
| 68 |
|
| 69 |
#### 5.1.4 / 2022-03-02 |
| 70 |
|
| 71 |
Added: Clear icon to search column search boxes (Philip) |
| 72 |
Updated: Data Publisher icon layout |
| 73 |
Updated: Data Forms item layout |
| 74 |
Updated: External libraries and library calls |
| 75 |
Fixed: Truncate table not working |
| 76 |
Fixed: Search Builder ENTER key issue |
| 77 |
Fixed: Search removes special characters (Frans) |
| 78 |
|
| 79 |
#### 5.1.3 / 2022-02-24 |
| 80 |
|
| 81 |
Added: Chart page added to plugin toolbar |
| 82 |
Added: Option to hide icons on admin buttons (Dennis) |
| 83 |
Fixed: Cannot create charts from dashboard (Sandras) |
| 84 |
Fixed: Data Forms error when no data found (Alaa) |
| 85 |
Fixed: Search not working correctly with two publications on one page (Roberto) |
| 86 |
Fixed: Search Builder writes entry to debug.log |
| 87 |
Fixed: Publication drop down list too tight on Dashboard |
| 88 |
|
| 89 |
#### 5.1.2 / 2022-02-04 |
| 90 |
|
| 91 |
Added: Allow search on specific columns only in Search Builder |
| 92 |
Added: Export and print buttons to charts (Iek) |
| 93 |
Added: Plugin setting to revoke create dashboard privilege |
| 94 |
Added: Plugin setting to hide default tab on dashboard |
| 95 |
Added: Dashboard sharing on role and user level |
| 96 |
Added: Remove all usermeta data on uninstall (delete plugin settings) |
| 97 |
Changed: Dashboard name must be unique |
| 98 |
Changed: User must press ENTER to start publication search (use wpda_search_force_enter to disabled) |
| 99 |
Fixed: Search Builder selecting wrong columns |
| 100 |
Fixed: Search Builder not sending value without explicitly pressing ENTER on each column |
| 101 |
Fixed: Project list table missing columns after Submit > List (Jay) |
| 102 |
Fixed: Cannot show search box in table header with Query Builder enabled (Clive) |
| 103 |
Fixed: Query Builder not working for some columns (Tarik) |
| 104 |
Fixed: Search Builder not working with: No search condition = show no rows (Charles) |
| 105 |
Fixed: Search Builder uses wrong column labels |
| 106 |
Fixed: Datatables date popup icons not showing correctly |
| 107 |
Fixed: Search pane buttons not showing icons |
| 108 |
Fixed: I can only see that I can click on the even numbered rows in a Search Pane (Ken) |
| 109 |
|
| 110 |
#### 5.1.1 / 2022-01-17 |
| 111 |
|
| 112 |
Patched: DT select v1.3.4 not working with DT panes v1.2.1 (going back to 1.3.3) |
| 113 |
Patched: Checkboxes in advanced settings not shown |
| 114 |
|
| 115 |
Added: Hide Manage link in Data Explorer for specific administrators (Nelson) |
| 116 |
Added: Bulma and Bootstrap 5 to premium global styling |
| 117 |
Added: Server side processing to Search Builder |
| 118 |
Added: Graphical DOM manipulation to premium version |
| 119 |
Added: Search builder and button extention to premium version |
| 120 |
Added: Default styling options to Data Publisher free version |
| 121 |
Added: Expandable field sets to Data Publisher |
| 122 |
Added: Pagination to chart table |
| 123 |
Updated: Editing query name in Query Builder (added icon and hint) (Alex, Ken) |
| 124 |
Updated: Publication date and number columns no longer wrapped |
| 125 |
Updated: External libraries + cleaning up files and folders |
| 126 |
Updated: Hard coding plugin name and tool names (for international branding) |
| 127 |
Fixed: Form updates not working with date columns in primary and unique keys (Mieke) |
| 128 |
Fixed: Search location not added to geo map (Andy) |
| 129 |
Fixed: Child table not directly shown after adding new parent (John) |
| 130 |
Fixed: Removed \n from translations |
| 131 |
Fixed: Cannot add role in Dutch version (Iek) |
| 132 |
Fixed: Global publication styling not using full external libraries (premium only) |
| 133 |
Removed: Global publication styling from free version |
| 134 |
Removed: Compact style from publication global styling |
| 135 |
|
| 136 |
#### 5.1.0 / 2021-12-14 |
| 137 |
|
| 138 |
NEW: Premium Visual Query Builder |
| 139 |
Added: Dynamically switch between user location and fixed location in geomap (Andy) |
| 140 |
Added: Add new button to registration form |
| 141 |
Fixed: Error when trying to add new row to external or remote database table |
| 142 |
Fixed: Remove GuzzleHttp\json_encode() call from Data Publisher and Data Forms (Peng) |
| 143 |
Fixed: Export not working when confirmation enabled (Lars, Charles, Paul) |
| 144 |
Fixed: Cannot change time of DateTime column in Data Forms (Joseph) |
| 145 |
Fixed: Removed "Submit > List" button from registration form |
| 146 |
|
| 147 |
#### 5.0.2 / 2021-12-07 |
| 148 |
|
| 149 |
Added: Label and hover effect to toolbar icons |
| 150 |
Improved: All arguments removed from export URL |
| 151 |
Fixed: Substitution in dynamic hyperlink fails if column name is part of earlier displayed column name (Andy) |
| 152 |
Fixed: Query Builder does not give any feedback on user actions |
| 153 |
Fixed: Tooltip in Query Builder free version using wrong css |
| 154 |
Fixed: "Add dashboard" icon not available in free version |
| 155 |
Fixed: Removed CSV and JSON full table export buttons from Data Explorer main page |
| 156 |
Fixed: Buttom Submit > List not always working |
| 157 |
Fixed: No buttons added to header in Data Menu forms (Jan) |
| 158 |
Fixed: "Value for page allow full export not allowed" when trying to save project page (John) |
| 159 |
|
| 160 |
#### 5.0.1 / 2021-11-25 |
| 161 |
|
| 162 |
Added: Replace new line with <BR/> in list tables (Andrea) |
| 163 |
Added: Automatically redirect to list after insert or update (Nicholas) |
| 164 |
Added: Export all rows to CSV|JSON button to Data Projects and Data Explorer (Philip) |
| 165 |
Fixed: Allowing database names to start with a number (Eduard) |
| 166 |
Fixed: Dashboard and panels not showing |
| 167 |
Fixed: Notices not disabled |
| 168 |
Fixed: Token expired message with publication old shortcode |
| 169 |
Fixed: Missing insert buttons on project pages |
| 170 |
Fixed: Showing debug message |
| 171 |
Fixed: Missing library file |
| 172 |
|
| 173 |
#### 5.0.0 / 2021-11-04 |
| 174 |
|
| 175 |
NEW: Dashboard panels |
| 176 |
Added: Test publications directly from table list |
| 177 |
Added: SQL hints to Query Builder |
| 178 |
Improved: Data Forms menu handling |
| 179 |
Changed: Put view link back (Jay) |
| 180 |
Fixed: Lookup individual column search does not allow to select all (Jay) |
| 181 |
Fixed: Cannot add full-text index with only text columns (Alan) |
| 182 |
Fixed: Set maxlength of textarea depending on text type (Alan) |
| 183 |
Fixed: Data Designer does not check length varchar|char|varbinary|binary columns (Amy) |
| 184 |
Fixed: Backup date not properly sanitized (Erwan) |
| 185 |
Fixed: Removed script tags from publication column values |
| 186 |
|
| 187 |
#### 4.3.1 / 2021-09-16 |
| 188 |
|
| 189 |
Fixed: Search on individual columns in Data Projects uses ID for lookups (Rahim) |
| 190 |
Fixed: Data Forms inserting default values instead of null values |
| 191 |
Fixed: Data Forms lookup missing empty values (Gaetan) |
| 192 |
Fixed: Data Forms invalid default added to empty data fields (Alonso) |
| 193 |
Fixed: Data Forms tables not refreshed for remote tables (Wayne) |
| 194 |
Fixed: CSV import local database != wpdb not working (Roger) |
| 195 |
Fixed: Map not syncing with publication search |
| 196 |
Fixed: Data Backup available again (Wayne) |
| 197 |
Changed: Hide view link if row is editable |
| 198 |
Changed: Show "WordPress database (...)" instead of ... (= $wpdb->dbname) |
| 199 |
Added: Premium features Data Publisher available in back-end |
| 200 |
Added: A killToken option to Data Publisher to fix caching issues |
| 201 |
Added: Hide notices of other themes and plugins on WP Data Access admin pages |
| 202 |
Added: Export child tables |
| 203 |
Added: Copy to clipboard button to Query Builder |
| 204 |
*** BETA FEATURES - PREPARING VERSION 5 *** |
| 205 |
Added: Data Forms panels to dashboard |
| 206 |
Added: Publication panels to dashboard |
| 207 |
Added: Dashboard panels to run custom PHP, HTML and JS code |
| 208 |
Added: Database panels to dashboard |
| 209 |
Added: Chart panels to dashboard |
| 210 |
Added: Embedding panels into external websites |
| 211 |
Added: Shortcode support for dashboard panels |
| 212 |
Added: Divide dashboard in 1 to 4 columns |
| 213 |
Added: Dashboard panels to analyse, report and share data |
| 214 |
*** BETA FEATURES - PREPARING VERSION 5 *** |
| 215 |
Updated: Using external font files for material icons and fontawesome to save space |
| 216 |
Updated: Composer V1 to V2 |
| 217 |
|
| 218 |
#### 4.3.0 / 2021-08-12 |
| 219 |
|
| 220 |
Improved: Inline styling removed from publications (Philip) |
| 221 |
Improved: Rewritten admin_url calls to support changed paths (xkaspr) |
| 222 |
Fixed: Error messages Query Builder not removed |
| 223 |
Fixed: Search criteria entered for parent is also applied to child (Ivan) |
| 224 |
Fixed: Publication modal scrollable area (Andrew) |
| 225 |
Fixed: Publication modal not completely visible (Andrew) |
| 226 |
Added: Made publications draggable and scrollable (Andrew) |
| 227 |
Added: Public support forum link to plugin menu |
| 228 |
Added: Fontawesome |
| 229 |
Added: Plugin dashboard |
| 230 |
|
| 231 |
#### 4.2.10 / 2021-07-05 |
| 232 |
|
| 233 |
Added: Premium publication styling directly from the Data Publisher |
| 234 |
Added: Projects to font-end toolbar (Allan) |
| 235 |
Added: URL parameter 'wpda_search_column_operator' to support OR conditions |
| 236 |
Improved: Redesigned some calls to decrease memory usage |
| 237 |
Improved: Redesigned settings pages to decrease memory usage |
| 238 |
Fixed: Dates not stored correctly (Barbara, Alan, Mushfiq) |
| 239 |
Fixed: Search box shown at page bottom with wpdadiehard |
| 240 |
Fixed: Using home url instead admin url |
| 241 |
Fixed: Query Builder uses home url instead admin url (Michel) |
| 242 |
Fixed: Default value checkbox enabled not working (Allessandro) |
| 243 |
Fixed: Images used in dynamic hyperlinks not shown correctly |
| 244 |
|
| 245 |
#### 4.2.9 / 2021-06-14 |
| 246 |
|
| 247 |
Fixed: Responsiveness doesn't work for views in the WordPress dashboard (Andrea) |
| 248 |
Fixed: Ancient dates not working with format d/m/Y and m/d/Y - inline editing only (Alessandro) |
| 249 |
Fixed: SQL Builder not showing output when header contains too many ads |
| 250 |
Added: Transaction handling for connect storage engine tables |
| 251 |
|
| 252 |
#### 4.2.8 / 2021-06-01 |
| 253 |
|
| 254 |
Added: Schema, table and column name validation to maximize plugin feature support |
| 255 |
Added: Additional error info to failing Data Forms requests (Barbara) |
| 256 |
Added: Last query error to JSON output of publications |
| 257 |
Added: Commands wpdavar and wpdatmp to Query Builder to copy tables from one database to another |
| 258 |
Added: Dynamically switch between local and remote databases in Query Builder |
| 259 |
Added: Check for unsaved changes on page leave and tab close in Query Builder |
| 260 |
Added: Control/S key to save query Query Builder |
| 261 |
Added: Promo to Data Publisher to show premium features (disabled) |
| 262 |
Added: jQueryUI responsive style to Data Publisher |
| 263 |
Changed: Immediately download file on bulk export Data Explorer main page |
| 264 |
Changed: Page titles, icons and links |
| 265 |
Changed: Import structure and Data Backup access |
| 266 |
Optimized: Sort database and remote database names in listboxes |
| 267 |
Optimized: Query Builder to use wpdb.last_result instead of own rows property |
| 268 |
Fixed: Hyperlink not emptied on insert |
| 269 |
Fixed: Removed debug message when n:m relationship is defined incorrectly |
| 270 |
Fixed: MariaDB stores "NULL" as default instead of null |
| 271 |
Fixed: Hyperlink not working in Data Forms when defined as text |
| 272 |
Fixed: Bulk-delete return not authorized |
| 273 |
Fixed: Next row deleted when deleting child row |
| 274 |
Fixed: Select/deselect all publication not working in Data Publisher list table |
| 275 |
Fixed: Add dummy menu item name to unnamed project menu items |
| 276 |
Fixed: Listbox entries starting with a space not found on individual column search (Charles) |
| 277 |
Fixed: Search filter not working when column name is in uppercase (Charles) |
| 278 |
Fixed: Default where Data Projects does not work with WHERE = uppercase (Andreas) |
| 279 |
Fixed: Double column type not reflected in data entry forms (Chiara) |
| 280 |
|
| 281 |
#### 4.2.7 / 2021-05-12 |
| 282 |
|
| 283 |
Added: Multi SQL command support to Query Builder |
| 284 |
Added: Spinner to Query Builder |
| 285 |
Added: Option wpda_language to support language per publication |
| 286 |
Added: Allow to change "SHOW MORE" and "END OF LIST" labels |
| 287 |
Improved: CSV import menu navigation |
| 288 |
Improved: Security old parameter columns in shortcode wpdataaccess |
| 289 |
Removed: Database and table names from export requests on web pages |
| 290 |
Removed: Database and table names from Data Projects requests on web pages |
| 291 |
Removed: Database, table and column names from Data Publisher requests on web pages |
| 292 |
Fixed: Return to default database after remove a local database |
| 293 |
Fixed: Missing the rename WordPress table protection in the Query Builder |
| 294 |
Fixed: Old wpdadataaccess shortcodes using table argument no longer work |
| 295 |
|
| 296 |
#### 4.2.6 / 2021-05-07 |
| 297 |
|
| 298 |
Added: Query Builder |
| 299 |
Added: $$NOW$$ and $$NOWDT$$ environment vaiables (Roger) |
| 300 |
Added: Pure estimated row count support to Data Publisher |
| 301 |
Added: Argument wpda_search_force_enter to force user to press enter on new search |
| 302 |
Added: Hard estimated row count support (Steve) |
| 303 |
Added: Connect and federated engine support |
| 304 |
Added: New styles to Data Publisher (default, compact, jqueryui, semanticui, foundation, bootstrap3, bootstrap4) |
| 305 |
Improved: CSS publications (color schemes and popups) |
| 306 |
Changed: Table Name to Table/View Name (Tim) |
| 307 |
Changed: Data access selection behaviour in setttings (Jim) |
| 308 |
Changed: Default jQuery UI theme defined on Front-end settings |
| 309 |
Fixed: Lookup not ordered alphabetically in Data Forms (Barbara) |
| 310 |
Fixed: Parameter filter_field_value not taking % (Jan) |
| 311 |
Fixed: By default disable dynamic hyperlinks added after project template creation (Barbara) |
| 312 |
Fixed: Repository update error on table structure changes |
| 313 |
Fixed: Maps error on manage table settings activate |
| 314 |
Fixed: Search filter not working when column name is in uppercase (Lukasz) |
| 315 |
Removed: Edit link from CSV list |
| 316 |
|
| 317 |
#### 4.2.5 / 2021-04-21 |
| 318 |
|
| 319 |
Fixed: Error in row count remote database |
| 320 |
Fixed: Default where not working (Matthew) |
| 321 |
|
| 322 |
Updated: All documentation links |
| 323 |
Added: Demo and tutorial links to Data Publisher and Data Projects |
| 324 |
Added: Row count estimation support for views (Charles) |
| 325 |
Added: Geo range search to Data Publisher (Nicola) |
| 326 |
Added: Fulltext search support to views (Steve and Charles) |
| 327 |
Added: Maximum backups versions saved to manage repository settings (default = 3) |
| 328 |
Added: Search panes to Data Publisher premium (works only client side) |
| 329 |
Added: Custom search builder to Data Publisher premium (works only client side) |
| 330 |
Added: Row grouping to Data Publisher premium |
| 331 |
Added: Support dictionary checks and reconcilation for remote databases in Data Designer (Alex) |
| 332 |
Added: Argument map_radius to geolocation map to hide range filter |
| 333 |
Added: Some tokens to improve security |
| 334 |
Improved: Help links on plugin pages |
| 335 |
Improved: One debug option for all plugin features |
| 336 |
Improved: Column-specific search needs to be added in two steps (Alex) |
| 337 |
Improved: Data Publisher loads publication deferred (performance optimation) |
| 338 |
Fixed: Autocomplete not working when parent settings less enabled |
| 339 |
Fixed: Vulnerability filter column name (Krzysztof) |
| 340 |
Fixed: Geolocation time out |
| 341 |
Fixed: Default order by not working on first column |
| 342 |
Fixed: Disable ordering on hyperlink columns in Data Explorer |
| 343 |
Fixed: Data type tinyint(1) not shown as checkbox in Date Forms (Alex) |
| 344 |
Fixed: Data type tinyint(1) returns tinyiny(3) on reverse engineering |
| 345 |
Fixed: Estimated row count for views returns null |
| 346 |
Fixed: Data Designer adds remote views to drop down list reverse engineering (Charles, busterland) |
| 347 |
Fixed: Manual zoom not working |
| 348 |
Fixed: Inline listbox not shown/updated correctly (Alex) |
| 349 |
Fixed: Row export remote tables return forbidden (Alex) |
| 350 |
Fixed: Function responsiveHidden() not found in jQuery DataTables library (Moreno) |
| 351 |
Fixed: Listbox not ordered (mcreighton) |
| 352 |
|
| 353 |
#### 4.2.1 / 2021-03-28 |
| 354 |
|
| 355 |
Fixed: Lookups not working (Linda) |
| 356 |
Fixed: Field content truncated when entering a quote during inline editing (Luis) |
| 357 |
|
| 358 |
#### 4.2.0 / 2021-03-25 |
| 359 |
|
| 360 |
Added: Support for estimated row count instead of count(*) (Charles) |
| 361 |
Added: Load more button feature to publisher for large tables |
| 362 |
Added: Default value wpda_buttons = 'CEFPYSVT' if wpda_buttons_custom = '' |
| 363 |
Added: Optionally truncate table before importing CSV file (Mark Williams) |
| 364 |
Added: Use OR with URL parameter filter (Barbara, grl570810, Charles) |
| 365 |
Added: Environment variable $$EMAIL$$ = current user email address (tnijland3) |
| 366 |
Added: Geolocation search and mapping (beta - under development) |
| 367 |
Added: Repository backup and restore management to Settings > Manage Repository |
| 368 |
Improved: Check if data type allows max length in Data Designer (Nicola) |
| 369 |
Improved: Remove ID from tool exports (Charles) |
| 370 |
Improved: Plugin installation procedure |
| 371 |
Improved: Icon no longer shown in a separate column with buttons |
| 372 |
Improved: Cookie experation on default schema changed from 24 hours to 365 days |
| 373 |
Improved: Remote database error handling |
| 374 |
Improved: Repository backup procedure |
| 375 |
Fixed: Foreign key constraints of remote database not shown (Alex) |
| 376 |
Fixed: Added dashicons to publications for media attachments (Dirk) |
| 377 |
Fixed: Export/import prefix to WordPress and plugin tables (renpersonal) |
| 378 |
Fixed: @ini_set return error with php 8 (grema) |
| 379 |
Fixed: Update failed when saving post with invalid shortcode |
| 380 |
Fixed: Default order by not working if "Allow ordering?" is disabled in a publication (Steve) |
| 381 |
Fixed: Column search box shown for hidden columns in responsive mode (Charles) |
| 382 |
Fixed: Repository issues with multi site installation |
| 383 |
Fixed: Wildcard search on Data Explorer main page not correctly stored |
| 384 |
Fixed: Do not use the plugin transaction settings for plugin tables |
| 385 |
Fixed: Inline editing does not correctly support double (Mark) |
| 386 |
Fixed: Cannot use double quotes in advanced table options |
| 387 |
Fixed: Bulk export remote database tables not working |
| 388 |
Remove: jQuery.url() from publication |
| 389 |
|
| 390 |
#### 4.1.3 / 2021-01-29 |
| 391 |
|
| 392 |
Patch: Float and double datatypes not taken into account (Dennis) |
| 393 |
|
| 394 |
Changed: Message "Not authorized" to "Token expired or not authorized" |
| 395 |
Added: New lookup type: auto complete (Steve) |
| 396 |
Added: Responsive Data Forms project menu |
| 397 |
Added: Option page length = 5 to show entries listbox |
| 398 |
Fixed: Cannot enter numeric data (dennistennis) |
| 399 |
Fixed: Wrong path in wpdadiehard premium when free version is uninstalled (Paul) |
| 400 |
Fixed: Cannot access remote database in Data Forms |
| 401 |
Fixed: Shortcode wpdadiehard returns error in editor |
| 402 |
Fixed: Disable selector on first column|plus icon |
| 403 |
Fixed: Support filter arguments in Data Forms (Andrew) |
| 404 |
Fixed: Lookup value not shown in responsive columns (Barbara) |
| 405 |
Fixed: Column label of hyperlink switched (Barbara) |
| 406 |
Fixed: Replaced TODO with a proper error message |
| 407 |
Fixed: Cannot add hyperlinks containing spaces to Project Template |
| 408 |
Fixed: Spaces in dynamic hyperlinks not preserved |
| 409 |
Fixed: Display items as read-only in view mode (Barbara) |
| 410 |
|
| 411 |
#### 4.1.1 / 2021-01-14 |
| 412 |
|
| 413 |
Updated: Help links |
| 414 |
Changed: Filter bar remains expanded when search values were entered (Steve) |
| 415 |
Fixed: Error WPDA_Settings.php on line 4022 (lrydant) |
| 416 |
Added: Support macros in advanced hyperlinks (IF-THEN-ELSE) |
| 417 |
Fixed: Hide dynamic hyperlinks when URL is empty (Barbara) |
| 418 |
Fixed: Hidden not null date column blocks update |
| 419 |
|
| 420 |
#### 4.1.0 / 2021-01-06 |
| 421 |
|
| 422 |
Patched: Removed projects tab which gave an error on some installations (Kyle) |
| 423 |
Patched: Plain text hyperlinks not shown in Data Forms (Barbara) |
| 424 |
|
| 425 |
Updated: Read me |
| 426 |
Updated: Language files |
| 427 |
Fixed: Numeric precision (Hermann) |
| 428 |
Fixed: Shortcode wpdadiehard does not use default order by (Barbara) |
| 429 |
Fixed: No error message shown on update or insert (Steve) |
| 430 |
Fixed: Default value set column type not working (Barbara) |
| 431 |
Fixed: Allow to update not null columns which already contain an empty string (Andrew) |
| 432 |
Improved: Error handling CSV import |
| 433 |
Fixed: Criteria added with wpda_search_column_ are not decoded in publications |
| 434 |
Moved: Manage Table Options to Project Templates |
| 435 |
Data Forms: Allow anonymous access role is empty |
| 436 |
Data Forms: Added field validation before saving data |
| 437 |
Data Forms: Added min|max validation for numeric fields |
| 438 |
Data Forms: Added default value support |
| 439 |
Data Forms: Added export buttons |
| 440 |
Data Forms: Added hyperlink management |
| 441 |
Data Forms: Added debug mode |
| 442 |
Data Forms: Added validation on min|max values of numeric fields |
| 443 |
Data Forms: Added validation on maximum length of text fields |
| 444 |
Data Forms: Added tooltips |
| 445 |
Data Forms: Added media library support |
| 446 |
Data Forms: Added static|dynamic hyperlinks (Barbara) |
| 447 |
Data Forms: Added full support for many to many relationships |
| 448 |
Data Forms: Added previous|next row navigation (Vincent) |
| 449 |
Fixed: Exception in foreach in Data Forms WS |
| 450 |
Fixed: Modsecurity blocking schema_name - renamed schema_name to wpdaschema_name (Andrea) |
| 451 |
|
| 452 |
#### 4.0.1 / 2020-12-04 |
| 453 |
|
| 454 |
Patch: CSV import does not work with empty dates |
| 455 |
Patch: Default values not added to hidden columns |
| 456 |
|
| 457 |
Fixed: Copy shortcode wpdataaccess returning wrong shortcode |
| 458 |
|
| 459 |
#### 4.0.0 / 2020-12-03 |
| 460 |
|
| 461 |
Update: jQuery and jQuery UI to prepare for WordPress 5.6 and 5.7 |
| 462 |
Update: Implode usage - deprecated message in 7.4 (Kooyaya) |
| 463 |
Added: Define default database per user (Charles) |
| 464 |
Changed: Improved remote database error handling |
| 465 |
Updated: jQuery DataTables responsive library and style |
| 466 |
Updated: jQuery UI darksness theme (used in data entry forms) |
| 467 |
Added: Allow users to map CSV to tables in other (remote) databases (Charles) |
| 468 |
Fixed: Default order by desc on child table not working (Jim) |
| 469 |
Fixed: Search returns no result when criteria contains a quote (wwdz + Charles) |
| 470 |
Fixed: Default order by for child table does not allow to reorder on other columns (Robert) |
| 471 |
Updated: Readme |
| 472 |
Updated: Freemius library |
| 473 |
Fixed: Order by clause not working when column name starts with "order" (Nanne) |
| 474 |
Added: Data Forms (beta) |
| 475 |
|
| 476 |
Patched: Column headers not visible in export (Charles) |
| 477 |
Patched: Broken link (what's new) |
| 478 |
Patched: Column values in dynamic hyperlinks are not substituted in publication if the column is not selected (Charles) |
| 479 |
Patched: Dates not correctly imported from csv if not matching the exact format (Erwin) |
| 480 |
|
| 481 |
#### 3.6.5 / 2020-10-14 |
| 482 |
|
| 483 |
Patched: Column headers not visible in export (Charles) |
| 484 |
Patched: Broken link (what's new) |
| 485 |
Patched: Column values in dynamic hyperlinks are not substituted in publication if the column is not selected (Charles) |
| 486 |
Patched: Dates not correctly imported from csv if not matching the exact format (Erwin) |
| 487 |
|
| 488 |
Added: Parameters wpda_search_placeholder_prefix and wpda_search_placeholder to format search box (Charles) |
| 489 |
Added: Row level access control (Fedi) |
| 490 |
Fixed: Added column alias to prevent case sensitive column nam errors |
| 491 |
Fixed: Date format not taken into account (Erwin) |
| 492 |
Removed: Local version of clipboard library (using WordPress library) |
| 493 |
Updated: Freemius library |
| 494 |
Fixed: Spaces in dynamic hyperlink arguments not working (Richard) |
| 495 |
Fixed: Uninstall settings not working if not specifically saved |
| 496 |
Added: Select individual columns individual search per column (Moshe) |
| 497 |
Added: Filter argument to filter wpda_column_default to support priorities (Anastasiia) |
| 498 |
Fixed: CSV import paging and searching not working (Moshe) |
| 499 |
Added: Define dynamic hyperlink labels in Data Publisher (Charles) |
| 500 |
Changed: Buttons in publication header in separate row (Charles) |
| 501 |
Fixed: Listbox error in Data Publisher if field value contains quote (Lorelei) |
| 502 |
Changed: Publication columns are now nowrap by default |
| 503 |
Added: Classes to search textbox, listbox and icons (for Charles) |
| 504 |
Added: Recursive option conversion to Data Publisher to support functions on all levels |
| 505 |
|
| 506 |
#### 3.6.0 / 2020-09-12 |
| 507 |
|
| 508 |
Added: Parameter wpda_search_placeholder_prefix to change the placeholder |
| 509 |
Changed: Data Publisher no longer requires granting table access |
| 510 |
Added: New column type ImageURL (auto convert image url to img tag) |
| 511 |
Fixed: CSV import not working with unicode characters (Moshe) |
| 512 |
Fixed: SSL support (Rene) |
| 513 |
Fixed: Delete csv import not working (Mike) |
| 514 |
Added: Default order by to Data Projects main page (for Andrea) |
| 515 |
Added: Search box to premium Data Publisher (header|footer) (Charles) |
| 516 |
Updated: Disable caching for all javascript ajax calls |
| 517 |
Removed: Message "Auto-updates are not available for this plugin" |
| 518 |
Fixed: Support Form menu is added to WP Data Access menu of non admin users (Anna) |
| 519 |
Removed: Website link from plugin list |
| 520 |
Fixed: Export from wpdadiehard not working for anonymous users |
| 521 |
Fixed: Data Project JS library not found in shortcode wpdadiehard |
| 522 |
Fixed: wp_enqueue_script( 'wpdadiehard' ); returns errors in WP 5.5 |
| 523 |
Added: Export buttons to Data Publisher (premium version only) |
| 524 |
Added: Use WordPress date and time format in publications (Lorelei) |
| 525 |
Fixed: Premium search filter priority not working correctly (Charles) |
| 526 |
|
| 527 |
#### 3.5.0 / 2020-08-17 |
| 528 |
|
| 529 |
Updated: Dutch translation |
| 530 |
Added: Shortcode arguments to filter wpdadiehard (forum support - Jack) |
| 531 |
Fixed: inline editing checkbox uses tinyint, must be tinyint(1) |
| 532 |
Fixed: checkbox set to null when disable, should be 0 to support not null (forum support - kooyaya) |
| 533 |
Fixed: load-scripts.php error in WP 5.5 |
| 534 |
Removed: publication test from list table (remains available from data entry form) |
| 535 |
Added: query ui darkness images to prevent 404 |
| 536 |
Removed: page arguments from public web pages (shortcode wpdadiehard) |
| 537 |
Added: disable auto-updates in WordPress 5.5 |
| 538 |
Fixed: wpda_search_column_ values lost after re-order (forum support - Mark) |
| 539 |
Changed: show more|less button label |
| 540 |
Fixed: Data Publisher does not use dynamic filter arguments: wpda_search_column_ (forum support Mark) |
| 541 |
Fixed: cannot export view to csv (forum support mrams93) |
| 542 |
Fixed: cannot redeclare submit_button (forum support - Allen) |
| 543 |
Added: publication name to shortcode (forum support - Andrew) |
| 544 |
Added: sort icons selection from Data Publisher |
| 545 |
Fixed: added permanently delete message to bulk actions buttons |
| 546 |
Added: allow to drop views from bulk actions menu |
| 547 |
Changed: shorter button labels (support forum - Lawrence) |
| 548 |
Fixed: searching, ordering and paging disabled for publication without pub_id |
| 549 |
Added: parameter nl2br to shortcode wpdataaccess to convert New Lines to BR tags (forum support - Howard) |
| 550 |
Added: notify library to show interactive notifications |
| 551 |
Added: material icons to buttons and tabs |
| 552 |
Added: more help and info icons to improve usability |
| 553 |
Added: jQuery tooltips to help and info titles |
| 554 |
Added: freemius library to support premium plugin version |
| 555 |
|
| 556 |
#### 3.1.5 / 2020-07-05 |
| 557 |
|
| 558 |
Updated: Dutch translation |
| 559 |
Fixed: Table settings hyperlink column id and name not unique |
| 560 |
Fixed: Change image width to 100% (forum support - Chiara) |
| 561 |
Fixed: Export button in Data Explorer not working |
| 562 |
Added: Option to Data Publisher to convert NL to BR (forum support - Howard) |
| 563 |
Fixed: Month in date field changes on mousewheel event (Michiel) |
| 564 |
Added: Shortcode arguments to filter publication (forum support - Howard) |
| 565 |
Fixed: Screen options (again!) |
| 566 |
Fixed/Added: One click export for Data Projects including all option sets |
| 567 |
Added: CSV upload table to plugin table array (Michiel) |
| 568 |
Added: Disable attribute to filter wpda_add_column_settings |
| 569 |
Added: Filter wpda_column_default to first column |
| 570 |
Fixed: Apply plugin date format to primary key columns |
| 571 |
Fixed: Allow lookup on first column in list table |
| 572 |
Fixed: Cookie samesite warning |
| 573 |
Fixed: Removed iframes from project |
| 574 |
Fixed: Show text only if hyperlink column does not contain a URL on frontend (forum support - Howard) |
| 575 |
|
| 576 |
#### 3.1.4 / 2020-06-22 |
| 577 |
|
| 578 |
Fixed: Some sanitization issues |
| 579 |
Added: Show text only if hyperlink column does not contain a URL (forum support - Howard) |
| 580 |
Added: Custom items to search |
| 581 |
Fixed: Hidden columns not available in default where construction |
| 582 |
Fixed: Use option set default is named option set is not found |
| 583 |
|
| 584 |
#### 3.1.3 / 2020-06-15 |
| 585 |
|
| 586 |
Added: Disable hyperlinks on list tables in Data Projects (parent/child) |
| 587 |
Fixed: Export not available on web pages using wpdadiehard |
| 588 |
Fixed: Responsiveness not working with shortcode wpdadiehard (forum support - nmarlon) |
| 589 |
Fixed: Back to parent list button not working (forum support - alevel) |
| 590 |
Fixed: API doc missing package WPDA_Roles |
| 591 |
Fixed: Search not remembered in list tables |
| 592 |
|
| 593 |
#### 3.1.2 / 2020-05-25 |
| 594 |
|
| 595 |
Fixed: ERROR: Wrong arguments [missing WPDA_PARENT_KEY*?] (Michiel) |
| 596 |
Added: Added actions and filters to allow custom settings in Data Projects |
| 597 |
Added: Show column of data type SET as CSV, UL or OL in list table (see plugin settings) |
| 598 |
Added: Hide ID in lookup list (forum support - hhagmxeu) |
| 599 |
Fixed: Remove Add New button when insert is set to NO (forum support - hhagmxeu) |
| 600 |
Updated: Original WP_List_Table WordPress class |
| 601 |
Added: Add help link to list table and data entry form titles |
| 602 |
Fixed: Invalid table open tag |
| 603 |
Fixed: Data Publisher does not accept blanks in column names (forum support - neiljw) |
| 604 |
Fixed: Need to remap when switching file type (CSV <> TSV) |
| 605 |
|
| 606 |
#### 3.1.1 / 2020-05-08 |
| 607 |
|
| 608 |
Fixed: Error when clicking on child tab in Data Project (forum support #12790240 - maverjk) |
| 609 |
Fixed: CSV repository table not created during update (forum support #12728343 - tobiaseigen) |
| 610 |
Fixed: Showing all tinyint columns should as checkboxes (forum support #12785271 - mikefoley) |
| 611 |
Fixed: Disable bulk actions has no effect on shortcode (works correctly in dashboard) |
| 612 |
|
| 613 |
#### 3.1.0 / 2020-05-05 |
| 614 |
|
| 615 |
Fixed: Check page mode against action on Data Project pages |
| 616 |
Fixed: Data Designer – New table – Collation not working? (forum support #12597488 - Mattia Roccoberton) |
| 617 |
Added: Allow json as well as plain text hyperlinks (defined in table settings) |
| 618 |
Changed: Plugin page titles and layout more consistent |
| 619 |
Removed: Tutorials and examples (now available on plugin website) |
| 620 |
Changed: Data entry form layout |
| 621 |
Added: Add table to user dashboard menu for non admin users |
| 622 |
Added: Upload, map and import CSV files into an existing table |
| 623 |
Added: Hook wpda_before_list_table to add code before a list table |
| 624 |
Renamed: Hook wpda_extend_simple_form to wpda_after_simple_form |
| 625 |
Renamed: Hook wpda_prepend_simple_form to wpda_before_simple_form |
| 626 |
Renamed: Hook wpda_extend_list_table to wpda_after_list_table |
| 627 |
Added: Handle to list table instance to hook wpda_extend_list_table |
| 628 |
Added: Handle to simple form instance to hook wpda_extend_simple_form |
| 629 |
Added: Handle to simple form instance to hook wpda_prepend_simple_form |
| 630 |
Changed: Improved naming convention of actions and filters |
| 631 |
Added: "Add New" button to simple form title (forum support #12404331 - merlinsilk) |
| 632 |
Fixed: Lookup multiple column not shown correctly in table options |
| 633 |
Fixed: Date and time picker not available for child tables (Ivan) |
| 634 |
Added: Disable import on Data Projects page |
| 635 |
Added: Disable bluk actions on Data Projects page (forum support #12612463 - Wolter) |
| 636 |
Added: Define when hyperlinks are shown on a responsive modal window (Miguel) |
| 637 |
Fixed: Plugin allows import on Data Projects pages with insert disabled |
| 638 |
Fixed: Value 0 for sequence number in project and project pages missing in export |
| 639 |
Fixed: Table settings stored incorrectly after opening multiple table settings |
| 640 |
Fixed: Settings tables are not exported with {wp_prefix} |
| 641 |
Fixed: Dynamic hyperlinks not exported with table settings |
| 642 |
Fixed: Cannot use non primary columns in parent in relationships (forum support #12591142 - trebair) |
| 643 |
Removed: Donation and review links from plugin description |
| 644 |
Changed: Order of plugin menu items |
| 645 |
Updated: Plugin readme content |
| 646 |
Fixed: Cannot create dynamic hyperlink (forum support #12586657 - mdurao) (patched) |
| 647 |
|
| 648 |
#### 3.0.3 / 2020-03-26 |
| 649 |
|
| 650 |
Added: Allow lookups to other databases (including remote databases) |
| 651 |
Added: Checkbox support for tinyint columns |
| 652 |
Added: Dynamic hyperlinks to table settings |
| 653 |
Added: New filter wpda_wpdataaccess_prepare |
| 654 |
Added: Two new action hooks wpda_add_search_actions and wpda_add_search_filter |
| 655 |
Fixed: Remote relationships not displayed |
| 656 |
Fixed: Publication now really responsive when Number Of Columns = 0 |
| 657 |
Fixed: User must save design before table can be created (forum support #12558071 - holowkass) |
| 658 |
|
| 659 |
#### 3.0.2 / 2020-03-10 |
| 660 |
|
| 661 |
Added: JSON validation to table options advanced column in Data Publisher |
| 662 |
Added: Show search box on empty list |
| 663 |
Added: Hook wpda_prepend_table_settings to add table settings at the beginning of the table settings section |
| 664 |
Added: Hook wpda_append_table_settings to add table settings at the end of the table settings section |
| 665 |
Added: Hook wpda_wpdadiehard_prepare to add preparation code to shortcode wpdadiehard |
| 666 |
Added: Plugin class to jQuery DataTables to simplify styling (no css added in plugin) |
| 667 |
Added: Filter wpda_get_column_headers to add custom labels to screen options |
| 668 |
Changed: No data from “Test Publication” (forum support #12520792 - Dave) |
| 669 |
Fixed: Not possible to enter null dates (forum support #12515913 - Melody) |
| 670 |
Fixed: Labels and icons not correctly aligned in data entry forms |
| 671 |
Fixed: Cannot manage system views in Data Explorer |
| 672 |
Fixed: ERROR: Wrong arguments [missing primary key value] (forum support #12487390 - flazza87) |
| 673 |
Fixed: Comparing with translated table_type gives wrong results |
| 674 |
Fixed: Textarea editable in view mode (forum support #12461671 - charlesgodwin) |
| 675 |
|
| 676 |
#### 3.0.1 / 2020-02-19 |
| 677 |
|
| 678 |
Patch: Added textarea support for all text columns (tinytext, text, mediumtext, longtext) |
| 679 |
Patch: Table settings are not updated correctly if the settings have been changed between version 3.0.0 and 3.0.1 |
| 680 |
Added: Filter wpda_add_column_settings to Data Explorer column settings |
| 681 |
Added: Action hook 'wpda_default_screen_option' to support default screen option settings |
| 682 |
Changed: Simplified layout table settings |
| 683 |
Fixed: Order by publication needs manual overring stateSave setting |
| 684 |
Fixed: Reset form to add a record does not work (forum support #12404331 - merlinsilk) |
| 685 |
Fixed: Export/import {wp_schema} if schema name = wordpress schema || '' (transfer repositories) |
| 686 |
Fixed: Manage table window in Data Explorer not using full width |
| 687 |
Fixed: Frontend table view doesn’t work in IE11 (forum support #12397113 - peterdietz) |
| 688 |
Fixed: Favourites class dies with wrong schema_name in url |
| 689 |
Fixed: Cannot save remote database (forum support #12391185 emma26) |
| 690 |
Fixed: User roles removed on profile change when plugin role management is enabled |
| 691 |
Fixed: Class ‘WPDataProjects\Parent_Child\WPDA_Message_Box’ not found (form post #12399837 - mitfi) |
| 692 |
Fixed: Error on trying to add any table to PROJECTS (form post #12385381 - aa11plus) |
| 693 |
|
| 694 |
#### 3.0.0 / 2020-01-30 |
| 695 |
|
| 696 |
Fixed: Column name in DataTable class gone |
| 697 |
Added: Action hook 'wpda_extend_list_table' to support list table extension |
| 698 |
Added: Filter wpda_column_default to influence column layout in list tables |
| 699 |
Added: New media types to Data Publisher |
| 700 |
Fixed: Function wpdadiehard_convert_to_screen() not found (form post #12362969 - charlesnguyen) |
| 701 |
Added: Full remote database support to Data Backup |
| 702 |
Fixed: Search context lost on web pagel |
| 703 |
Added: Support for $$USER$$ and $$USERID$$ to Data Publisher (form post #12352968 - Dozen) |
| 704 |
Added: Use second, third, nth column in lookup to build where clause (change request - mieke van kooten) |
| 705 |
Added: Support for media files of type video (play inline) |
| 706 |
Added: Support for media files of type music (play inline) (form post #12258885 - dizwell) |
| 707 |
Fixed: Media files not shown correctly after upload from WordPress media page |
| 708 |
Fixed: Data Publisher gives an error when "Allow paging?" = NO |
| 709 |
Added: Text columns are now shown in a textarea (multi line) instead of an input element |
| 710 |
Added: Info to the Data Publisher how to authorise tables |
| 711 |
Added: Allow registration only > project page > allow insert = only (no list table, update, delete, import) |
| 712 |
Added: Allow Data Project to insert only (no update, delete, import) (website comment database administration - jeffrey turner) |
| 713 |
Added: Allow functions to be used in Data Publisher advanced table options (forum support #12332715 - marcellein) |
| 714 |
Fixed: Layout messes up when using multiple columns in a relationship |
| 715 |
Added: Filter to user search (WPDA_List_Table->construct_where_clause) (forum support #12315718 - charlesgodwin) |
| 716 |
Added: Allow to hide plugin menu in dashboard (does not hide data projects) |
| 717 |
Changed: Moved plugin settings page to dashboard settings menu |
| 718 |
Added: Context sensitive help to plugin pages |
| 719 |
Removed: Plugin help from menu |
| 720 |
Added: Manage remote databases from Plugin Settings |
| 721 |
Added: Full remote database support to Data Designer |
| 722 |
Added: Test publication directly from Data Publisher main page |
| 723 |
Added: Copy publication link to Data Publisher (form post #12275882 - dizwell) |
| 724 |
Fixed: Change responsive type "collaped" to "collapsed" (form post #12275882 - dizwell) |
| 725 |
Added: Screen options now also available in Data Projects |
| 726 |
Fixed: WHERE Clause in Data Publisher only works with equals (=) (form post #12301684 - philippkaiser) |
| 727 |
Fixed: DB_NAME in wp-config.php does not match real database name (lower_case_table_names = 1) |
| 728 |
Fixed: Screen options not working correctly |
| 729 |
Changed: Improved layout test frame Data Publisher |
| 730 |
Added: Settings, review and donation links to plugin description |
| 731 |
Fixed: Do not use offset and limit if serverSide is false |
| 732 |
Fixed: Invalid Dropbox key |
| 733 |
Added: Full remote database support to Data Projects |
| 734 |
Added: Full remote database support to Data Publisher |
| 735 |
Added: Full remote database support to Plugin Settings pages |
| 736 |
Added: Full remote database support to Data Explorer |
| 737 |
Added: Manage remote databases from Data Explorer |
| 738 |
Changed: Menu item shows error page if repository table not found (instead of hiding menu item) |
| 739 |
Added: On drop table delete all table settings from repository (labels, media columns, menus) |
| 740 |
|
| 741 |
#### 2.7.3 / 2019-12-18 |
| 742 |
|
| 743 |
Added: Help info to advanced table options |
| 744 |
Added: Customize Datatables shortcode - adding standard and advanced options (form post #12236372 - rswebmaster) |
| 745 |
Fixed: Can’t seem to change the number of rows initially displayed (form post #12247152 - dizwell) |
| 746 |
Fixed: Cannot drop view in another database |
| 747 |
Changed: Listbox behaviour responsive output |
| 748 |
Fixed: Select listbox in Data Publisher not working correctly. |
| 749 |
Added: Default where and order by to child table (table options) (form post #12232151 - khansadi) |
| 750 |
Changed: Switched to new Dropbox app "WP Data Access Box" |
| 751 |
Added: Sort on multiple columns in Data Publisher (form post #12226580 - spounch) |
| 752 |
Changed: Layout simple form items to save space |
| 753 |
Changed: Decreased parent area on Data Projects pages (remove title + add less/more button) |
| 754 |
Added: External database support to WordPress media library columns |
| 755 |
Added: External database support to data menus |
| 756 |
Added: External database support to table settings |
| 757 |
Added: External database support to shortcode wpdadiehard |
| 758 |
Added: External database support to Data Projects |
| 759 |
Added: Table access control for external databases to Data Explorer |
| 760 |
Added: Table access control for external databases to plugin backend settings |
| 761 |
Fixed: Disabled select and format columns buttons in Data Publisher in view mode |
| 762 |
Changed: Removed WordPress table access options from Front-end Settings for external databases |
| 763 |
Fixed: Some buttons and actions available in Data Designer for WP tables and view mode |
| 764 |
Fixed: Added new line to end of export file to prevent error when importing as ZIP file |
| 765 |
Added: Create database from Data Explorer main page (forum post #11706835) |
| 766 |
Added: Drop database from Data Explorer main page (forum post #11706835) |
| 767 |
Fixed: Manage link in Data Explorer not working with system views |
| 768 |
Fixed: Sort not working without default order by (support forum #1219867 - @ssamyn) |
| 769 |
|
| 770 |
#### 2.7.2 / 2019-11-29 |
| 771 |
|
| 772 |
Added: Cookie settings (plugin settings page) to allow keeping cookies when switching panels |
| 773 |
Added: Arguments added to shortcode [wpdataaccess] database, sql_where, sql_orderby |
| 774 |
Added: Default WHERE/ORDER BY to publication (support forum #11907073 - @Gbade) |
| 775 |
Removed: Settings tab and alter table button from Data Explorer when connected to other database |
| 776 |
Added: Connect to other databases from Data Publisher (forum support #11706835 - steveediger) |
| 777 |
Added: Internationalisation to Data Publisher front-end (data publisher settings page) (forum support #12181966 - ssamyn) |
| 778 |
Updated: All html script tags to use text instead of language attribute |
| 779 |
Updated: Menu item link to plugin help |
| 780 |
Added: Allow shortcode access in posts and pages (plugin settings page) |
| 781 |
Added: Support custom date and time formats (plugin settings page) (form post #12123210 - dmnauta) |
| 782 |
Fixed: List tables not supporting responsive mode (forum support #12146070 - dsbking) |
| 783 |
Fixed: Tabpage not responding (forum support #12123137 - dmnauta) |
| 784 |
Added: Allow to export view to XML, JSON, Excel and CSV (forum support #12131944 - dsbking) |
| 785 |
Fixed: Listboxes not working correctly in Safari (forum support #12114671 - sander zumbrink) |
| 786 |
|
| 787 |
#### 2.7.1 / 2019-10-10 |
| 788 |
|
| 789 |
Fixed: Do not show version update notification when page called from shortcode |
| 790 |
Fixed: Ask user for confirmation on copy table options set |
| 791 |
Fixed: Make text "back to list" more specific on parent/child pages |
| 792 |
Fixed: User should confirm when pressing the Reconcile Table button |
| 793 |
Fixed: Error on lookup if item value is null |
| 794 |
Fixed: Warning creating default object from empty value when entering tab_label first time |
| 795 |
Fixed: Plugin table Settings not used if no table options found for Data Projects table |
| 796 |
Fixed: Column labels are not taken into account in exports (CSV and Excel) |
| 797 |
Fixed: Role selection in Data Menus should show the role label not the role |
| 798 |
Fixed: Role selection in Data Projects should show the role label not the role |
| 799 |
Fixed: Cannot change Options Set Name (forum support #12099274 - mieke van kooten) |
| 800 |
Fixed: Shortcode wpdadiehard returns an error if convert_to_screen is already declared (forum support #12084970 - kirkgroome) |
| 801 |
|
| 802 |
#### 2.7.0 / 2019-10-31 |
| 803 |
|
| 804 |
Added: Support role checking in shortcode wpdadiehard (data management on web pages) |
| 805 |
Added: CSS class to DataTables (class name = database column name) |
| 806 |
Fixed: Move back to list after adding an existing record for an n:m relationship |
| 807 |
Fixed: Updated for WordPress 5.3 and 5.4 |
| 808 |
Fixed: Changed wp_die call to work properly in WordPress 5.4 |
| 809 |
Fixed: Data Designer listboxes not showing correctly in WordPress 5.4 |
| 810 |
Fixed: Width select item not showing correctly in WordPress 5.4 |
| 811 |
Fixed: Generated HTML media listbox wrong format |
| 812 |
Fixed: Input item of type text not showing correctly in WordPress 5.4 |
| 813 |
Added: Copy table options to new set |
| 814 |
Added: Support for multiple table options sets |
| 815 |
Fixed: Cannot use lookup in list table as first column |
| 816 |
Moved: WPDA_Design_Table_Model and WPDP_Project_Design_Table_Model to Plugin_Table_Models |
| 817 |
Fixed: PHP error for incorrect n:m relationship |
| 818 |
Removed: Media columns from Data Projects (media columns now supported in table settings only) |
| 819 |
Removed: Media columns from Data Publisher (media columns now supported in table settings only) |
| 820 |
Added: Dynamic hyperlink to list table (review wmuskie | forum support #12038786 - OriOn) |
| 821 |
Added: Button "Add New" child record always visible (website comment known limitations - mieke van kooten) |
| 822 |
Changed: Label SHOW MORE/LESS button |
| 823 |
Added: $$USERID$$ environment variable (forum support #12022533 - docwatsons) |
| 824 |
Added: WordPress role management to allow multiple rows per user |
| 825 |
Fixed: Select/deselect all rows for bulk actions not working for shortcode wpdadiehard |
| 826 |
Changed: Rename Data Projects menu slug and file names from wpdp to wpda |
| 827 |
Added: Export table settings with table (SQL export only - selectable) |
| 828 |
Fixed: Page type table using wrong classes in shortcode wpdadiehard |
| 829 |
Removed: Project ID column from Data Project page list tables |
| 830 |
Added: Show shortcode action Data Projects page list table |
| 831 |
Changed: Column order on Data Projects page |
| 832 |
Fixed: Disable autocomplete for data/time columns |
| 833 |
Fixed: $$USER$$ filter not working in shortcode (forum support #012022533 - docwatsons) |
| 834 |
Fixed: Plugin backup tables not deleted on plugin removal |
| 835 |
Fixed: On plugin activation backup plugin tables only for a new version |
| 836 |
|
| 837 |
#### 2.6.1 / 2019-01-04 |
| 838 |
|
| 839 |
Fixed: Data type attribute not taken into account in Data Designer |
| 840 |
Fixed: jQuery DataTables auto width calculation removed |
| 841 |
Changed: Renamed Data Projects table prefix from wpdp to wpda |
| 842 |
Removed: Const OPTION_WPDA_PREFIX (no functionality) |
| 843 |
Removed: Const OPTION_WPDA_NAME (never used) |
| 844 |
Fixed: Table wp_wpda_table_settings not removed on uninstall (forum support #11970313 - soprano) |
| 845 |
Fixed: Tab labels not set correctly when using shortcode |
| 846 |
Fixed: Message box not shown when using shortcode |
| 847 |
Fixed: jQuery datetimepicker not available when using shortcode |
| 848 |
Fixed: $wp_user->data->user_login not set for anonymous user (no login) |
| 849 |
Fixed: Add New button shown when parent-child form in view mode |
| 850 |
Fixed: Two back buttons show in view mode for child rows |
| 851 |
Fixed: Delete action available for child rows even in view mode |
| 852 |
Fixed: Column ordering in Data Projects not using table options |
| 853 |
Fixed: Error $actions is not an array if batches are disabled |
| 854 |
Fixed: Button SHOW LESS/SHOW MORE not shown on web page |
| 855 |
Added: Action hook 'wpda_extend_simple_form' to support form extension |
| 856 |
Changed: Allow plugin folder dir to be overwritten to improve support for inheritance |
| 857 |
Changed: Reference self to static to improve support for inheritance |
| 858 |
Changed: Cursor type when dragging and dropping element |
| 859 |
|
| 860 |
#### 2.6.0 / 2019-09-18 |
| 861 |
|
| 862 |
* Updated: Dutch language translation |
| 863 |
* Added: Quick tours Data Publisher and Data Projects (support forum #11794759 - merlinsilk) |
| 864 |
* Changed: Menu item Plugin Help opens external public page in new tab/window |
| 865 |
* Changed: Moved documentation to public website |
| 866 |
* Fixed: Numeric fields do not allow negative values (support forum #11892289 - wpsd2006) |
| 867 |
* Changed: Disabled media column selection in Data Projects (moved to Data Explorer) |
| 868 |
* Fixed: Cannot delete page from Data Project (support forum - #11889053 - wpsd2006) |
| 869 |
* Changed: Default column label to first letter upper and rest lower for every word in label |
| 870 |
* Fixed: Confirm delete backup tables |
| 871 |
* Changed: Disabled media column selection in Data Publisher (moved to Data Explorer) |
| 872 |
* Added: Message if button Select is clicked in Data Publisher on insert (need to save first) |
| 873 |
* Fixed: Button Format Columns not working if format column is empty |
| 874 |
* Removed: Test publication link from Data Publisher list table |
| 875 |
* CLEANUP: Rewritten all plugin table models to use one base class |
| 876 |
* Added: Table model for plugin table wp_wpda_table_settings |
| 877 |
* Added: Plugin settings table to store table related settings |
| 878 |
* Changed: Simplified Data Menus structure |
| 879 |
* Moved: Data Menus to Data Explorer main page |
| 880 |
* Moved: Manage Media to Data Explorer main page |
| 881 |
* Moved: Data Backup menu to Data Explorer main page |
| 882 |
* Added: Filter parameter to shortcode wpdadiehard (support forum #11844079 - tritongr) |
| 883 |
* Fixed: Error on populating listbox when no tables selected in front-end settings (support forum #11844474 - rllopez66) |
| 884 |
* Fixed: Column labels Manage Media list table not correctly defined |
| 885 |
* Added: Plugin table and column settings to Data Explorer (work in progress) |
| 886 |
* Added: Date / Time picker to data entry forms |
| 887 |
* Fixed: Debian/MySQL8 sys table columns unordered without ordinal_position (support form #11820996 - jblakely) |
| 888 |
* Fixed: Debian/MySQL8 sys table columns in uppercase without alias (support form #11820996 - jblakely) |
| 889 |
* Added: Foreign keys to Table management on Data Explorer main page |
| 890 |
* Fixed: Error message on duplicate key (support form #1179998 - Merlin Silk) |
| 891 |
|
| 892 |
#### 2.5.1 / 2019-08-13 |
| 893 |
|
| 894 |
* Fixed: Font on web pages changed after updating to 2.5.0 (support forum #11814585 - bwhitemm and olbweb) |
| 895 |
* Added: Data Project pages are now available on web pages using shortcode 'wpdadiehard' |
| 896 |
|
| 897 |
#### 2.5.0 / 2019-08-02 |
| 898 |
|
| 899 |
* Removed: Bootstrap scripts and styles |
| 900 |
* Changed: Scripts and styles for shortcodes only loaded when needed |
| 901 |
* Changed: Scripts and styles for jQuery DataTables only loaded when needed |
| 902 |
* Added: Data management on web page (forum post #11694569) |
| 903 |
* Added: Use user defined title in project CRUD forms |
| 904 |
* Added: Support for column labels to Data Publisher |
| 905 |
* Added: Support for images to Data Publisher (forum post #11658244 - kentauron) |
| 906 |
* Added: Support for media items (forum post #11658244 - kentauron) |
| 907 |
* CLEANUP: Moved validation check to Simple_Form_Item (and sub classes) |
| 908 |
* CLEANUP: Removed JS templates to support older browsers |
| 909 |
* Changed: Updated JS/CSS versions for bootstrap, datatables and datatables responsive |
| 910 |
* Added: Use unique index for row actions if no primary key is defined in Data Explorer |
| 911 |
* Added: Drag and drop columns in Data Designer and Data Projects > Manage Table Options |
| 912 |
* CLEANUP: Allow sub classes of WPDA_Simple_Form_Item to handle specific column types |
| 913 |
|
| 914 |
#### 2.0.15 / 2019-07-08 |
| 915 |
|
| 916 |
* Added: Video tutorials for the Data Publisher tool |
| 917 |
* Added: Set WordPress username as default user $$USER$$ (support topic #11656471 - kentauron) |
| 918 |
* Fixed: Cascading delete on parent performs delete on child views |
| 919 |
* Fixed: Auto increment field shown as key=no and mandatory=no in Data Projects |
| 920 |
* Added: Show less/more button to parent form |
| 921 |
* Fixed: MariaDB 10.2.7 and higher handles default values different than other DBMSs (support topic #11675290 - smolenaar) |
| 922 |
* Fixed: Join USING not correctly handled on CentOS 7 MariaDB 10.3 (create project error finally solved!) |
| 923 |
* Added: Data Publisher tool (supports generation of shortcodes) |
| 924 |
* Removed: Shortcode button from visual editor |
| 925 |
* Fixed: Check if auto increment column is false (create project error?) |
| 926 |
* Fixed: Do not add auto increment column to insert (create project error?) |
| 927 |
* Added: Value for sql_mode to system info |
| 928 |
* Fixed: Updating failed error when saving a page that uses the plugin shortcode |
| 929 |
* Fixed: Label for primary key columns not showing correctly in project list tables |
| 930 |
* Added: Button to remove old backup tables (Manage Plugin > Manage Repository) |
| 931 |
* Fixed: Allow insert/delete not working for project pages |
| 932 |
* CLEANUP: Remove deprecated options |
| 933 |
* CLEANUP: Replace nobr tags with span + nobr class |
| 934 |
* CLEANUP: Language translation support |
| 935 |
* CLEANUP: Source code documentation |
| 936 |
* CLEANUP: API documentation |
| 937 |
* CLEANUP: Source code reformatted to WordPress standards |
| 938 |
|
| 939 |
#### 2.0.14 / 2019-06-08 |
| 940 |
|
| 941 |
* Changed: Import from Data Explorer main page is always allowed (admin user) |
| 942 |
* Added: Data Designer integrated with Data Explorer (alter table and indexes directly from Data Explorer) |
| 943 |
* Fixed: Cannot enter html characters in Simple Form text fields (support topic 11562559 - leouesb) |
| 944 |
* Added: Export from Data Explorer table page to XML, JSON, Excel and CSV (support topic 11565221 - rswebmaster) |
| 945 |
* Fixed: Error on delete parent when parent has lookups defined |
| 946 |
* Added: Reconcile button to Data Designer |
| 947 |
* Added: (re)Create index button to Data Designer |
| 948 |
* Added: Alter table button to Data Designer |
| 949 |
* Added: Drop index button to Data Designer |
| 950 |
* Added: Drop table button to Data Designer |
| 951 |
* Added: Show alter table script button to Data Designer |
| 952 |
* Added: Show create table script button to Data Designer |
| 953 |
* Added: Allow to show/hide deleted columns (compared with database table) |
| 954 |
* Added: Highlight new, deleted and modified columns in Data Designer |
| 955 |
* Added: Listbox to Data Backup to enable viewing all scheduled WordPress jobs |
| 956 |
* Added: Data Backup button to Data Explorer header |
| 957 |
* Changed: Uniform layout and behaviour for all buttons and links in page titles |
| 958 |
* Changed: Import title and info text (checks if zip upload is allowed) |
| 959 |
* Fixed: Export to csv deletes double quotes in text |
| 960 |
|
| 961 |
#### 2.0.13 / 2019-05-17 |
| 962 |
|
| 963 |
* Fixed: Database name containing minus character leads to query errors (support topic 11540179 - Prause) |
| 964 |
* Added: Export tables from Data Explorer to SQL (with(out) WP prefix), XML, json, Excel, csv files (support topic 11533487 - rswebmaster) |
| 965 |
|
| 966 |
#### 2.0.12 / 2019-05-14 |
| 967 |
|
| 968 |
* Updated: Plugin help pages |
| 969 |
* Added: Video tutorial to install the demo app |
| 970 |
* Fixed: Search on table with no search columns should show no rows |
| 971 |
* Fixed: Cannot search on lookup items |
| 972 |
* Fixed: Sorting on lookup columns is not possible (removed header link from table list) |
| 973 |
* Added: Check if file_uploads = On before upload (disable file upload if file_uploads = Off) |
| 974 |
* Fixed: Not correctly jumping back to list table source page after "Add Existing" > "search" |
| 975 |
* Fixed: Data Explorer main page shows all tables on show favourites only no favourites defined |
| 976 |
* Fixed: Export and Data Backup fail when memory_limit is too small |
| 977 |
* Added: Check file size against upload_max_filesize before uploading imnport file |
| 978 |
* Changed: Import now using streams to better support large files |
| 979 |
* Changed: Export and Data Backup now using streams to better support large files |
| 980 |
* Added: Log table to "Manage Repository" and "System Info" |
| 981 |
* Changed: Export procedure now writes seperate insert statement for every row |
| 982 |
* Fixed: Export/import procedures non WP schema performed on WP schema |
| 983 |
* Added: System info tab to improve and simplify plugin support and communication |
| 984 |
|
| 985 |
#### 2.0.11 / 2019-04-30 |
| 986 |
|
| 987 |
* Fixed: After editing a data record user always returns to page 1 (support topic 11476140 - Hannes - Decentris) |
| 988 |
* Fixed: Cannot add new page to project (support topic 11477423 - fendervr) |
| 989 |
* Added: Drop logging table on uninstall |
| 990 |
* Added: Possibility to save repository backup tables during a plugin update |
| 991 |
* Changed: Simplified repository (re)creation to decrease the possibility of failure |
| 992 |
* Fixed: Export files writes {wp_prefix}_ instead of {wp_prefix} |
| 993 |
* Fixed: View only list tables should not allow delete bulk actions |
| 994 |
* Fixed: Cannot search in list of values (search is performed on main list table) |
| 995 |
* Fixed: Site blocked after unattended plugin update (support topic 11472418 - tjgorman) (patched version 2.0.10) |
| 996 |
* Fixed: Class 'WPDataProjects\List_Table\WPDP_List_Columns_Cache' not found (patched version 2.0.10) |
| 997 |
* Fixed: Plugin table array removed from table cache (patched version 2.0.10) |
| 998 |
|
| 999 |
#### 2.0.10 / 2019-04-25 |
| 1000 |
|
| 1001 |
* Changed: Moved all security checks from menu preparation to page preparation |
| 1002 |
* Added: Data Backup now supports unattended (background/no browser) adhoc backups (support topic 11466155 - stevekatasi) |
| 1003 |
* Changed: Improved and simplified Data Backup procedure |
| 1004 |
* Fixed: Added WordPress database schema and plugin tables to cache (support topic 11461930 - stevekatasi) |
| 1005 |
* Fixed: Added cache to list column classes to increase database performance (support topic 11461930 - stevekatasi) |
| 1006 |
* Fixed: Optimized class WPDP_List_Table_Lookup due to bad performance issue (support topic 11461930 - stevekatasi) |
| 1007 |
* Fixed: Create table menu items fails for MySQL 5.6 and prior (support topic 11461174 - rswebmaster) |
| 1008 |
* Added: Demo project (app) WPDA_SAS - School Administration System |
| 1009 |
* Added: Code example how to use WP Data Access classes in PHP plugin code |
| 1010 |
* Fixed: Default and list-values imported without single quotes on Reverse Engineering (support topic 11423815 - Hannes - Decentris) |
| 1011 |
* Fixed: Data Projects export not working in FireFix (support topic 11429499 - Hannes - Decentris) |
| 1012 |
* Fixed: Submenus of data apps not shown correctly for roles null or empty string |
| 1013 |
* Changed: Export tables with variable wpdb prefix to support import into repository with different wpdb prefix |
| 1014 |
* Fixed: Set data type not handled correctly in the Data Designer (support topic 11423815 - Hannes - Decentris) |
| 1015 |
* Added: Explain how to define enum and list type in the Data Designer (support topic 11423815 - Hannes - Decentris) |
| 1016 |
* Fixed: Added latest version of WP_List_Table to project to reclaim navigation buttons |
| 1017 |
* Fixed: Submenus of data apps not shown correctly for roles other than administrator |
| 1018 |
* Fixed: WP table prefix not taken into account (support topic 11411195 - Hannes - Decentris) |
| 1019 |
* Fixed: Key column labels not displayed correctly in table list |
| 1020 |
* Added: A listbox is generated for lookup items in data entry forms |
| 1021 |
* Added: It is now possible to add a lookup column to a table list |
| 1022 |
* Added: Disable relationship and data entry form config for views and tables without a primary key (Data Projects) |
| 1023 |
* Added: Allow views and tables without a primary key to be used (Data Projects) |
| 1024 |
* Added: Allow to create relationships between tables and views (Data Projects) |
| 1025 |
* Added: Table type (TABLE,VIEW) to WPDA_Design_Table_Model (WPDP_Project_Design_Table_Model inherited) |
| 1026 |
* Fixed: Import script containing multiple SQL statements failed on Windows (using \r\n) |
| 1027 |
|
| 1028 |
#### 2.0.8 / 2019-02-05 |
| 1029 |
|
| 1030 |
* Added: Video tutorial to explain how to create many to many relationships in Data Projects |
| 1031 |
* Changed: Static content not correctly filtered |
| 1032 |
* Added: Make username accessible in where clause of project list tables |
| 1033 |
* Added: Where clause to project list tables to influence selection (parent only) |
| 1034 |
* Added: Support for MySQL set data type (listbox handling multiple selections) |
| 1035 |
* Added: Role (multiple) to data project pages to give non admin users access to data apps |
| 1036 |
* Changed: Content in list table wrapped (request from Enterprise Branding) |
| 1037 |
* Changed: What's new message now shown on all plugin pages |
| 1038 |
* Changed: Dropbox path now updatable |
| 1039 |
* Changed: Add / at the end of the backup folder name if not entered |
| 1040 |
|
| 1041 |
#### 2.0.7 / 2019-01-27 |
| 1042 |
|
| 1043 |
* Added: Data backup tool to automatically backup table data to a local folder or Dropbox folder |
| 1044 |
|
| 1045 |
#### 2.0.6 / 2018-12-16 |
| 1046 |
|
| 1047 |
* Added: Check number max size and precision in data entry forms |
| 1048 |
* Added: "Add New" button for parent in parent-child pages |
| 1049 |
* Added: Show list of available tables in data entry form for project>pages |
| 1050 |
* Fixed: Data Explorer manage table tabs not working correctly with multiple windows |
| 1051 |
* Changed: Allow to hide primary key columns in data entry forms |
| 1052 |
* Changed: Allow to hide primary key columns in table list |
| 1053 |
* Fixed: Hide columns not working in all data entry forms |
| 1054 |
* Fixed: Data Project table page: mode, title and subtitle not taken into account |
| 1055 |
|
| 1056 |
#### 2.0.5 / 2018-12-14 |
| 1057 |
|
| 1058 |
* Removed /themes/smoothness/jquery-ui.css from plugin admin class (shortcode button not working) |
| 1059 |
* Added: New screenshots to WordPress Plugin Directory |
| 1060 |
* Fixed: Export not working when "ask for confirmation when starting export" in settings is checked |
| 1061 |
* Changed: Tabs in list table (table actions) not working in Internet Explorer |
| 1062 |
* Changed: Links in list table not working in Internet Explorer |
| 1063 |
|
| 1064 |
#### 2.0.4 / 2018-12-11 |
| 1065 |
|
| 1066 |
* Changed: Plugin description in WordPress Plugin Directory |
| 1067 |
* Changed: Layout of the manage table window |
| 1068 |
|
| 1069 |
#### 2.0.3 / 2018-12-05 |
| 1070 |
|
| 1071 |
* Added: Optimize table from Data Explorer > manage table > actions tab |
| 1072 |
* Added: Hint user if table optimization should be considered |
| 1073 |
* Changed: Data menus was moved to Data Projects > Manage Dashboard Menus |
| 1074 |
* Added: Columns data size, index size and overhead to Data Explorer main page |
| 1075 |
* Added: Hide columns on Data Explorer mainpage |
| 1076 |
* Changed: Changed to order of the tabs in the manage table/view window |
| 1077 |
* Changed: Replaced icon to manage table of view with standard WordPress listtable link |
| 1078 |
* Changed: Changed import button text and labels for better understanding of import functionality |
| 1079 |
* Added: Video tutorial to explain how to create one to many relationships in Data Projects |
| 1080 |
|
| 1081 |
#### 2.0.2 / 2018-12-03 |
| 1082 |
|
| 1083 |
* Fixed: Removed subtitle from Data Designer and Data Menus list |
| 1084 |
* Added: What's new page to inform users about new features |
| 1085 |
* Added: First video tutorial to explain Data Projects tool |
| 1086 |
|
| 1087 |
#### 2.0.1 / 2018-11-27 |
| 1088 |
|
| 1089 |
* Fixed: Null values not exported correctly |
| 1090 |
* Fixed: Do not allow to hide mandatory columns in data entry forms |
| 1091 |
|
| 1092 |
#### 2.0.0 / 2018-11-09 |
| 1093 |
|
| 1094 |
* Added: Data Projects to plugin |
| 1095 |
* Create WordPress Data Apps |
| 1096 |
* Add app to dashboard menu |
| 1097 |
* Supports static pages |
| 1098 |
* Supports CRUD pages |
| 1099 |
* Supports parent/child pages |
| 1100 |
* Added: Documentation to plugin menu |
| 1101 |
* Fixed: Repository activation error |
| 1102 |
* Stopped: Website redirected to WordPress Plugin Directory |
| 1103 |
|
| 1104 |
#### 1.6.9 / 2018-03-20 |
| 1105 |
|
| 1106 |
* Fixed: Bulk actions not executed due to fix in 1.6.7 on favourites change |
| 1107 |
* Added: Show MySQL error when create table fails |
| 1108 |
* Changed: Prepared WPDA_Design_Table_Model to support transparent structures |
| 1109 |
|
| 1110 |
#### 1.6.8 / 2018-03-17 |
| 1111 |
|
| 1112 |
* Changed: Added new screenshots |
| 1113 |
* Fixed: Missing check unique column names and index names |
| 1114 |
* Fixed: Delete index in Data Designer not working |
| 1115 |
* Changed: Default mode Data Designer changed to advanced |
| 1116 |
|
| 1117 |
#### 1.6.7 / 2018-03-16 |
| 1118 |
|
| 1119 |
* Fixed: Switch to editing mode after create table/index in Data Designer |
| 1120 |
* Fixed: Prevent bulk selections being executed on favourites change |
| 1121 |
* Fixed: Multiple alerts on invalid bulk drop or truncate selection |
| 1122 |
|
| 1123 |
#### 1.6.6 / 2018-03-16 |
| 1124 |
|
| 1125 |
* Added: Copy table (including/excluding data) |
| 1126 |
* Added: Rename table/view |
| 1127 |
* Changed: Simplified usage of table/view/index actions from Data Explorer |
| 1128 |
|
| 1129 |
#### 1.6.5 / 2018-03-15 |
| 1130 |
|
| 1131 |
* Added: Drop index from Data Explorer |
| 1132 |
|
| 1133 |
#### 1.6.4 / 2018-03-14 |
| 1134 |
|
| 1135 |
* Fixed: Column 'Unique?' on 'Indexes' tab of Data Explorer always showing 'No' |
| 1136 |
|
| 1137 |
#### 1.6.3 / 2018-03-14 |
| 1138 |
|
| 1139 |
* Fixed: Create table not working |
| 1140 |
|
| 1141 |
#### 1.6.2 / 2018-03-01 |
| 1142 |
|
| 1143 |
* Fixed: Action button issues |
| 1144 |
* Fixed: Ask for confirmation on bulk-drop and bulk-truncate |
| 1145 |
* Fixed: Schema issues |
| 1146 |
|
| 1147 |
#### 1.6.1 / 2018-03-01 |
| 1148 |
|
| 1149 |
* Added: Allow ZIP file imports to support larger import files (uses ZipArchive) |
| 1150 |
|
| 1151 |
#### 1.6.0 / 2018-02-15 |
| 1152 |
|
| 1153 |
* Added: Create tables in basic or advanced mode (switch between modes) |
| 1154 |
* Added: Allow data and database administration of other schemas |
| 1155 |
* Added: Import table(s) button to Data Explorer (allows multiple imports) |
| 1156 |
|
| 1157 |
#### 1.5.2 / 2018-02-06 |
| 1158 |
|
| 1159 |
* Added: Check every request for plugin updates (compare db version with plugin version) |
| 1160 |
|
| 1161 |
#### 1.5.1 / 2018-02-03 |
| 1162 |
|
| 1163 |
* Added: Check #Rows ( perform count if #Rows < WPDA::OPTION_BE_INNODB_COUNT ) |
| 1164 |
|
| 1165 |
#### 1.5.0 / 2018-01-23 |
| 1166 |
|
| 1167 |
* Added: Engine field to Data Explorer |
| 1168 |
* Added: Number of records field to Data Explorer |
| 1169 |
* Added: Drop and bulk drop for views (accessible through icon in Data Explorer) |
| 1170 |
* Added: Bulk drop and bulk truncate for tables (accessible through icon in Data Explorer) |
| 1171 |
* Added: View table/view structure (accessible through icon in Data Explorer) |
| 1172 |
* Added: Option to backend settings to get default search value functionality (forget search value) |
| 1173 |
* Added: Support for parent detail navigation |
| 1174 |
* Added: Added argument 'allow_import' to WPDA_List_Table to hide import button |
| 1175 |
* Changed: Always show page 1 on new search |
| 1176 |
* Changed: Improved layout Simple Form |
| 1177 |
* Changed: Hide button 'Back To List' in view mode |
| 1178 |
* Removed: Menu WP Data Tables (replaced by favourites menu) |
| 1179 |
* Fixed: Current page selector not working |
| 1180 |
* Fixed: Check max length for input (attribute maxlength) |
| 1181 |
* Fixed: On expanding favourites table name not shown |
| 1182 |
* Fixed: Remember search value after navigating to details |
| 1183 |
* Fixed: WPDA_List_Table::construct_where_clause() not respecting values already in $this->where |
| 1184 |
* Fixed: Searching in favourites not working |
| 1185 |
* Fixed: Disable only form items in view mode |
| 1186 |
* Fixed: Argument 'show_view_link' has no effect |
| 1187 |
* Fixed: Argument 'allow_insert' has no effect |
| 1188 |
* Fixed: Back button in list table when called from data explorer or favourites |
| 1189 |
|
| 1190 |
#### 1.2.1 / 2018-01-14 |
| 1191 |
|
| 1192 |
* Fixed: Skip empty index on create table |
| 1193 |
* Fixed: Data entry form should showing CURRENT_TIMESTAMP as default value |
| 1194 |
* Fixed: Bulk checkboxes shown without bulk actions (tables export disabled) |
| 1195 |
* Fixed: List table favourites not showing labels when empty |
| 1196 |
|
| 1197 |
#### 1.2.0 / 2018-01-13 |
| 1198 |
|
| 1199 |
* Fixed: Recognize missing wp_wpda_table_design |
| 1200 |
* Fixed: Single file for every alter table stetement (wp_wpda_table_design) |
| 1201 |
* Added: Add tables to favourites (WP Data Tables still in menu but will be removed soon) |
| 1202 |
|
| 1203 |
#### 1.1.1 / 2018-01-13 |
| 1204 |
|
| 1205 |
* Fixed: Create table wp_wpda_table_design (older versions of mysql not supporting timestamp) |
| 1206 |
* Fixed: Hidden columns array returns false |
| 1207 |
|
| 1208 |
#### 1.1.0 / 2018-01-09 |
| 1209 |
|
| 1210 |
* Added: Data Designer |
| 1211 |
* Design tables and indexes |
| 1212 |
* Create tables and indexes from design |
| 1213 |
* Added: Drop table (from list table) |
| 1214 |
* Added: Truncate table (from list table) |
| 1215 |
* Fixed: Recognize all WordPress tables (single and multisite) |
| 1216 |
* Fixed: Link 'export' not showing in Data Explorer |
| 1217 |
|
| 1218 |
#### 1.0.0 / 2017-12-04 |
| 1219 |
|
| 1220 |
* Fixed: I can’t add table to menu (2017-12-29) |
| 1221 |
* Fixed: Activating the plugin affects styles on the front page (2017-12-29) |
| 1222 |
* Fixed: Sanitization error (2017-12-29) |
| 1223 |
* Initial commit |
| 1224 |
|
