I have been able to make a table based om a mySql database. The records to be shown must be limited based on the user login. In the config, I can see the records but whether I login as administrator or test user, no records are shown.
I see you selected the Code column from the database to be your User ID column. Please note that this column needs to store the ID of the currently logged in WordPress user. You can see your user ID in the Placeholders tab, under %CURRENT_USER_ID%, and see if it matches the data in the Code column.
If it doesn't - that's the reason why you can't see anything.
Hello,
I have been able to make a table based om a mySql database. The records to be shown must be limited based on the user login. In the config, I can see the records but whether I login as administrator or test user, no records are shown.
The table is at url: www.automatic-industries.com/laundry log
Enclosure 'Mysql': password must match field Code defined as an int
Enclosure 'Table config':
Enclosure 'administrator': page when logged as administrator
Enclosure 'test': page when logged as test
Thanks for your help!
Hello Michel
Thank you for your purchase.
I see you selected the Code column from the database to be your User ID column. Please note that this column needs to store the ID of the currently logged in WordPress user. You can see your user ID in the Placeholders tab, under %CURRENT_USER_ID%, and see if it matches the data in the Code column.
If it doesn't - that's the reason why you can't see anything.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
Thanks.
Indeed I had used a wrong parameter and not the user id.
To make it easier to see all the users id in the WP users tab, I changed the WP function.php based on:
https://rudrastyh.com/wordpress/get-user-id.html#user_id_column
Hi Michel,
Sorry for late response.
We are located in Serbia and our working time is from 10:00 to 17:00 CET. business days.
Aleksandar is out of office and I will take it from here.
I am glad that his solution help you out. If you have any other question or issue please open new ticket, and we will help you out.
Kind Regards,
Isidora Markovic
wpDataTables: FAQ | Facebook | Twitter | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Amelia demo sites | Docs
You can try our wpDataTables add-ons before purchase on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables