Good plug-in, poor Documentation; Joins and grouped EAV-Tables not editable?
-
Plug in is pretty good, but Documentation is poor. But once I gathered all the necessary informations from the ratings and Support Topics to get this plugin to work and understand the limitations of it, it works fine.
One thing i’m still not sure about: Is it somehow possible to edit EAV based tables that have been grouped by a value? If yes, how? Or is another approach necessary or is it impossible?
And if using joins it seems only possible to edit the ‘basic table’, or am I missing something? Would be nice if joined views would be fully editable, but of course I don’t understand the compelexity of the implementation of these functionalities.
Clear statements about these things in the documentation would be helpful, also the example given could use more parameters, so every functionality (edit values, export, etc.) is possible.
I just insert a working example here, maybe it helps someone in the future:
if(function_exists(‘add_db_table_editor’)){
add_db_table_editor(array(
‘id’=>”custom_table_interface_1″,
‘title’=>’Mitglieder: Bezahlstatus, Handynummer und Telefonnummer ?ndern’,
‘table’=>’wp_users_zusaetze’,
‘cap’ => ‘edit_pages’,
‘edit_cap’ => ‘edit_pages’,
‘id_column’=> “ID”,
“export_id_field”=>”z.ID”,
‘noedit_columns’ => ‘user_email, display_name’,
‘sql’=>”SELECT z.ID, u.user_email, u.display_name, z.user_bezahlstatus, z.Handynummer, z.Telefonnummer
FROM wp_users_zusaetze z
INNER JOIN wp_usermeta m ON m.user_id = z.user_id
INNER JOIN wp_users u ON u.ID = m.user_id
WHERE m.meta_key = ‘wp_capabilities’
AND m.meta_value LIKE ‘%mitglied%'”
));
}like I said, only the values of the table ‘wp_users_zusaetze’ are editable, joined tables can’t be edited, but maybe I am doing something wrong.
- The topic ‘Good plug-in, poor Documentation; Joins and grouped EAV-Tables not editable?’ is closed to new replies.