Hello,

i have a problem with the selectbox. I can not delete items for another user. I have a main table (0 - MySQL table - main table.png) and a foreign table (0 - MySQL table - foregin.png). In a foreign table, I have two entries for user 1 and one for user 2. SQL designer (0 - MySQL table - table designer.png).
I have tried two solutions:

1 / Filter out unwanted items using the "Users see and edit only own data" property (1 - foregin table 1.png, 1 - main table - 1.png, 1 - main table - 2.png ).
In the data preview, it is ok (1 - foregin table 1.png), but an unwanted entry (1 - listbox.png) appears in the table used.
2 / Filter out unwanted items using the WHERE SQL statement clause (2 - foregin table 1.png, 2 - foregin table 2.png). This, however, leads to an error (2 - main table - err.png). And it also causes the number to be displayed instead of the corresponding string (2 - main table - no string.png).

Why is there a bug in the php script? Repair / Edit the wpDataTable plugin, or is there any other solution?

Thank you for answer.

Hello,

thank you very much for the correction. In the new version, both solutions work well.

Kind Regards,

Jiří Knotek