Hi, Henry.

1. Pulling data from plugins such as ACF ,  and WooCommerce in general :

We currently do not have any native integration with ACF or WooCommerce,

so pulling this data can only be done through MySQL query-based tables.

Please note: Using this plugin feature requires at least a basic knowledge of SQL. It is assumed that you can create the table in some MySQL data manager (e.g., PHPMyAdmin, MySQL Workbench), and prepare a SQL query that will return the data you need. 

A good way to achieve this can be experimenting using our WPDB SQL Query Constructor tool.

- Please note: this tool is not an ultimate query generator. It simply constructs a suggestion of a query. We are constantly working to improve it, but SQL is such a complicated and flexible language that full automation for constructing queries is next to impossible. 

Consequently, the more complicated the query, the higher is the probability that it will not return exactly what you need. So, you will often need to play around with the resulting query.

Please be advised that writing custom SQL Queries or debugging Queries does not fall under what our support covers.

You can check out this official page of WP codex,  for help with writing custom Queries.

2. If you pull the data you need in SQL Tables, it is not likely that you will be able to edit this data,

because most likely you will need to join/merge data from multiple database tables into one table.

As we pointed out on this Documentation for Editing tables,

there are some limitations in our plugin when it comes to editing :

• Only one MySQL table can be edited at a time. Queries from multiple tables with joins cannot be used as an editable feature, since SQL UPDATE and INSERT statements are generated automatically, and there currently is no way to update multiple tables.
• Only MySQL tables or tables created with “Create a table manually” and “Create a table by importing data from data source” options of “Create a Table” page can be edited.
• Server-side processing MUST be turned on for front-end editing – Note: It will turn on automatically if you forget to enable it.
• MySQL Views cannot be edited properly – only one of the underlying tables can be edited if you pass the proper ID.

3. And there is a chance that some of the data/columns/or tables of these plugins might be stored as serialized JSON format in the WordPress Database.

If that happens, 

 you would need to unserialize the JSON data.

This falls under advanced MySQL, and unfortunately, it will not be covered by our support.

You will have to search for solutions, for example, such as this one from Stack Overflow, i hope it helps.

4. Additional note for WooCommerce:

We do plan to add a native integration for WooCommerce,

when that is finished it should be easier to make tables from this plugin's data,

but i can't say at the moment exactly which functionalities will be possible, such as Editing, etc,

and we can't say an ETA when this integration will be finished.

You can certainly follow our changeLog page if you'd like ( it is also available in the plugin dashboard), where we state any changes/new features/bug fixes during updates;

and our newsletter, so you're informed about new features, bug fixes, freebies, etc.

Hi, Fabrice Henry.

Sorry for the delayed response time.

-

We will do our best to help you achieve this goal;

or at least to advise you if there are any limitations in achieving this with our wpDataTables and the Report Builder.

Can we please take a look at your back-end settings of the table and the Report itself?

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.

And point me to this Report ID, which you already tried;

so we can inspect it and the table to see what might be the best approach.

Thank you.

Hi, Henry.

Firstly i apologise for the waiting time.

I am not 100% sure if we will need additional access,

or if we can provide advice from the screenshots and the PDF/  and the DocX file.

Thank you for sending that to us, we are looking into all the details,

and we escalated this with our senior Team, they have more experience with Report Builder.

As soon as they advice we will report back.

I will let you know if we need additional access/or clarifications from your end.

Thank you for your patience.

Hi, Fabrice Henry.

I got advised about this from our 2nd level Team.

Here is what they said, based on what you described as your desired goal.

• Cell values from wpDataTable: ${quantity.all}, ${price.all}, ${formula_1.all}

- So, you will either have to do this as "Multi File report" ( please check the documentation from that hyperlink);

- Or, you can try like this :

${wpDataTable.row}
Column1: ${column1.all}
Column2: ${column2.all}
        …
${/wpDataTable.row}

2. In regards to PDF,  sorry to disappoint you - at the moment the Report Builder can only export reports as Word or Excel Format,  PDF is not available.

Please feel free to search on our suggestions page, 

 to see if someone may be already suggested this feature. If you can't see it, feel free to add your suggestion there,  and as more people vote, the feature will move higher on the priority list.

You can certainly follow our changeLog page if you'd like ( it is also available in the plugin dashboard), where we state any changes/new features/bug fixes during updates;

and our newsletter, so you're informed about new features, bug fixes, freebies, etc.

3. We do not have our own API,  

Our developers will be working on our API in the future, but I can't say an exact ETA on it.

You can certainly follow our changeLog page if you'd like ( it is also available in the plugin dashboard), where we state any changes/new features/bug fixes during updates;

and our newsletter, so you're informed about new features, bug fixes, freebies, etc.

-

Let us know if anything is not clear, and if you have any further questions.

Thank you.

Hi, Henry.

Firstly, my apology for the waiting time on this reply.
We had our Orthodox Easter holiday break which increased the delay.
Thank you very much for your patience.

-

If i understood, now this SQL Query is giving you an error,

basically you are not able to filter the table to only show the records where this table "post_audits" has values only for the currently logged user ID?

-

1. If that is the case, and you are not able to return the data needed in the SQL Table,

i am sorry but our support is not able to debug custom SQL Queries.

We can only help with some simple/basic SQL issues, but this is a very complex Query with multiple JOIN functions,  and you are pulling data from Posts and Meta Data of WordPress,

this goes beyond the scope of our support.

-

As the custom posts/fields, are a part of the WordPress database;

pulling this data can only be done through MySQL query-based tables.

Please note: Using this plugin feature requires at least a basic knowledge of SQL. It is assumed that you can create the table in some MySQL data manager (e.g., PHPMyAdmin, MySQL Workbench), and prepare a SQL query that will return the data you need. 

A good way to achieve this can be experimenting using our WPDB SQL Query Constructor tool.

- Please note: this tool is not an ultimate query generator. It simply constructs a suggestion of a query. We are constantly working to improve it, but SQL is such a complicated and flexible language that full automation for constructing queries is next to impossible. 

Consequently, the more complicated the query, the higher is the probability that it will not return exactly what you need. So, you will often need to play around with the resulting query.

Please be advised that writing custom SQL Queries or debugging Queries does not fall under what our support covers.

You can check out this official page of WP codex,  for help with writing custom Queries.

2. If you manage to pull the data you need in the source SQL Table, and if you manage to filter the table on a page,

then in the Report Builder Wizard enable "Report data filtering" :

 – this checkbox is visible only if you did choose a wpDataTable data source on previous step. If this is checked, the report will always contain only the rows that are currently visible in the wpDataTable when it’s placed on the same page, in the same order. 

So if a table is sorted, filtered, etc., the rows will be used in the report same as they appear on the page.

 If this checkbox is unchecked, or if the wpDataTable isn’t present on the same page with Report controls, whole table will be used in report every time.

 Important notice: if the table has more rows that are currently visible, the invisible ones won’t be used in the report if the follow table filtering – to use them you would need to select “All” in wpDataTables “Show … rows” dropdown on the front-end. 

We hope this helps.