Category: Tablesorter

{syntax type="tiki" editor="plain"}
On a Tiki27 where I don't use jQuery sortable tables.
I set a fancytable wikiplugin to display 2 columns side by side.
One contain a diagram (wiki plugin image) the second some text.

Under the fancytable the following warning is displayed even for anonymous:
"The jQuery Sortable Tables feature must be activated for the sort feature to work."

Add tablesorter UI to Payments list for easier filtering of real data when many payments done.

Currently there is even no pagination at all. So when many records are there, it's not easy to find who payed whet, when, by whom, etc.

---
We have a dbdump already with a few data on it (of real small transaction with paypal), that we could share with a dev willing to implement this feature, in case this helps the development with fake-ish but real transaction data from paypal in production, not sandbox.
At: http://15x.notre.website

Please, ask me, for instance, and I'll fetch a db dump for you with admin pw reset for you.

I tried to understand if it was possible and how to use the tablesorter with tracker filter plugin.

The trackerfilter modal is NOT user-friendly.
Too long list of things the user may not necessarily needed (menu child accordions would definitely help reducing the tremendous amount of information visible there)
The explanation have been copied and pasted as is from another place and hardly make sense.
Fields are not grouped together, naming is not helping (table sorter is hardly if ever found in the options and parameters list or help)... It is a mess and it took me 30mn of test to make a sample visible here : https://doc.tiki.org/PluginTrackerFilter#Trackerfilter_with_table_sorter_setting_to_perform_calculations

Fancy table
code works in ver 15 but copy and paste into ver 18 causes fault to table sorter list.
The common name shows data function list.
I have used tikiwiki syntax ((around common name)) to make page link.
in ver 15 it works, but the same code in 18 caused common name list to expand and show data function list
If you remove the (( )) the problem disappears
Update
it works on the show.tiki site fancy table page
I am running ver 18 on a home server (debian linux) does this mean the jquery or javascript on the server is wrong or the ver 18 installation
version 15 is on the same server and works okay.


example

{DIV(class="row")}{DIV(class="col-md-12")}{FANCYTABLE(colwidths= "5%|10%|20%|10%|30%|25%" head=" Flower|Common name| Type | Picture | Seedling" sortable="type:reset" sortList="[0,0],[1,1],"tsortcolumns="type:word;group:word|type:word;group:word|type:word;group:word|type:nofilter|type:nofilter|type:nofilter" tsfilters="type:dropdown|type:dropdown|type:dropdown|type:nofilter|type:nofilter|type:nofilter " tsfilteroptions="type:reset" tspaginate="max:50")}
white|((Bittercress))|rosette|{img fileId="286" thumb="box" desc="name"}|{img fileId="287" thumb="box" desc="name"}
yellow|((Buttercup))|rosette spreading|{img fileId="356" thumb="box" desc="name"}|{img fileId="288" thumb="box" desc="name"}
white|((Bramble))|Climbing Tall|{img fileId="369" thumb="box" desc="name"}|{img fileId="355" thumb="box" desc="name"}
{FANCYTABLE}{DIV}{DIV}

Tablesorter doesn't seem to load when the tiki 12 lts is shown in mobile mode.

Similar approach works on 14.x, but it wpuld be lovely to have our LTS branch work in mobile also

Reproduced here:
http://xavi-9794-5655.show.tikiwiki.org/tiki-index.php?page=Sortable+Tables+demo#step2

U: admin
P: 12345

Switch to mobile and see how the tablesorter ui is lost

There are some tips elsewhere about how to fix this type of issue (I wonder if it's the same or not):
https://forum.jquery.com/topic/tablesorter-with-jquery-mobile#14737000003054153

jQuery tablesorter allows to control the maximum number of rows to display in a table. When the number of data records exceeds that maximum, the pager widget or the pager plugin paginates the data on multiple pages. tablesorter, for example on tiki-listpages.php, therefore displays a pager area which at the top of each table. This area provides controls to change the maximum number of rows in a page and to select the page to display, as can be seen in the attached screenshot.

This area can not only display at the top of tables, but also at the bottom, so that when one scrolls through a dataset from start to finish, there is no need to go back to the top to continue to the next page. There is however an optimization so that the pager does not display twice at the same time in the viewport. lib/core/Table/Code/Bind.php line 33-39 (in Tiki 18) either show or hide the bottom pager:
{CODE(colors="php" theme="default")}
if (this.config.pager.endRow - this.config.pager.startRow > 15) {
$('div#listpages1-pager.ts-pager-bottom').css('display', 'block');
} else {
$('div#listpages1-pager.ts-pager-bottom').css('display', 'none');
}
{CODE}

This is based on a rule of thumb which estimates that a viewport fits 15 rows. When browsing 70 records and viewing records 1 to 25, endRow has the value 25 and startRow has the value 0, so the difference between the 2 is 25, which is more than 15. Therefore, the bottom pager's div is displayed.

This code is run whenever the pager is used, plus at page load. The code works fine once the page has finished loading, but on page load, it is unfortunately fragile. When this code is first run, endRow has the value 0, so the difference is always 0 and display is always set to none. The initial display is fine in Tiki 15 up to 17 because this code (which runs when the tablesorter-ready event occurs) runs several times during page load, and endRow has the correct value the last time the code runs. In Tiki 18 the code only runs once per page load. This would be a good thing for performance, except that this one run is unfortunately too early, so the difference is always 0.

As I verified Tiki's related code seems unchanged between Tiki 17 and 18, I imagine this regression comes from the upgrade of jQuery tablesorter from 2.28.5 to 2.31.1. This persists in Tiki 19, and in trunk as of r70207.

The plugin Listpages does not sort by fields. It displays the data, but any attempt to click on a field header yields an error like

Unknown column 'versions' in 'order clause'

The query was:
SELECT *, ROUND(MATCH(`categories`) AGAINST ('wiki page'),2) AS `score` FROM `index_567872dfcd0a9` WHERE 1=1 AND (`searchable` = 'y' AND `object_type` = 'wiki page' AND MATCH (`categories`) AGAINST ('tokenctxxx' IN BOOLEAN MODE) AND `modification_date` BETWEEN '2013-12-31 23:00:00' AND '2015-08-21 21:10:52') ORDER BY `versions` asc

And in fact the field versions does not exist, but I don't know how to rebuild the Listpages, so that it does not look for it.
This is the element in the page that causes the error:
{listpages initial="APagePattern:_:" showNameOnly="n" categId="1" structHead="n" showPageAlias="y" sort="pageName_asc" showCheckbox="n"}

This problem is not present on 12, but appears immediately when migrating the data to 14.x.
Great work guys, and thank you so much,
Hubert

Navbar overlapping tablesorter heading row (col titles, filter and col select icons)
As reported by Gary in the devel list:
https://tiki.org/tiki-view_forum_thread.php?threadId=60288

See it reproduced here:
(you may need to use Chrome or Firefox to view this .webm (VP8) video in your browser)

{mediaplayer src="https://tiki.org/display1083" style="native" type="video/webm"}

See this section of a plugin trackerlist that should produce a table of tracker items:

Failing to load in 17.x:
https://dev.tiki.org/Profiles-Wizard#Closed

Working in trunk:
https://nextdev.tiki.org/Profiles+Wizard#Closed

Error in the inspector :
{CODE()}
Uncaught TypeError: Cannot read property 'childNodes' of null
at qa (min_main_8586bd0….js:sourcemap:176)
at Ja (min_main_8586bd0….js:sourcemap:176)
at a.fn.init.append (min_main_8586bd0….js:sourcemap:176)
at a.fn.init.<anonymous> (min_main_8586bd0….js:sourcemap:176)
at T (min_main_8586bd0….js:sourcemap:176)
at a.fn.init.html (min_main_8586bd0….js:sourcemap:176)
at Object.format (Profiles-Wizard:3748)
at Object.processOptions (min_main_8586bd0….js:sourcemap:7026)
at Object.getOptionSource (min_main_8586bd0….js:sourcemap:7024)
at Object.buildSelect (min_main_8586bd0….js:sourcemap:7032)
{CODE}

There are warnings before the error:
{CODE(theme="default")}min_main_8586bd006813c3eea36df705ff53807c.js:6888 Tablesorter Warning! "table.config.widgetOptions.resizable" option not recognized
validateOptions @ min_main_8586bd006813c3eea36df705ff53807c.js:6888
setup @ min_main_8586bd006813c3eea36df705ff53807c.js:6713
(anonymous) @ min_main_8586bd006813c3eea36df705ff53807c.js:6892
each @ min_main_8586bd006813c3eea36df705ff53807c.js:175
each @ min_main_8586bd006813c3eea36df705ff53807c.js:175
$.fn.tablesorter @ min_main_8586bd006813c3eea36df705ff53807c.js:6892
(anonymous) @ Calendar:28998
j @ min_main_8586bd006813c3eea36df705ff53807c.js:175
k @ min_main_8586bd006813c3eea36df705ff53807c.js:175
setTimeout (async)
(anonymous) @ min_main_8586bd006813c3eea36df705ff53807c.js:175
i @ min_main_8586bd006813c3eea36df705ff53807c.js:175
fireWith @ min_main_8586bd006813c3eea36df705ff53807c.js:175
fire @ min_main_8586bd006813c3eea36df705ff53807c.js:175
i @ min_main_8586bd006813c3eea36df705ff53807c.js:175
fireWith @ min_main_8586bd006813c3eea36df705ff53807c.js:175
ready @ min_main_8586bd006813c3eea36df705ff53807c.js:175
S @ min_main_8586bd006813c3eea36df705ff53807c.js:176{CODE}

This affects the wishes alias.

There are some issues with dropdowns and tablesorter data with trackers.
Reproduced in a show.t.o instance (just after the bug item is created):
http://xavi-9794-5607.show.tikiwiki.org/tiki-index.php?page=Wants
u: admin
p: 12345


(1) Tracker item status displayed in a PluginTrackerList as dropdown has no values (this is fixed in Tiki14.x, it seems). Fixing in 12.x LTS will be appreciated.

Response: This is not backportable to 12x unfortunately. This ability sort and filter based on the image title wasn't added until tablersorter version 2.17.5 and Tiki 12 uses 2.14.4. But I have fixed as much as possible and it is now possible to filter using o, p or c in 12x

(2) Dropdown field. An item has no value for that field. How do you select those records with empty value? Could some filter like "empty/not empty" be added to the fitlers?

Response: I don't see an easy way to do this. Would suggest using the sorting to sort empties to the top, or in some cases setting dropdowns or range properly could capture empties (e.g., if they actually have a 0 value). Will ask the tablesorter developer for a fix.

(3) when the order of the fields in the plugin trackerlist doesn't match the order of the fields in the tracker definition, the results are unexpected: it seems to overrule the order in the trackerdefinition.

Response: after further discussion this is not an issue - the sort parameter needs to be set to y for columns to follow the order of the field parameter.

Thanks in advanced!

On most of Tiki list/tables (if not all) when you have sorting tools you have first to click on the header to activate it.
It sort the items in ascendant order based on this column and you can see the ascendant arrow.

When the sorting is based on a text column, the order of the items based on subject col is really weird to the viewer. (see: https://dev.tiki.org/tiki-view_tracker.php?sort_mode=f_26_asc&trackerId=5)

Tablesorter doesn't allow to filter on Tracker item status

See it reproduced here:
https://dev.tiki.org/Trackers#Pending_and_Closed

Tablesorter doesn't allow to sort on tracker item status

See it reproduced here:
https://dev.tiki.org/Trackers#Pending_and_Closed

Reproduced here:
http://xavi-9794-6037.show.tikiwiki.org/tiki-index.php?page=Tracker_as_Calendar_12#contentTracker_as_Calendar_Tabs-2
u: admin
p: 12345

See field "Location" shown as text input field, evevn if defined as dropdown.
When you change the param server=y to server=n, dropdown is shown as expected.

On a Tiki forum when it is enable Tablesorter is added to the table that list the forum to allow filtering and sorting. Work fine if you have only Forums.
When you use subforum discussions the table sorter is interfering as it is working on the subform list instead of continuing to filter/sort the discussion below.

The tablesorter filter row is placed above the subforums list instead of the discussion list it should be moved below to be applied on the discussions.

TableSorter header from bug tables disappeared when using plugin alias (wishes - plugin trackerlist)

Example: https://dev.tiki.org/TableSorter
(which uses plugin alias syntax WISHEs - which is a tackerlist plugin)
{CODE()}
{wishes filtervalue="307" status="o"}
{CODE}

Example where it's working: https://dev.tiki.org/Tiki18
which uses plugin list syntax

See this code:

{CODE()}
{TRACKERLIST(trackerId="6" fields="20:27:31:33:34:43:46:36" showstatus="y" status="op" sortable="y" server="y" editable="43" tsfilters="type:text|type:text|type:text|type:text|type:date;format:yy-mm-dd;from:2016-06-01;to:2016-12-31|type:date;format:yy-mm-dd;from:2016-06-01;to:2016-12-31|type:date;format:yy-mm-dd;from:2016-06-01;to:2016-12-31|type:dropdown" showlinks="y")}{TRACKERLIST}
{CODE}

The tsfilters code __type:date;format:yy-mm-dd;from:2016-06-01;to:2016-12-31__ is now {sign user="xavi" datetime="2016-08-12T09:19:21+00:00"} in trunk applied (so that items without date or not matching the date range are filtered out), while in Tiki 15 they were just used to preselect the date of the rate range filter, but those date ranges were not applied (items without date or not matching the date range where also shown in the results of the table).

---
If this is confirmed as a regression and fixed in trunk, I reckon that we need to revert this commit I made before I knew that this looked like a regression:
{CODE()}
[ENH]Warn the user that this apparently is the new default behavior for 16.x. Probably feature fix since it makes more sense to be like this, but it was not the default behavior until short ago, afaik. Subversion: Committed revision 59430.
{CODE}
---
Fixed reference to affected branch. It was trunk, and at the time of the bug reporting, that meant 16.x. This issue is not seen any more in 16.x, however, it is in trunk still. Therefore, I tagged it against 17.x and 17.x regression. {sign user="xavi" datetime="2017-01-03T23:23:27+00:00"}

Reproduced here:
http://xavi-9794-6200.show.tikiwiki.org/tiki-index.php?page=Bug6201
Last column for LastModif
u: admin
p: 12345

Currently using:
Last update from SVN (17.0svn): Tuesday December 13, 2016 15:09:21 CET - REV 60628 (MyISAM)

And using 16.x, reproduced here:
https://demo.tiki.org/16x/tiki-index.php?page=Homepage+for+user+Gc
u: admin
p: 12345

Hi,

when TrackerList is in TableSorter mode and set to 'custom column filters' it puts a filter on all columns, even with ones having the parameter 'type: nofilter'. Tested on several different sites, same thing.

here is a screen shot (fields in red are set to 'type: nofilter'):

{img fileId="1051" thumb="box"}

br,
Mike

---
You can see it reproduced here:
http://mikeua-11714-6019.show.tikiwiki.org/tiki-index.php?page=Sortable+Tables+demo#Example_2:_Tiki_translations
u: admin
p: 12345

at the field "Native Name"

At least in 21.x and trunk the sorting widgets in the header cells is now white on white and thus invisible.

e.g. here: ((doc:Tablesorter))

This seems to be a regression in the library (or bootstrap 4) as i'm also finding this in a custom implementation on a client site.

This used to work in the past at some point with some Tiki 12.x, according to the documentation written by lindon.
But it fails for me as soon as I set "server=y" in the params of Plugin TrackerList.

I've set up (modified) the profile Barter_Market so that the nice Tablesorter feature can be demonstrated (with server=n so far, of course) for the list of available wants.

This also allows to easily reproduce a failing environment (replace it to be server=y, etc). It has also been reproduced in a show.t.o instance attached to this bug report.

http://xavi-9794-5606.show.tikiwiki.org/tiki-index.php?page=Wants
u: admin
p: 12345

Filter for antything, and it won't work. Change param server=y to server=n and it will work again (except for the filtering on a tracker field "items_list": tracker_wants_offers_same_user).

In Tiki 12.x, you can filter for the field items_list tracker_wants_offers_same_user with no problems (provided server=n of course), but you can't filter on the status (which does work nicely in 14.x).

This tablesorter thing looks promising indeed! Thanks lindon!!!

Tablesorter: dropdowns in tsfilters and shown as text filters (most of them) when server=y

Reproduced at the show instance from this related report:
https://dev.tiki.org/item6200

http://xavi-9794-6200.show.tikiwiki.org/tiki-index.php?page=Bug6202
u: admin
p: 12345

edit the page, and you will see that many of the filters where set as dropdowns, However, they are shown as text filters.

Tablesorter: filtering for an item doesn’t find it if not in the first pagination when server=y


It was going to be reproduced at this show instance but for some reason, I cannot reproduce the issue that we have seen in a development site for a client. :-/

In any case, for the record:
http://xavi-9794-6200.show.tikiwiki.org/tiki-index.php?page=Bug6200
u: admin
p: 12345

FYI: this show instance is also used to demonstrate the issues reported in the bug reports:
https://dev.tiki.org/item6201
https://dev.tiki.org/item6202

Tablesorter: with server=n tspaginate is not taken into account (we did set max:2 and it keeps displaying all the 5 items) when js minification is enabled.


Reproduced at the show instance from this related report:
https://dev.tiki.org/item6200

http://xavi-9794-6200.show.tikiwiki.org/tiki-index.php?page=Bug6201
u: admin
p: 12345


{CODE()}
{trackerlist trackerId="1" fields="4:2:3:1:5:8:9:10" showlinks="y" popup="6:7" editableall="y" sortable="y" showstatus="y" status="opc" tsfilters="type:text;placeholder:|type:dropdown;placeholder:|type:nofilter|type:dropdown;placeholder:|type:text;placeholder|type:dropdown;placeholder:|type:dropdown;placeholder:|type:dropdown;placeholder|type:dropdown;placeholder|type:text;placeholder" tspaginate="max:2;expand:5;expand:10;expand:20" showpagination="n" max="-1" server=n}
{CODE}

Disable minifcation cehckboxes in the control panels, and it worked for me as expected.

See for example https://nextthemes.tiki.org/tiki-listpages.php?cookietab=2#tab2 (next/next for auth) or https://themes.tiki.org/tiki-listpages.php?cookietab=1#contenttabs_wikipages-1

Use table sorter with plugin list or customSearch to perform sum values from a field