Could you explaim me
why the SQL request below is not support by the pluggin enven though it's has
been set up using configuration panels. I spent hours in your documentation and
it seem this request should work.
Fr_id is the current
logged user within WordPress.
The error messsage :
In French :
Aucune donnée
extraite!
Si vous essayez de
sauvegarder le tableau pour la première fois, veuillez entrer une date avant de
sauvegarder afin que le tableau puisse être défini avec précision.
Vous pouvez la
supprimer plus tard si vous avez besoin d’un tableau vide pour commencer.
Translation in English
:
If you try to save the
array for the first time, could you please set up a date before saving it in
order the array can be defined precisely. You can delete it later if you need
an empty board to start.
From version 2.3 we've implemented a feature that you can use multiple separate DB connections for MySQL, MSSQL and PostgreSQL. For MySQL engine we are dynamically adding the accent grave ( ` ), so there's no need to use it around the table name in the query.
Can you try with this query:
SELECT process_refid,
step1_contract_init,
cl_companie,
cl_id,
cl_last_name,
cl_first_name,
cl_surname,
fr_surname,
fr_id
FROM mt_process
WHERE fr_id=%CURRENT_USER_ID%
It's the same issue with the SQL request you suggest below. However I've finally found the root cause of the problem. In fact when you set up a new table you are logged with WordPress admin account and %CURRENT_USER_ID% value is the ID of the admin user. Unfortunately there is no record in the SQL table with admin ID because SQL data are the inventory of clients. To solve it I've just added a dummy record with the admin ID and it works. you may save and apply setting of the new table and then afterward you have to erase the dummy record with admin ID. May be you should take into account this issue for next releases and change the ERROR message in French which is no relevant at all. It's not a matter to add any date somewhere as mentioned in the text of the message.
Thanks for your support and your responsiveness, Regards Thierry Gilabert
I will forward it to our development team, so they can take a look at it, but I don't know if that would be possible to achieve. You see, that message appears whenever the wpDataTable returns "0" rows, which unfortunately is the case, until you change the ID in the table.
Hello guys,
Could you explaim me why the SQL request below is not support by the pluggin enven though it's has been set up using configuration panels. I spent hours in your documentation and it seem this request should work.
-----------------------------------------------
SELECT mt_process.`process_refid`,
mt_process.`step1_contract_init`,
mt_process.`cl_companie`,
mt_process.`cl_id`,
mt_process.`cl_last_name`,
mt_process.`cl_first_name`,
mt_process.`cl_surname`,
mt_process.`fr_surname`,
mt_process.`fr_id`
FROM mt_process
WHERE mt_process.fr_id=%CURRENT_USER_ID%
--------------------------------------------------------------------
Fr_id is the current logged user within WordPress.
The error messsage :
In French :
Aucune donnée extraite!
Si vous essayez de sauvegarder le tableau pour la première fois, veuillez entrer une date avant de sauvegarder afin que le tableau puisse être défini avec précision.
Vous pouvez la supprimer plus tard si vous avez besoin d’un tableau vide pour commencer.
Translation in English :
If you try to save the array for the first time, could you please set up a date before saving it in order the array can be defined precisely. You can delete it later if you need an empty board to start.
WordPress Version : 5.2.3–fr_FR,
wpDataTable Version : 2.6.1
PHP Version : 7.3
Thanks for your support
Hey ThGilabert.
Thank you for your purchase.
From version 2.3 we've implemented a feature that you can use multiple separate DB connections for MySQL, MSSQL and PostgreSQL. For MySQL engine we are dynamically adding the accent grave ( ` ), so there's no need to use it around the table name in the query.
Can you try with this query:
SELECT process_refid, step1_contract_init, cl_companie, cl_id, cl_last_name, cl_first_name, cl_surname, fr_surname, fr_id FROM mt_process WHERE fr_id=%CURRENT_USER_ID%Please let me know if this works.
Best regards.
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
Hello Aleksandar,
It's the same issue with the SQL request you suggest below. However I've finally found the root cause of the problem. In fact when you set up a new table you are logged with WordPress admin account and %CURRENT_USER_ID% value is the ID of the admin user. Unfortunately there is no record in the SQL table with admin ID because SQL data are the inventory of clients. To solve it I've just added a dummy record with the admin ID and it works. you may save and apply setting of the new table and then afterward you have to erase the dummy record with admin ID. May be you should take into account this issue for next releases and change the ERROR message in French which is no relevant at all. It's not a matter to add any date somewhere as mentioned in the text of the message.
Thanks for your support and your responsiveness,
Regards Thierry Gilabert
Hello again Thierry.
Thanks for letting me know.
I will forward it to our development team, so they can take a look at it, but I don't know if that would be possible to achieve. You see, that message appears whenever the wpDataTable returns "0" rows, which unfortunately is the case, until you change the ID in the table.
It'll be looked at though.
Best regards.
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