+ Add custom color schemes to Data Publisher premium (Alex)

+ Is it possible to save table|view settings in the Data Explorer through ajax (no page refresh)? (Steve!)
+ Is it possible to show dashboard on web pages using a shortcode? (Matt)
+ When switching between different query types always force save before buttons can be used (Pascal)

*** MAIN SCHEDULE 2022 ***

+ Finish Data Forms V2

*** ISSUES ***

+ Search entire database for a string
+ Cannot import sample_test.csv with old CSV import feature
+ Add order by to LOV (Barbara)
+ Dashboards
  + Start cache update after sending response
+ Charles
  + Allow to override search features for publications:
    + Wildcard versus normal search
    + No search condition = show no rows
    + Allow column specific search
+ Two lookup autocomplete relationships with the same table, but referencing different fields, gives an error (Jay)
+ If wildcard search is enabled on numeric field, the plugin returns all rows on all searches
+ Tarik
  + Datetime column not handled as date in search builder
+ Add limit option to Data Projects (Jay)
+ Add radar chart (Niels)

+ Norman
  After adding a record in Data Forms, the modal window currently stays open. Can you add an option so that it eithers:
    a remains as is, open showing the record that was added
    b clears out the entered values so another entry can be made, saving time to closing and clicking the add button
    c close the modal window
+ Jay
  + Add details to master-detail export
+ Make queries from Query Builder available from:
  - Shortcodes
  - Publications
  - Sue > integration with phpdocx
+ Mieke
  + Make parent read-only and child updatable
+ Howard - csp issue
  + https://wordpress.org/support/topic/content-security-policy-breaks-wp-data-access/
  + https://observatory.mozilla.org/
  + https://hackdefense.nl/publicaties/csp-het-hoe-en-waarom-van-een-content-security-policy/
+ Disable premium dashboard access if not paid
+ CSV premium features
  + Update from CSV file (Mark Gibbs)
  + Add to Data Projects
  + The need is to import data from CSV in a shared table by different users (Robert)
    + For non-admin users
  + Add logging
  + Add auto mapping (match column names | case (in)sensitve | exact)
+ Use google maps json style declaration
  https://developers.google.com/maps/documentation/javascript/styling#specifying_styles_to_features
+ Improve Code Manager hints in PHP, JSON, HTML and JS editor (like SQL editor)
+ Add content editor support for TEXT columns (editor.js?)

*** REQUEST ***

+ Store image via Data Project in blob or on file system? (Lukasz)

*** BUGS ***

+ After updating a table design the user (sometimes) has to reconcile to reflect the real database table structure
+ Recreate repository not working as expected on WordPress multisite
+ Cannot not use Screen Options for child tables when having more than one child tabs
+ Data Project pages not editable when a remote host is down (solution: use ajax to fill listboxes; does this apply to other plugin pages as well?)
+ After adding new parent the child tab is not directly shown (Sebastian)

*** LONG TERM IMPROVEMENTS ***

+ Copy project page (Gaetan)
+ Remove all schema and table names from all/get requests
+ Problem exporting large table (Tony)
  Fatal error: Allowed memory size of 805306368 bytes exhausted (tried
  > to allocate 20480 bytes) in
  > /home/customer/www/leecountyhgs.org/public_html/wp-includes/wp-db.php
  > on line 2720
+ Allow to export all rows from a Data Projects page (Manivannan )
+ Support Classic Press? (Pauhana)

*** WORK IN PROGRESS ***

+ Priority
  + Add default values to Data Forms
  + Make a field read-only (Forum: rvwill48)
  + Add option to disable search in Data Projects (Jim Hunter)
  + Use WordPress|plugin date format in Data Publisher and Data Forms (Joseph + Barbara + Kennie)
  + Improve autocomplete in Data Forms
  + Geolocation > update location info on update/insert
  + In data Explorer, Manage, search columns, you cannot enable search check box if the column name has a space in it. The update does not change anything. (Charles)
    + Earlier I reported that Data Explorer->Manage->settings->search settings hung if there was a space in the column name.
      Today we learned that the same thing happens if there is a ’-‘ in the table name. For example catalogue-1r2 failed/hung but a rename to catalogue_1r2 worked just fine.

+ Requests
  + Map to multiple tables (Carl)
  + Data backup to CSV (@kfedorov)
  + Listboxes individual search not using lookup (if applicable) (Alex)
  + Allow users to add lookup values to non SQL exports in a Data Project (Kennie)
  + Define "No search result = show no rows" per page (Charles)
  + Is it possible to support relationships for view in project templates? (Steve)
  + Allow to add (1:n | n:m) relationships over multiple databases (Jeremy Gadd)
  + Make column name available in Data Publisher - for example function fnRowCallback (Cory - https://wpdataaccess.com/docs/documentation/plugin-settings/plugin/#comment-473)
  + Add WordPress user info to WPDADB connection (connect + reuse)
  + Add bulk edit support (Luis)

+ Improvements
  + Replace checks table|column exists with backticks (to improve performance)
  + Check for spaces and escape chars when converting schema, table and column names (JS does not support these character in IDs)
  + Check for wrong usage of schema_name (when used from WPDADB > use $wpdadb->dbname)
  + Isset - multiple at once
  + Add jQuery UI to publications
  + Update date picker to jQuery UI date picker
  + Move icon to first column for publications with buttons
  + Show only selected tables in Data Publisher for non admin users

+ Data Forms
  + LOV > unselect previously selected rows when popup is opened repeatively
  + Add custom button support
  + Add data import
  + The date format is YYYY-mm-dd no matter what is defined in the wp data access settings (Barbara)
  + Add advanced customizing
    + jQuery DataTables > options
      + Is there a possibility to change the database symbol at the end of a row? (Barbara)
    + Angular > extend controller
  + Check min|max on tinyint|smallint|mediumint|int|bigint not correct

+ Documentation
  + Default database schema per user
  + Filter option Data Projects
  + Default order by Data Projects
  + Video tutorial Data Forms
  + Video tutorial add Export buttons to publication

+ Ideas
  + Add PHP logger

---

+ Add premium videos
  + Advanced search (multiple)
  + Inline editing
  + Data Publisher
    + Adding buttons
    + Adding filters > add premium search
  + Data Projects
    + Adding filters
    + Adding inline editing
  + Data Forms
+ Update existing videos (how to use Project Templates)
+ Add videos to documentation
  + Data Backup tool
  + Data Explorer
  + Data Designer
  + Data Menus

+ Improve demos (show possibilities - premium + code manager)
+ Offer apps (FAQ, SAS, BAS)

+ Add support for computed columns (allow to use videos/images in slider/carousel from multiple media columns)
+ Add premium forms builder (dataforms, inline forms?)
+ Add premium report builder (list + single row display, both responsive)

+ Update documentation
+ Update readme (add premium features)
+ Update screenshots

+ Add media library to front-end (Nick)
+ Built layer around wpdb class to limit dcl, ddl and some dml access to admin users only
+ Load attachment in TEXT column to allow full-text indexing
+ Add remove remote database connection to documentation
+ Add Export to PDF to publication (support forum Danielle)
+ Add setting: allow only add existing + delete relationship on child tables for n:m relationship (Mieke)
+ Make parent readonly and child editable (forum support - larryhines)
+ Is it possible to add data to the relationship table in a n:m relationship (Michiel)
+ Use parent column value in child default where (forum support - bb-4)
+ Edit set with checkboxes instead of multi line listbox (Michiel)
+ Overwrite media in WordPress media library (Michiel)

+ Showing child rows in edit mode (single child with back-next buttons) (vincent)
+ Add forward/backward buttons to data entry forms related to selection in Data Explorer (form post #12275882 - dizwell)

+ Create unique element IDs for parent and child tables having the same column name
+ Capitalize text input (Wolter)
+ Change recreate repository button/action to repair repository
+ Allow to export view data from bulk actions menu (forum support #12131944 - dsbking)
+ Add awesome video tutorials on how to create a scheduled export (comment nacho)

*** RESEACRH ***

+ Use custom posts in a Data Project
+ Complex registration page (parent-child)
+ View building (including unique row identification)
+ Add new entry to lookup (Chiara)
+ Perform searching and sorting with ajax WPDA_List_Table (forum support #12470588 - sarveon)

*** NEXT & FEATURE REQUESTS ***

+ Search on date column (from-to) (forum: georg2791 - #12490607)
+ Display multiple lookup columns
+ Implement foreign keys in Data Designer
+ Implement compare in Data Designer
+ Use GET and POST vars (old and new) in default where (form post #12232151 - khansadi)
+ Add media to export for media columns
+ Disable edit mode for parent and enable mode for child (form post #11889053 - wpsd2006)
+ Nested lookup in ADD and EDIT page (review wmuskie) already done???
+ Number field formatting
  + Display a float number with 2 decimal places, or no decimal places etc.
  + For extra credit a way to display the integer 305623456 as 305-62-3456
  + A way to display leading 0s so 123 would display as 000123
+ Field formatting e.g. phone number, credit card (review wmuskie)
+ Create and modify views (support forum #11907073 - @Gbade)
+ Backup data to Google Drive and OneDrive
+ Improve table availability check on menu construction
+ Export posts related to static pages in data projects (id +  author)
+ Is it possible to add grid editing with DataTables as an add-on? (YES) (forum post #11660769)