I'm using placeholder %CURRENT_POST_ID% to filter a simple SQL query (with only one inner join). The WPdatatables table shows result when I create it, but it does not bring anything when on a Woocommerce products page. The "post Id" is correct and corresponds to items in the DB. I already tried changing datatypes in DB (BIGINT and VARCHAR). How can I fix/trouble shoot this?
I can't say what's going on without taking a look at the table and the page, so please provide me a temporary WP-admin (administrator) user for your site where this happens, so we could log in and take a look ‘from the inside’ as that’s the most efficient way to see and resolve the issue.
We do not interfere with any data or anything else except for the plugin (in case that’s a production version of the site), and of course, we do not provide login data to third parties.
You can write credentials here just check PRIVATE Reply so nobody can see them except us.
Also, make sure to tell me where the page is, so I can see it on the front-end.
I figured out why it gave zero results. I'll post here to help any other (beginner) who run into same rare coincidence:
- The SQL query included the key from 2 linked tables. (it's obviously same data as it's the key).
- I had enabled sorting (I think it was, or the tick next to it ... :o ) in WPtables settings.
The above combination result in an empty table. Un-ticking the sorting or removing the other key column from the SQL query changes this behavior, and all works perfectly. The behavior has nothing to do with Woocommerce, in the end, and wpDataTables works as it should.
Hello,
I'm using placeholder %CURRENT_POST_ID% to filter a simple SQL query (with only one inner join). The WPdatatables table shows result when I create it, but it does not bring anything when on a Woocommerce products page. The "post Id" is correct and corresponds to items in the DB. I already tried changing datatypes in DB (BIGINT and VARCHAR). How can I fix/trouble shoot this?
Thanks!
Hello Jiri
Thank you for your purchase.
I can't say what's going on without taking a look at the table and the page, so please provide me a temporary WP-admin (administrator) user for your site where this happens, so we could log in and take a look ‘from the inside’ as that’s the most efficient way to see and resolve the issue.
We do not interfere with any data or anything else except for the plugin (in case that’s a production version of the site), and of course, we do not provide login data to third parties.
You can write credentials here just check PRIVATE Reply so nobody can see them except us.
Also, make sure to tell me where the page is, so I can see it on the front-end.
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 Alexandar,
I figured out why it gave zero results. I'll post here to help any other (beginner) who run into same rare coincidence:
- The SQL query included the key from 2 linked tables. (it's obviously same data as it's the key).
- I had enabled sorting (I think it was, or the tick next to it ... :o ) in WPtables settings.
The above combination result in an empty table. Un-ticking the sorting or removing the other key column from the SQL query changes this behavior, and all works perfectly. The behavior has nothing to do with Woocommerce, in the end, and wpDataTables works as it should.
Cheers!
Hey Jiri
That's great news, thanks for sharing that with everyone!
If you have any further questions or issues, please feel free to open a new ticket, and we'll gladly help.
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