Hi there,

Thanks for providing this great and useful plugin. As you mentioned in your documentation that you are working on improving the limitation for tables with joins, I am providing this feedback.

• "Only one MySQL table can be edited at a time. Queries from multiple tables with joins cannot be used for editable feature, since SQL UPDATE and INSERT statements are generated automatically, and for now there is no way to update multiple tables – but we are working on this."

I suggest having multiple ID column for editing multiple columns. In the MySQL query bellow, which is pivoting wp_usermeta table, the  ID column for editing first name column should be  first_name_umeta_id, and the one for last name needs to be set on last_name_umeta_id.

The problem is currently we can only set 1 ID column for editing columns. The related image is attached.

select a.user_id,   
c.umeta_id as first_name_umeta_id,c.meta_value as first_name , d.umeta_id as last_name_umeta_id,d.meta_value as last_name from wp_usermeta as a  join wp_usermeta c on a.user_id=c.user_id and c.meta_key = 'first_name'  join wp_usermeta d on a.user_id=d.user_id  and d.meta_key = 'last_name' where a.meta_key='nickname'

Thanks,

Sara

Hi Bogdan,

I just wonder if you have this feature in the new version of the plugin?

Thanks,

Sara

I'd enjoy having this feature, too. Does anybody know any workarounds? Don't really want to store all the data in one table...