I'd like to clarify a feature of WP Data Tables before purchasing. I've read through the documentation and most of the SQL scenarios begin with importing data into a table in SQL. My client wants reports built on data already in the Wordpress SQL database. For example, I would be looking to develop a report that uses data from both data in Woocommerce tables as well as data from the WP Amelia scheduling plugin tables. I would assume that I could query data from these types of tables to populate the report? Or is there a limitation on using such data? The lite plugin didn't allow me to select a SQL query as a source, so I wasn't able to attempt this myself before purchasing.
Hi,
I'd like to clarify a feature of WP Data Tables before purchasing. I've read through the documentation and most of the SQL scenarios begin with importing data into a table in SQL. My client wants reports built on data already in the Wordpress SQL database. For example, I would be looking to develop a report that uses data from both data in Woocommerce tables as well as data from the WP Amelia scheduling plugin tables. I would assume that I could query data from these types of tables to populate the report? Or is there a limitation on using such data? The lite plugin didn't allow me to select a SQL query as a source, so I wasn't able to attempt this myself before purchasing.
Thank you!