Hi vivosweb,
Thank you for your purchase.

I need to see that data from database so can you please provide me login for phpMyAdmin and also provide me a temporary WP-admin login 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 party.

You can write credentials here just check Private Reply so nobody can see them except us.

Hi vivosweb,

Sorry but I can't see the table name "product" in your tables. (Attachment) Can you please point me to the exact location of that table.

Hi vivosweb,

When I go to  I want to create a table based on my WordPress data (posts or pages, and post meta or taxonomy values and then on Choose the post types which you would like to have in the table I couldn't find the table name "product". Please take a look at the attachment.
Maybe because you give me the credentials of the test site so this can be the issue.

Can you please point me where is the file name "product", because I can't find it.

Hi vivosweb,

Now I can see it.
It seems that the query is empty because I get this message after I created the table (Attachment).

If you take a look at our documentation you can see that wpDataTables Constructor is just a helper:

"Please note that WPDB query constructor is not an ultimate query generator, it just constructs a suggestion of a query. We constantly work on improving it, but SQL is such a complicated and flexible language that full automation for constructing queries is hardly possible. So the more complicated the query is, the higher is the chance that it will not return exactly what you need. So play around with the resulting query."

The best solution to write MySQL query by your own and try to execute it in phpMyAdmin or any other database system administration tool and see does it returns data that you want. 
If you are not skillful with MySQL query and we will create this query and table for you. Just please describe us exactly what you want to fetch from database, what columns you want to show in tables and do you want to have some condition in that query.

Hi vivosweb,

Can you please tell me what the number 95 is referred to in product.taxonomy.product_cat and what the 95 is pointing to (ID, name or etc)

Hi vivosweb,

The problem is that I can't see the product category with ID 95 for product.taxonomy.product_cat.
There is a values like Refurbished and Refurbished Analyzers so the conditions won't work because there is no 95.
As you can see on wpDataTables Support page that I created, the table is displaying just a products with id 22491 and the condition is working.
Take a look at attachment how I created it (Attachment 1).

Also take a look at wpDataTables support 2 table where all "Refurbished" product.taxonomy.product_cat is displayed. I wrote some mySql query so I hope it will help you.