In fact I have found the problem. It was in the query. I have just added a parenthese "(" after FROM and before WHERE and it's ok.
Thank you for the reaction.
Paul
SELECT B.countryname, C.company, C.address, D.product, FROM (A INNER JOIN B ON A.prodid = D.id INNER JOIN C ON A.companyid = C.id INNER JOIN D ON A.countryid = B.id) WHERE D.langid = 2
Hello,
I have the plugins wpDataTable which was working fine. But after the update, I notice that the Advanced filters is not working is no more working on my site (http://etlsx.ecowas.int/liste-de-produits-aggrees/?lang=fr).
It's giving "No matching records found".
I have gone through all the setings but no good result.
Please advise.
HI Paul,
Thank you for your purchase.
Can you please tell me which version did you use before update?
Which data source you use for creating this table?
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
Dear Milan,
In fact I have found the problem. It was in the query. I have just added a parenthese "(" after FROM and before WHERE and it's ok.
Thank you for the reaction.
Paul
SELECT
B.countryname,
C.company,
C.address,
D.product,
FROM (A
INNER JOIN B
ON A.prodid = D.id
INNER JOIN C
ON A.companyid = C.id
INNER JOIN D
ON A.countryid = B.id)
WHERE D.langid = 2
HI Paul,
You are welcome. I am glad that you find what cause the issue.
If you have any more issues feel free to open a new ticket, we will gladly help.
We'd greatly appreciate it if you could take a minute and leave a review on CodeCanyon on this link. Thanks!
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