In your lit and examples I could not tell if I can use dynamic rich content including featured images, images, URL, or Wysiwyg fields.
Can I build a report from a custom post or do I need to use a data table as the data source. I know I need the license, this is a question about the available data source only.
If you know your way around SQL, there are only few limitations that could get in the way. You can pull all the data you have stored in your database and create tables from it.
We even have a helper - wpDataTables query constructor, but 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.
You can test the full plugin on our sandbox site, where you can even connect your database as a separate DB connection, and see what the plugin can do.
If you have any further questions, please feel free to ask.
Let me clarify so I can move forward and buy the plugin. If we know how to build the query we can pull any data type into a table including an image, file attachment, URL or Wysiwyg field. Once in the table we can use Report Builder to put the dynamic data into a report that we create.
Mostly - yes. However, when it comes to editing, you need to know that tables that have JOINs, CONCATs, UNIONs and other similar statements cannot be properly edited, and are mostly used for displaying data.
Report Builder is a paid add-on which pulls the data from your existing tables and (depending on the used template) displays a report from the data in the table, yes.
In your lit and examples I could not tell if I can use dynamic rich content including featured images, images, URL, or Wysiwyg fields.
Can I build a report from a custom post or do I need to use a data table as the data source. I know I need the license, this is a question about the available data source only.
Hello John
Thank you for your interest in wpDataTables.
If you know your way around SQL, there are only few limitations that could get in the way. You can pull all the data you have stored in your database and create tables from it.
We even have a helper - wpDataTables query constructor, but 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.
You can test the full plugin on our sandbox site, where you can even connect your database as a separate DB connection, and see what the plugin can do.
If you have any further questions, please feel free to ask.
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
Let me clarify so I can move forward and buy the plugin. If we know how to build the query we can pull any data type into a table including an image, file attachment, URL or Wysiwyg field. Once in the table we can use Report Builder to put the dynamic data into a report that we create.
Hello John
Mostly - yes. However, when it comes to editing, you need to know that tables that have JOINs, CONCATs, UNIONs and other similar statements cannot be properly edited, and are mostly used for displaying data.
Report Builder is a paid add-on which pulls the data from your existing tables and (depending on the used template) displays a report from the data in the table, yes.
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