Hi devrat.

Thank you for your purchase.

You can select rows from your SQL table if the row has an auto-increment ID column, like "wdt_ID". In that case you can create a query like:

SELECT * FROM `wp_wpdatatable_2`
WHERE wdt_ID = "1" OR wdt_ID = "4"

That will pull up only rows with wdt_ID "1" and "4".

Same goes for any column. You need to add the "WHERE" clause and define the values you need to pull from that column.

Best regards.

Hello again devrat.

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 (PHPMyAdmin, MySQL Workbench, etc.), and prepare an SQL query that will return the data you need. If you do not know how to use MySQL, refer to the “Create a MySQL-query-based table by generating a query to MySQL database” section. It will explain how to create complete tables or MySQL queries without this basic knowledge. Please be advised that preparing MySQL queries for you is not included in the plugin support, but it can be done as a paid customization service.

Thank you for understanding.

What I was referring to was SQL query based tables. It is assumed you have a table in PHPMyAdmin, and that you want to pull only selected rows from that table using wpDataTables. Please take a look at the video showing the entire process.

Unfortunately this is as much as I can do for you.

I hope it helps.

Best regards.