I have a datatable in MySQL and am pulling it into WordPress with wpDataTables. I want to set a group based on a repeated column value. In most cases, it works as expected. UNTIL I add an html table as part of the strings in a non-grouped column.
Then it just spins and spins and spins, on both backend and frontend.
To fix on the backend I have to click over to the navigation link for the plugin then edit that table to remove grouping, and voila, it works again.
The HTML table in the string of the Description field is just a string. Ideally, this shouldn't impact grouping.
Firstly, I would like to sincerely apologize for the delayed response as we have been experiencing an unusually high number of tickets. I am sorry that it has taken longer than usual to respond to your concern and your patience is highly appreciated.
-
To be fully honest with you, this is a bit higher than my level of expertise, so i will escalate it with our 2nd level Team. They will assist to investigate this, and will advise why the issue seems to be happening, when you use grouping > but otherwise as you've shown, it is without issues.
As soon as they respond, i will report back. Thank you for your patience.
Just wanted to double-check one detail. I assume that you disabled server-side processing for the SQL table, in order to have the Group column toggle appear?
I will still come back when i get advise from senior colleagues. Thank you
Yes, I have the Enable Server Side option unticked so that I can use the grouping.
Select query is below. I'm hiding the Category, Area, and Type columns, and am trying to group on SubType column.
(Oh, and I did just add use of the variables in the query today, so I know it's not that.)
I've attached a create table with data rows sql file (renamed as .txt). You'll see that some of them have HTML in the Description column.
Please let me know if you need anything else.
Thanks!
Becca
SELECT
Category
, Area
, Type
, SubType
, Name
, Description
, LearnMore
FROM Definitions
WHERE
Category LIKE '%VAR1%'
AND Area LIKE '%VAR2%'
AND Type LIKE '%VAR3%'
AND SubType LIKE '%VAR4%'
ORDER BY
Category
, Area
, Type
, SubType
, Name
, Description
You will have an issue with Responsiveness, so it will be best to disable it in the Display tab of table settings.
There will also be issues, as returning additional unnecessary rows of the table as undefined in cells because of the Grouping logic ( the plugin was not designed to have table elements in the table itself);
It is a third-party library that renders the HTML tables in our plugin, so, unfortunately, we are limited at this time as to what we can to do help.
To report back, making the suggested changes to jquery.dataTables.rowGrouping.js and unticking the associated box on the customization screen did not make any difference for me.
What I ended up doing was changing the tables inside the columns with the html to use CSS Grid elements instead of table elements. Same look-feel for the end-user, and no more conflict with the grouping function.
I have a datatable in MySQL and am pulling it into WordPress with wpDataTables. I want to set a group based on a repeated column value. In most cases, it works as expected. UNTIL I add an html table as part of the strings in a non-grouped column.
Then it just spins and spins and spins, on both backend and frontend.
To fix on the backend I have to click over to the navigation link for the plugin then edit that table to remove grouping, and voila, it works again.
The HTML table in the string of the Description field is just a string. Ideally, this shouldn't impact grouping.
Is there anything we can do to resolve this?
Attached files: 2022-06-26 8.02.49 AM.png
Hi ,Becca
Firstly, I would like to sincerely apologize for the delayed response as we have been experiencing an unusually high number of tickets. I am sorry that it has taken longer than usual to respond to your concern and your patience is highly appreciated.
-
To be fully honest with you, this is a bit higher than my level of expertise, so i will escalate it with our 2nd level Team. They will assist to investigate this, and will advise why the issue seems to be happening, when you use grouping > but otherwise as you've shown, it is without issues.
As soon as they respond, i will report back. Thank you for your patience.
Kind Regards,
Miloš Jovanović
[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
Hi ,Becca
Just wanted to double-check one detail. I assume that you disabled server-side processing for the SQL table, in order to have the Group column toggle appear?
I will still come back when i get advise from senior colleagues. Thank you
Kind Regards,
Miloš Jovanović
[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
Hi ,Becca
Could you possibly grant us temporary Wp Admin access, so that we can take a closer look at how you made this?
Or you could give us perhaps some instructions on how we could replicate this locally on our testing sites;
and we can see the issue in more detail - then our devs can see if we can make any kind of workaround?
-
If you send us WP Admin credentials, please make sure to mark as PRIVATE response, so that nobody can see your credentials but us.
And if you can point out the table ID for us. Thank you
Kind Regards,
Miloš Jovanović
[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
Hi Miloš,
Yes, I have the Enable Server Side option unticked so that I can use the grouping.
Select query is below. I'm hiding the Category, Area, and Type columns, and am trying to group on SubType column.
(Oh, and I did just add use of the variables in the query today, so I know it's not that.)
I've attached a create table with data rows sql file (renamed as .txt). You'll see that some of them have HTML in the Description column.
Please let me know if you need anything else.
Thanks!
Becca
SELECT Category , Area , Type , SubType , Name , Description , LearnMore FROM Definitions WHERE Category LIKE '%VAR1%' AND Area LIKE '%VAR2%' AND Type LIKE '%VAR3%' AND SubType LIKE '%VAR4%' ORDER BY Category , Area , Type , SubType , Name , DescriptionAttached files: Definition.sql.txt
Oops and I'm actually pulling the data from the VIEW version (Definitions) of the TABLE (Definition), so structure for that view is attached here.
Attached files: Definitions.sql.txt
Hi, Becca
Sorry for the delay
I've been advised by the developers on this
-
You will have an issue with Responsiveness, so it will be best to disable it in the Display tab of table settings.
There will also be issues, as returning additional unnecessary rows of the table as undefined in cells because of the Grouping logic ( the plugin was not designed to have table elements in the table itself);
It is a third-party library that renders the HTML tables in our plugin, so, unfortunately, we are limited at this time as to what we can to do help.
The only ideas we have might be :
1. If you use CSS to remove them;
2.
or to try to edit this file
wp-content/plugins/wpdatatables/assets/js/jquery-datatables/jquery.dataTables.rowGrouping.js
around line 394 you will find
var nTrs = $('tbody tr', oTable);
replace it with
var nTrs = $('tbody tr[role="row"]', oTable);
And disable "Use minified wpDataTables Javascript" in the main plugin settings > Custom JS and CSS tab.
- Please let us know if that worked, this workaround will have to be tested further before we implement it in the plugin's core.
I hope that i passed the explanation and advise correctly from the devs.
Let me know if that makes sense, and how it goes. Thank you
Kind Regards,
Miloš Jovanović
[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
Thanks, I'll give this a try and let you know how it goes. :0)
Hi, Becca
No problem. Let us know how it goes, please
Thank you
Kind Regards,
Miloš Jovanović
[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
To report back, making the suggested changes to jquery.dataTables.rowGrouping.js and unticking the associated box on the customization screen did not make any difference for me.
What I ended up doing was changing the tables inside the columns with the html to use CSS Grid elements instead of table elements. Same look-feel for the end-user, and no more conflict with the grouping function.
Yay. :0)
Hi, Becca
Sorry for the delay
- Thank you for passing the solution, i am very happy to see that you have resolved this.
I will pass these details to our developers, as i believe it will be quite useful to know
Of course, if you encounter any further issues, please don't hesitate to reach out to us.
Thanks again
Kind Regards,
Miloš Jovanović
[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