Sortable Board Columns

[Chris]

No longer works

Back in the V5 alpha days we had the ability to sort columns in boards such as subject, last reply, etc. but it was taken away from us because we were bad (and there was a bug with it trying to sort on search results -- requires a board_id). This simple plugin aims to restore what was lost.

Sortable Board columns

It is left editable so you can add more bugs...

---

(version 0.0.2) took out some bugs to make room for more

• concatenating classes to element.className resulted in multiple duplicate classes so switched to tried and true addClass from jquery library
  
• Determined sort direction based on sort criteria returned by autosearch identifying which header icons should be individualized
  
• Switched to jquery toggleClass to choose icon class
  
• Switched back to 'afterSearch' instead of 'pageChange' to handle sorts and properly update icons.
  
• Handle column header hover cursor change (pointer/hand) via CSS

(version 0.0.3)

• added ability to choose a predefined order when a board loads

(version 0.0.4)

• sorting by subject somehow got broken along the way, the "main" reason is however known

[Lynx]

Chris,

The Dropbox download doesn't seem to be active (private, maybe?). It shows the name, but no download button.

[Peter]

Lynx ,

Download works fine for me...

[aRMY83]

Have to agree with Lynx, as that link does not download:

[Gene Hunt]

Downloaded and installed. Great plug in this.

I have one question though... Once I've sorted columns in a board, how do I revert the sorting back to the default sort order as ordering them by last post appears to ignore sticky threads.

GH.

[Chris]

Jun 12, 2016 1:33:29 GMT -8 Lynx said:

Chris ,

The Dropbox download doesn't seem to be active (private, maybe?). It shows the name, but no download button.

Jun 12, 2016 4:34:03 GMT -8 aRMY83 said:

Have to agree with Lynx , as that link does not download:

I opened the link in an incognito window and saw what you meant, so modified the url from "dl=0" to "dl=1" and it automatically opened a download window (you apparently need to be recognized as a dropbox user via cookies or LS in order to download in that config, or click the "no thanks" link at the bottom of the dialog ). Thanks for the heads up and please let me know if there is still no joy.

Jun 12, 2016 4:44:56 GMT -8 Gene Hunt said:

Downloaded and installed. Great plug in this.

I have one question though... Once I've sorted columns in a board, how do I revert the sorting back to the default sort order as ordering them by last post appears to ignore sticky threads.

GH.

The sorting hat will only take your decisions into consideration when it is an announcement (or so it appears from that 10 second test I just did), click the board name in the breadcrumb to discard any sorting order and return to standard. The plugin has no control over what and what does not get sorted since that is done on the backend.

[Gene Hunt]

Ok. Got that - thanks.

Only other thing I can see (maybe I'm overlooking something) is that when I try to sort by 'views' I can't figure how it is sorting as the number of views is not in order, even after a second click. As I say perhaps I'm overlooking something here.

Again, great plugin.

GH.

[Lynx]

Download worked perfect for me now. Thanks, Chris!

[aRMY83]

Got the download. Thanks Chris

[Chris]

Jun 12, 2016 6:33:39 GMT -8 Gene Hunt said:

Ok. Got that - thanks.

Only other thing I can see (maybe I'm overlooking something) is that when I try to sort by 'views' I can't figure how it is sorting as the number of views is not in order, even after a second click. As I say perhaps I'm overlooking something here.

Again, great plugin.

GH.

My tests shows the views column toggling between ascending and descending, of course the one announcement thread I temporarily made for testing purposes remains unaffected and at top of the list of threads. It could be a theme glitch in which case you would need to give details (e.g. a forum link) so it can be investigated.

ETA: I should note that subsequent clicks are suppose to toggle between ascending sort order and descending sort order, so 1,2,3,4,5,6 should turn into 6,5,4,3,2,1 on the second click then back on an additional click and so on...

[Gene Hunt]

Thanks for this. I have three themes installed and it's doing it on all of them.

43tv

GH.

[Chris]

I unfortunately am unable to see the plugin installed at the given address in order to observe and diagnose the described behaviour.

[Gene Hunt]

Jun 12, 2016 22:20:57 GMT -8 Chris said:

I unfortunately am unable to see the plugin installed at the given address in order to observe and diagnose the described behaviour.

Can you try it now ? I had it set for staff only. I have temporarily granted access to all.

GH.

[Chris]

Gene Hunt , I am observing the weird sorting you described but am at a loss for an explanation just yet. The XML request is identical (in properties included) to the request sent out on this forum when sorting via views, does that forum sort views properly for you like it does for me? I've already ruled out viewing as guest versus as a logged in member using an incognito window to also rule out tracking cookies.

Other possibilities I wish to pursue include checking the age of the forum (via admin register date) which I cannot do since the profile on that forum is hidden from guests. The thinking here is that there could be remnant data involved with older forums that may have been upgraded from previous Proboards version, since "views" are not included in the V5 meta data for threads so must be using a legacy data system.

SPOILER: Click to show

{
 "board_id": 96,
 "first_post_id": 6729241,
 "created_by": 65613,
 "is_bookmarked": 0,
 "is_new": 0,
 "subject": "Sortable Board Columns",
 "id": 586943,
 "created_on": 1465704138,
 "last_post_id": 6730581,
 "is_announcement": 0,
 "is_sticky": 0,
 "url": "/thread/586943/sortable-board-columns",
 "last_post_time": 1465833938,
 "is_poll": 0,
 "is_falling": 0,
 "is_locked": 0
}

The comparison forum for full disclosure was updated from v4.5 to v5 but if upgrades from v4 or even v3 is involved then that could have bearing.

The fact that the board also contains sub-boards might also be a factor since I can observe inconsistencies with the numbers returned for the views column when the board contains sub-boards as opposed to not and I'll conclude is probably related to the inconsistent view counts plaguing V5 every so often.

SPOILER: Click to show

This however does not explain why a sticky topic having 1,480 views ends up getting sorted between a thread with 367 and 707 views... unless the sorting algo on the backend is somehow getting thrown off by the presence of a comma in the number and is instead viewing it as 1,480. There also seems to be some sort of categorization going on with multi-page threads since I see those being sorted as a group in ascending order then a new group starting over with lowest number just for single page threads.

For now, uncheck views in the plugin settings to disable sorting by that column while I try to investigate further. It could very well be one of the reasons why this feature was removed and also suspect why there has been a recurring race conditions with view counts in V5 ever since a fifteen minute delay was introduced between logout and one's name finally disappearing from the online users list.

Disclaimer: the above is based on pure conjecture and Proboards has not been given a chance to confirm or deny any conclusions which might have been reached during the creation of this post

[Gene Hunt]

Hi Chris,

Thanks for this in depth effort. It is appreciated.

I've check the forum you linked and sorting by "views" is working perfectly there.

The forum was created by myself in March 2015.

I have now unchecked "Views" from the sorting list as requested.

Hope this info helps in some way and again, thanks for looking into it. The plug in is certainly worth persevering with.

GH.