Hello Dean.

Thank you for your purchase.

If you have created a manual table, or you're simply pulling the data from an existing table in the database, you can create them using SQL queries.

Depending on the contents of the table, you can create them by pulling either all data like:

SELECT * FROM my_table

Or just like SQL - use custom queries to get the desired data. For example:

SELECT * from date_table
WHERE date >= DATE_SUB(CURDATE(), INTERVAL 1 YEAR)

Or:

SELECT name,
lastname,
userid,
email
FROM my_table
WHERE userid BETWEEN '3' AND '17'

Whatever works in PHPMyAdmin (database in general) should work in wpDataTables.

However, there are some limitations when it comes to complex queries. For example using multiple JOIN and CONCAT functions may cause search and filters not to function properly.

Best regards.

Hello Dean.

Please take a look at our documentation - this can all be done from within the plugin's back-end, if you choose the first option to create a table, then select SQL query, and build it there.

Best regards.

I understand, Dean.

Unfortunately that's not how it works.

If you have any other issues or questions, though, please feel free to open a new ticket and we'll gladly help.

Best regards.