We're Moving to a New Support Platform – Starting June 1st!

We’re excited to let you know that starting June 1st, we’ll be transitioning to a new support system that will be available directly on our product websites – Amelia, wpDataTables, and Report Builder. In fact, the new support platform is already live for Amelia and wpDataTables, and we encourage you to reach out to us there.

You'll always be able to reach us through a widget in the bottom right corner of each website, where you can ask questions, report issues, or simply get assistance.

While we still do not offer live support, a new advanced, AI-powered assistant, trained on our documentation, use cases, and real conversations with our team, is there to help with basic to intermediate questions in no time.

We're doing our best to make this transition smooth and hassle-free. After June 1st, this current support website will redirect you to the new "Contact Us" pages on our product sites.

Thanks for your continued support and trust – we’re excited to bring you an even better support experience!

Okay
  Public Ticket #2162782
placeholders issue
Closed

Comments

  • ThGilabert started the conversation
    September 24, 2019 at 7:31pm

    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

  •  2,576
    Aleksandar replied
    September 25, 2019 at 10:47am

    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

  • ThGilabert replied
    September 28, 2019 at 2:41am

    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

  •  2,576
    Aleksandar replied
    September 30, 2019 at 9:55am

    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