Hi, Hatim 

Thanks for reaching out to us

-

Not sure if i understood you completely.

Regarding the "users see and edit only their rows", we have a built in feature for this, please check it out here.

This feature is filtering, and only loading rows for the currently logged in user ID.

-

Now, if you need to have one main table that an Administrator can view all the rows, and edit them,

you can first create a Manual table.

Then you can make SQL Queries and create new wpDataTables that will pull the data out of the main table;

and it can be editable.

So you can post an SQL made table that will limit user to see and edit only the rows that you filter for them;

and on another, private page , only for an Admin, you can set the source table with all the rows, for editing.

-

Does that sound like a solution for you - or if i misunderstood, please elaborate with a bit more details what the goal is, and we will advise you if it's possible with our plugin?

-

And, just wanted to point out that we have a Demo Sandbox site, where you can try out the plugin functionalities, on this link.

You can also try to connect your database to the Demo, if it's a live database on a server, not "localhost", by using our separate DB connection.

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)

Hi, Hatim 

Thank you for clarifying, at first i did not realise that you wish to pull and edit data from the WP users, metadata and custom post types.

Pulling data from the WordPress tables such as custom post types, wp_users as well as metaData    into wpDataTables can be done only with MySQL query-based tables.

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 (e.g., PHPMyAdmin, MySQL Workbench), and prepare a 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.

-

If you use our foreign key feature to create relations between tables,  you could edit only using a selectbox, to choose from existing values...

-

On the other hand, if you create SQL JOIN's  to join several tables in one SQL Query,  you would not be able to edit properly,

because currently in wpDataTables we can only edit one table at a time.

-

I believe that it is not currently possible, but i will still double-check this to be sure, with my senior colleagues from 2nd level.

As soon as they respond, i will report back to advise you.

Sorry about all the waiting time.

Hi, Hatim 

Sorry for all the waiting time.

I got confirmation for this.

Basically, if you wish to create one CRUD table for editing the WP users, CPT, and CCT,

in either case you would have to join multiple tables from WP database together to load all the data you need;

but it won't be editable;   since currently, our plugin can only edit one table at a time.

Sorry to disappoint you.

Perhaps only if you could be able to devise some custom SQL Query that can pull data to multiple tables, from one table at a time, then you could be able to edit; 

 But everything through one SQL table won't work for editing.

We will work to improve this possibility for the future, but i can't say an ETA on it.