Hi, Raymond

I will do my best to cover all the questions, and in case if I misunderstood anything, please correct me.

Regarding Logging in  – verifying credentials or creating a token that can be used for other pages,

this is something that can not be done by using wpDataTables. 

You could create a solution for that, perhaps by using any Membership Plugin, and if you need to set Access depending on user roles, you can use it in combination with User Role Editor plugin,

and then you can add certain custom user roles, and allow/deny Acess to certain pages how you need.

- Regarding creating tokens that can be used to view other pages, to be honest, I am not sure how that can be achieved.

-

1. Regarding pulling any data from the Metadata fields from the database, including custom Posts,

- for example, if you need to pull any data from wp_usermeta ( of course, the wp_ prefix can be different for your site); you can always do so, with an SQL query, here is our documentation section about this with an example;

Please note that our support doesn't cover creating custom SQL queries, but we can always try our best to advise and guide you in the right direction.

- We also have an SQL Query constructor tool, this is a helper took, that can try to "guess" the correct query for you, with a visual tool.

- Please note that MySQL query constructor is not an ‘ultimate generator’, it should be treated as a helper for constructing a suggestion of a query, by trying to ‘guess’ what you want. We are constantly working to improve it, but SQL is such a complicated and flexible language that fully automating the process for constructing queries is hardly possible. Consequently, the more complicated your request is, the higher is the probability that it will not return exactly what you need. Play around with the resulting query to achieve better results.

-

2. CRUD

You can have full functionality to add new, edit, or delete entries,

this is only possible for Manual Tables, and SQL-based tables, or tables created by importing data from sources ( such as Excel, Google Spreadsheet, CSV).

Important to note, when working with Excel files :

You can use Excel files in two ways to create wpDataTables:

- Create a table linked to an existing Excel file, in which case you get to select the file (upload it) that'll be used to pull the data. This file will be stored in ../wp-content/uploads/YEAR/MONTH/ folder. The file on that location can be changed, but the structure can't. So, if you have the file with the same title, the same number of columns, same headers, and the same order of columns - you'd be able to replace the original file with the new file, and wpDataTables would pick that up.

- Create a table by importing the Excel file. In this case, the source file is read, and a manual table is created. So, the generated table reads the source only once, and after that, there are no relations between it and the wpDataTable. You would be able to edit the table, but the changes wouldn't be seen in the source file. In this case, you'd be able to save new rows in a separate Excel file (without column headers) and export it as CSV. Then, access the table and in the Editing tab above the table see what the "MySQL table name for editing" is. Access your database and access that table. In the "Import" tab select the new CSV file and import it. That will update the table. Another option would be to switch to Excel-like view, select a range of new cells from your Excel file and paste them below the last row in wpDataTables.

 -

3. Sorting -  wpDataTables can act as a sortable table plugin by supporting sorting for all the data types , more details here.

4. Filtering ( with search) is also available. Please check more details here. We also have an add-on with additional special Filtering Features, such as Cascade Filtering, and "Hide table" before choosing filters. More details about Powerful Filters here.

5. We have Export Tools functionality, but it has certain limitations. More details here.

6. By "deleting current found set, and delete all the records", could you provide more details, I am not sure if I understand exactly what you mean by this?

7.

"Display any fields on pages. Populate any form or field on a page. "

- For this, I am also not sure exactly what you need, if you can elaborate a bit more on those points? Thank you.

-

Just wanted to point out that we have a Demo Sandbox site, where you can try out some of the functionalities, on this link

and there is a 15-day money-back guarantee period,
So if you purchase the plugin, you can safely fully test it out,
and if it doesn't fit your needs you can request and receive a refund in that period. ( same goes for all plugins and add-ons)