• Compatibility with ADMIN-FORM 1.9.0
• NEW: ADD the possibility to insert multiple values in the lookup field
• IMPROVEMENT: Left join autocompletes now show only the actual values i.e. metavalues only show the values of the chosen metakey.
• FIXBUG: On select with left join if there are columns with the same name the query freezes and is annoying
• FIXBUG: on downloads it does not export the names of the columns taken from the list.

FIXBUG: (create list from query) fatal error in php 8.1+

• IMPROVEMENT: Improved page loading performance. The query to calculate the total number of records has been optimized and other queries have been eliminated.
• BUGFIX PRO: Always appear show all text even when query gives error.
• BUGFIX PRO: If a query gave error the double editor would appear!
• BUGFIX PRO: List export and subsequent import used to fail for complex queries or some types of fields, especially calculated fields which are now added to RAW export.

1.7.0 Fxibug

• FIXBUG: enabled multiqueries in the input form even for queries other than select
• FIXBUG: show full text appeared even when there were no results
• FIXBUG: when the query gave error happened that the editor appeared double
• IMPROVEMENT: Improved the response performance of a query by decreasing the instances of recalculating the total results extracted.

1.6.2 2023-02-09 Fixbug

• COMMIT Error

1.6.1 2023-02-09 Fixbug

• FIXBUG: When you edit a query and then cancel, it still runs the edited query
• FIXBUG: On SELECT DISTINCT queries add table ids showing inconsistent results

1.6.0 FIXBUG 22-01-2023
NEW: Added Time field and template engine attributes: timenum-to-timestr, timestr-to-timenum and time-to-hour
NEW (PRO) in the datapress main page added a box that shows the running queries and allows you to remove them
FIXBUG (PRO) show table in import data list
IMPROVEMENT: Limited metadata function. Metadata must be unique. There can be only one metadata for each meta_key. During the save if I find more metadata for the same key I delete them.
FIXBUG Added checking on date fields when they are invalid.
IMPROVEMENT: (TAB FORM) option in select: if there are no values I set them equal to the labels
IMPROVEMENT: Changed the default setting of the frontend of the tables.
IMPROVEMENT: Rebuild of post and user fields on lists. They now display the post title or the user's nicename. Search now works on user title or name instead of IDs. However, it is not possible to sort the list by a post or user field. This will not be developed because if you change the data type of the list the query will give an error.
FIXBUG: (page action=list-sql-edit) When I save it hides the primary keys in the lists.
FIXBUG: on import for user post and lookup fields
FIXBUG FRONTEND when you press enter and you have the focus on the search even if it is in ajax it sends the data in get
IMPROVEMENT: (LIST view formatting) On post and user type columns I no longer choose which information to show, it's always the title or username, but I've added the option to automatically create the link to the article or author's page. Attention this change generates a small incompatibility with previous versions. If you are using the post or user field check out the new functionality. If you wanted to link to other fields, use the lookup field instead.
IMPROVEMENT: (TAB FORM) the test of the calculated fields does not work with data which however works in production. Added an information box if using [%data.
BUG: (TAB FORM) When you created a new field it didn't allow dragging it to sort.

V.1.5.0 2023-01-08 Metadata support

• NEW Inside the template engine, when a variable is extracted from the data of a list, the VAL attribute has been added.
  the extracted variables return the processed values. If this attribute is used, the variable returns the original value saved in the database.
• NEW: In the page where the form is configured, the possibility of sorting the order in which to show multiple tables has been added
• NEW: Special handling for metadata has been developed. In the setting screen it is possible to select the metadata table linked to the main table. If this is selected in the form configuration page, an Add metadata button will appear with which it will be possible to add new custom fields.
• FIXBUG: inherited the single checkbox was not passing the value
• FIXBUG: on lists with multiple tables the system that inherits the configuration on the list doesn't seem to work.
• FIXBUG: (TAB FORM) change styles doesn't work correctly
• FIXBUG The query aliases of a new FORM must always be quoted
• IMPROVEMENT: On the autocomplete popup added the handling of the ESC key.

V.1.4.0 2022-12-15 - Clone list
NEW: (list-all) Clone list: it is now possible to clone a list.
NEW: (Browse-list) The ability to clone a record has been added to lists.
NEW: Added function ADFO::get_clone_detail(); Returns the data to clone a record
NEW: (PRO list all tables) Add Clone table action
NEW: (PRO) Now it is also possible to update the PRO version directly from the plugins page
IMPROVEMENT: (list view formatting) Add checkbox Keeps settings aligned with information from the same field in tab 'Form'.
FIXBUG: notice in list_browse (wpdb->prepare)
FIXBUG: (dropdown filter) checboxes with comma
FIXBUG: remove sanitize in get_request
FIXBUG: (admin-list) Remove pagination html after bulk actions.
FIXBUG: (dropdown filter) Results were not corrected when filtering by operators: '> < >= <='
FIXBUG: The lookup filters with the column filters didn't work together. With search the drop down menu was not working properly
FIXBUG: Did not show title and description of table attributes when managed table is only one.

• FEAT: [Only for PRO]: A system for importing data from a form. Now you can export, edit and re-import your data. Before importing the data, these are verified using a check system.
• IMPROVEMENT (database browse query) [Only for PRO]: Added 'show all text' checkbox in broswer data
• IMPROVEMENT (Code) ADFO:get_detail added raw_data:boolean parameter
• IMPROVEMENT (Code) ADFO:get_data added the raw type return that is used to save the query
• IMPROVEMENT (Code) ADFO:save_data if all fields are null or empty, but id is there i added delete row action.
• FIXBUG: The plugin miscounted the total number of records when the group by was present
• FIXBUG: On import it does not recalculate CALCULATED FIELD type fields