I have MySQL table, I created view as "select * from table", I disabled server side processing.
It is a small table and will never ever reach even thousand rows.
The query in wpDatables is "select * from my_view".
Both search entry fields DO WORK CORRECTLY (i.e data entered is passed into query) but the search value entered is not visible thus clients has the feeling that search does not work.
When I press Clear Filter, the whole list re-appears .
You have two SQL query tables, and they both work fine?
But when you enter some text in the search field, it works, but you don't see the text?
That sounds like some CSS conflict - how does the table behave in backend?
wpDataTables is a WYSIWYG (What You See Is What You Get) concept based plugin. This means that the table should look the same both in back-end and in front-end. If your front-end table looks and behaves differently than in back-end, this usually implies that there is another plugin (or the current theme) that's changing the behavior of our plugin.
[wpdatatable id=11] - this uses a view and no server processing.
Both back and front ends have the same behavior in the search
I have now disabled Elementor but that does not help and might need to start systematic checking of that CSS conflict ... I wonder what can here be done - in principle.
Urgently need help - please please help
I have MySQL table,
I created view as "select * from table",
I disabled server side processing.
It is a small table and will never ever reach even thousand rows.
The query in wpDatables is "select * from my_view".
Both search entry fields DO WORK CORRECTLY (i.e data entered is passed into query) but the search value entered is not visible thus clients has the feeling that search does not work.
When I press Clear Filter, the whole list re-appears .
URL to see this is (there is NO need to login)
https://dev1.aidxchange.org/display-forum-topic/
Many thanks
Peter
Hello Peter.
I'm sorry, but I can't see anything on that page:
Also, I don't understand what's going on.
You have two SQL query tables, and they both work fine?
But when you enter some text in the search field, it works, but you don't see the text?
That sounds like some CSS conflict - how does the table behave in backend?
wpDataTables is a WYSIWYG (What You See Is What You Get) concept based plugin. This means that the table should look the same both in back-end and in front-end. If your front-end table looks and behaves differently than in back-end, this usually implies that there is another plugin (or the current theme) that's changing the behavior of our plugin.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
Hello Alexandar, thanks for reply and my apology - during the day I accidentally renamed the original page...
The correct page is https://dev1.aidxchange.org/table-current/ (it has nothing but the shortcode)
[wpdatatable id=11] - this uses a view and no server processing.
Both back and front ends have the same behavior in the search
I have now disabled Elementor but that does not help and might need to start systematic checking of that CSS conflict ...
I wonder what can here be done - in principle.
I am giving you the admin password if you wish.
user = atestarwp pwd=atestarwp
Again, thank you
Peter
Hey Peter
Sorry, that was my bad. When I provided the CSS for the "Clear Filters" button, it applied to Search as well (and text filters).
You need to change the custom CSS I provided, to this:
.wpdt-c button { color: white !important; }Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
Alexander,
thank you! It all works as desired.
Best regards
Peter
You're welcome Peter
If you have any further questions or issues, please feel free to open a new ticket, and we'll gladly help.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables