Numeric Sorting

Hi,

thank you! Happy New Year to you as well! ??

Yes, that Extension should be able to fix the mentioned issue.

I’m not sure why this would break the sort entirely on your site. I assume that there’s some sort of JavaScript conflict going on. Unfortunately, I can’t find out what that is without seeing it and being able to investigate it the browser debug tools. Can you therefore turn the Extension on again?

Regards,
Tobias

Hi,

I just activated the extension, so you can see the issue – basically all columns sorting is turned off.

Please let me know what you find out.

Thanks,

Ganaxi

Hi,

thanks for enabling the Extension.

The reason for this is that there something on your site (either your theme, or another plugin) that is loading the jQuery JavaScript library from the Google CDN.
This is usually fine, however, that plugin/theme is loading the old version 1.6.4, instead of the latest 1.8.3. 1.6.4 is however missing some functions that are necessary for the sorting Extension.
You should try to find out what plugin is loading jQuery from the Google CDN.

Regards,
Tobias

Hi Tobias,

Thanks for the direction. You were right on.

I found that TheThe Sliding Panels had the old jquery by turning off plugins one by one. I changed the reference to the proper 1.8.3 from 1.6.4, and the sorting works as you can see from this link
https://www.gurufundpicks.com/indrpt-sample-hld

However, another problem has cropped up, that I am guessing you may have a remedy from within TablePress. If you click on the column headings, you will see that, yes, it sorts properly now, but it duplicates the top row twice.

Thanks,

Manish

Hi,

Just to add,

if you go to the bottom of the table, it also adds a huge blank space (like a footer) to the bottom of the table after clicking on the sort arrows.

Thanks,

Manish

Hi,

Just looked into it more, and it does that only for some of my tables (but 200+ of them), so the only difference between the ones it does that above error (two headers on clicking sort) is when
“Enable horizontal scrolling…” is checked in DataTables JavaScript Library features.

When I turn off that feature, the headers no longer duplicate. However, in my case, the info then flows into the sidebar.
Here, are the two tables,
one with horizontal scrolling checked
https://www.gurufundpicks.com/indrpt-sample-hld
one with horizontal scrolling not checked
https://www.gurufundpicks.com/indrpt-sample-hld2

So, it is somehow tied to that. Let me know if there is an easy workaround, else I will just concatenate the info in the last column.

Thanks,

Ganaxi

Hi,

Okay solved it, FYI.

Went to jquery version 1.7 instead of 1.8.4, and that solved it. You can see it here
https://www.gurufundpicks.com/indrpt-sample-hld

Thanks,

Ganaxi

Hi,

great that you found the plugin that caused this.

Now, I don’t really think that switching to 1.7 is a good longterm solution. Sooner or later, you are going to run into trouble with that again. One should always strive to use the latest stable versions.
I suggest that we instead try to find out what’s the root cause of this. Maybe it’s a bug in the DataTables JS library that we then can report to the developer and maybe help him fix it.

Regards,
Tobias

Hi Tobias,

The problem is with both plugins, I believe.

While I mentioned the DataTables double header problem, the TheThe Sliding Panel plugin also had a problem with displaying the floating login – as it displayed broken up with 1.8.4, but displayed well with 1.7.3.

I will notify the TheTheSliding Panel guys about the issue. Would you mind, since your plugin uses DataTables, to notify those people. If not, let me know, I will gladly do it (I just think you have a better understanding to communicate the issue).

Thanks,

Ganaxi

Hi,

well, at first I’d like to have more information about what the issue is.
Without this, a bug report to the DataTables developer wouldn’t really be helpful, as he probably wouldn’t be able to reproduce the issue on his test environment. I know that he uses the latest version of jQuery, so this might be a real edge case bug. Or maybe it’s not even a bug, but more of a styling glitch.
Can you therefore please switch to the latest jQuery again? I’d actually even recommend to use the jQuery that comes with WordPress, instead of loading it from the Google CDN. This will bring better compatibility with future updates of WordPress, for example.

Regards,
Tobias

Hi, Tobias:

If you remember, we have corresponded before about this. Basically, I am using both WP-Tables and TablePress on my website, as neither can alone handle the large number of tables. Per your instruction, I had put custom CSS in WP-Tables Reloaded so that it would be overridden by the TablePress CSS.

All worked fine I thought, but I recently noticed that the numeric sorting does not work for the tables that are generated by WP-Tables. That was done using the WP-Table Reloaded Extensions, again per your guidance. I believe what may be happening is that WP-Tables has not received the instruction from the extension. Is there a way to make that extension (or another way to do the same thing) work also for the WP-Tables generated tables.

Also, I noticed that the tables do not display well on mobile devices
e.g.,
https://www.gurufundpicks.com/13f-4q2-spr
as the numbers flow out of the columns.

Is there a way to fix that too? i.e., is there a set of instructions to mobilize the content in the TablePress (and WP-Tables Extension) plugins?

Thanks,

Ganaxi

Hi,

can you point me to a table that is made with WP-Table Reloaded, where the sorting is not working?
There’s probably some JavaScript conflict going on.

About the mobile devices: Well, this happens because the space is limited on small screens ?? How do you want tables to behave on small screens?
One possibility might be this TablePress Extension: https://tablepress.org/extensions/responsive-tables/

Regards,
Tobias

Hi Tobias,

Thanks for the response.

1> the table on the page linked above, namely
https://www.gurufundpicks.com/13f-4q2-spr
does not sort well, as it is driven by WP-Tables. Try clicking on, e.g., the fourth column, End-of-Qtr…., and you will what I mean. It sorts # as text, so putting it in an order like this, 93 then 954 then 83 then 7001 when sorting descending.

2> On Responsiveness of the table, the fix in the Extension cited above will not work for me as my columns are varied in width. How I would like it is that — if a mobile device was detected, it still kept the ‘hard’ column widths I have specified, but just made it necessary for the user to scroll to get more information in the right-most columns — if that makes sense.

Thanks.

Ganaxi

Hi,

thanks for the link.

1> That column is not sorting as desired, due to the number format in the cells. The commas in the values make the content a string, which is sorted differently to numbers.
This is not just happening in the WP-Table Reloaded tables, but in all tables.

2> Ok, I see. Well, this is not really a task for WP-Table Reloaded or TablePress. This is more something for the theme CSS. An easy first try could be to fix the table width to a px value, and not to the default of 100%. If that is not sufficient, some more work in the theme CSS is necessary.

Regards,
Tobias

Hi Tobias,

I think the extension plugin solved the string problem, as you will see in the table below, that was generated using TablePress
https://www.gurufundpicks.com/13f-4q2-vng

I believe whatever the extensions did to treat the string as numbers, is somehow not being applied to WP-Tables, with the custom coding that you had provided me earlier.

Regarding point#2, my columns have px width, so I will try making them wider and see if that helps.

Thanks,

Ganaxi