I am sorry to disappoint you, but unfortunately like mentioned in our documentation, stored procedures and nested queries are not supported, but you can prepare a MySQL view (which will return the data you need); call it “view1” for example, and then build a wpDataTable based on a simple query like “SELECT * FROM view1”.
created 'Procedure' in 'MySQL DB'
And when you do 'call procedure()'
'CALL not implemented.'
I get this message.
Tell me how to use 'Procedure'.
Hello Patrick.
Thank you for your purchase.
I am sorry to disappoint you, but unfortunately like mentioned in our documentation, stored procedures and nested queries are not supported, but you can prepare a MySQL view (which will return the data you need); call it “view1” for example, and then build a wpDataTable based on a simple query like “SELECT * FROM view1”.
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