Hello Jota

Thank you for your purchase.

Unfortunately, since wpDataTables is not a database management plugin, it cannot work as good as phpMyAdmin or other database management tools.

The issue is with the query - since you have a slightly complex query, with JOINs, editing will not work, and there's a possibility filtering and sorting won't work also.

Unfortunately, the only workaround for filters and sorting is to create a MySQL view with this query, and then create a wpDataTable using that view, like SELECT * FROM view.

However, that will not make the table editable, and I'm afraid since you'll need to pull the data from multiple tables you will not be able to do this.

Like mentioned in our documentation:

Only one MySQL table can be edited at a time. Queries from multiple tables with joins cannot be used as an editable feature, since SQL UPDATE and INSERT statements are generated automatically, and there currently is no way to update multiple tables – but this problem is being investigated and pursued

Hi again Jota

If you're using UNION, make sure to add UNION ALL at the end of the query, so instead of:

SELECT wp_bp_xprofile_data.value AS telefono FROM wp_bp_xprofile_data 
WHERE wp_bp_xprofile_data.field_id = 61
UNION
SELECT wp_bp_xprofile_data.value AS nombre FROM wp_bp_xprofile_data 
WHERE wp_bp_xprofile_data.field_id = 1

Use this:

SELECT wp_bp_xprofile_data.value AS telefono FROM wp_bp_xprofile_data 
WHERE wp_bp_xprofile_data.field_id = 61
UNION
SELECT wp_bp_xprofile_data.value AS nombre FROM wp_bp_xprofile_data 
WHERE wp_bp_xprofile_data.field_id = 1
UNION ALL

That may work. However, to edit the table you will need an ID column which will be the column for editing.

You can pull data from metadata, but I'm not sure you'll be able to edit it.