HI,

I created a 'view' taking your advice into account. Already, it is a 'view', no sort, no limit. However, if I activate the edit mode, the 'Enable server-side processing' function is automatically activated in the 'data source' tab. However, this function prevents the filters from working. How do I get a table with both the active filters and the edit function?

Best regards.

Hello Aleksandar, 

The query is as follows, and it's a view 

SELECT PK_user_validation, ident, Service, Metier, Identifiant, Nom, Prenom, NB_lignes
FROM evrp3.v_users_valid WHERE ident <> 0;

Best regards.

Hello Aleksandar, 

I found the problems.

1)

When in Phpmyadmin we copy a request in this form:

SELECT * FROM `name_table`

Well this is an obstacle to the proper functioning of Wpdatatables because of this kind of quotes surrounding the name of the table. These are not the quotes of the 4 key on a French keyboard (azerty). These are used to signify the character string. But those of key 7, which delimit the name of the table and which are not compulsory. Because `` is different from ''.

So it is essential to remove this kind of quotation mark and use only this stripped formula as you advise yourself:

SELECT * FROM name_table

2)

I have several databases, but I found that for Wpdatatables to work properly, the tables processed by Wpdatatables must be in the first database created. Can you modify Wpdatatables so that we can work independently on various databases? Because it can be practical.

By taking care to eliminate these 2 small problems, I managed to find the solution. I haven't tested the editing function on these tables, but I think it shouldn't be a problem.

Best regards.