JQuery table sorter

On the topic of paging and long lists, I just added 1700 rows to an
HTML page with the Jquery table sorter plugin, and it seems very
performant:

http://109.74.202.200:8080/who_ihr_poe/out/docs/ports.html

···

--
Cheers,
Knut Staring

Notice you can sort on all the table headings.

···

On Thu, May 6, 2010 at 1:43 AM, Knut Staring <knutst@gmail.com> wrote:

On the topic of paging and long lists, I just added 1700 rows to an
HTML page with the Jquery table sorter plugin, and it seems very
performant:

http://109.74.202.200:8080/who_ihr_poe/out/docs/ports.html

--
Cheers,
Knut Staring

--
Cheers,
Knut Staring

The jquery table sorter is quite cool but also a bit limited as it is
restricted to using html tables in the dom as its model and doesn't
naturally lend itself to server side pagination - though can be coaxed
no doubt.

http://datatables.net/index looks much better. All the features of
the above but much more flexible.

Not to mention the wonderful array of grid controls which come with
ext-all.js which is already distributed with dhis2 :slight_smile:

Cheers
Bob

···

On 6 May 2010 00:43, Knut Staring <knutst@gmail.com> wrote:

On the topic of paging and long lists, I just added 1700 rows to an
HTML page with the Jquery table sorter plugin, and it seems very
performant:

http://109.74.202.200:8080/who_ihr_poe/out/docs/ports.html

--
Cheers,
Knut Staring

_______________________________________________
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp

Wow. datatables.net examples look very slick.
Would really like to see this integrated into DHIS2!

···

On Thu, May 6, 2010 at 2:48 PM, Bob Jolliffe <bobjolliffe@gmail.com> wrote:

The jquery table sorter is quite cool but also a bit limited as it is
restricted to using html tables in the dom as its model and doesn't
naturally lend itself to server side pagination - though can be coaxed
no doubt.

DataTables | Table plug-in for jQuery looks much better. All the features of
the above but much more flexible.

Not to mention the wonderful array of grid controls which come with
ext-all.js which is already distributed with dhis2 :slight_smile:

Cheers
Bob

On 6 May 2010 00:43, Knut Staring <knutst@gmail.com> wrote:

On the topic of paging and long lists, I just added 1700 rows to an
HTML page with the Jquery table sorter plugin, and it seems very
performant:

http://109.74.202.200:8080/who_ihr_poe/out/docs/ports.html

--
Cheers,
Knut Staring

_______________________________________________
Mailing list: DHIS 2 developers in Launchpad
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : DHIS 2 developers in Launchpad
More help : ListHelp - Launchpad Help

_______________________________________________
Mailing list: DHIS 2 developers in Launchpad
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : DHIS 2 developers in Launchpad
More help : ListHelp - Launchpad Help

--
--
Jason P. Pickering
email: jason.p.pickering@gmail.com
tel:+260968395190

Wow. datatables.net examples look very slick.
Would really like to see this integrated into DHIS2!

It is really nice. Thanks to the tip from Bob, I have now updated the
ports example and moved it:
http://bit.ly/aNVA9i

k

···

On Thu, May 6, 2010 at 3:28 PM, Jason Pickering <jason.p.pickering@gmail.com> wrote:

On Thu, May 6, 2010 at 2:48 PM, Bob Jolliffe <bobjolliffe@gmail.com> wrote:

The jquery table sorter is quite cool but also a bit limited as it is
restricted to using html tables in the dom as its model and doesn't
naturally lend itself to server side pagination - though can be coaxed
no doubt.

http://datatables.net/index looks much better. All the features of
the above but much more flexible.

Not to mention the wonderful array of grid controls which come with
ext-all.js which is already distributed with dhis2 :slight_smile:

Cheers
Bob

On 6 May 2010 00:43, Knut Staring <knutst@gmail.com> wrote:

On the topic of paging and long lists, I just added 1700 rows to an
HTML page with the Jquery table sorter plugin, and it seems very
performant:

http://109.74.202.200:8080/who_ihr_poe/out/docs/ports.html

--
Cheers,
Knut Staring

_______________________________________________
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp

_______________________________________________
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp

--
--
Jason P. Pickering
email: jason.p.pickering@gmail.com
tel:+260968395190

_______________________________________________
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp

--
Cheers,
Knut Staring

I have now added maps for (most of) the ports, showing OpenLayers with
OpenStreetMap in an iframe inside the table. This could be quite cool
for health facilities also.

http://bit.ly/aNVA9i

k

···

On Thu, May 6, 2010 at 3:28 PM, Jason Pickering <jason.p.pickering@gmail.com> wrote:

Wow. datatables.net examples look very slick.
Would really like to see this integrated into DHIS2!

On Thu, May 6, 2010 at 2:48 PM, Bob Jolliffe <bobjolliffe@gmail.com> wrote:

The jquery table sorter is quite cool but also a bit limited as it is
restricted to using html tables in the dom as its model and doesn't
naturally lend itself to server side pagination - though can be coaxed
no doubt.

http://datatables.net/index looks much better. All the features of
the above but much more flexible.

Not to mention the wonderful array of grid controls which come with
ext-all.js which is already distributed with dhis2 :slight_smile:

Cheers
Bob

On 6 May 2010 00:43, Knut Staring <knutst@gmail.com> wrote:

On the topic of paging and long lists, I just added 1700 rows to an
HTML page with the Jquery table sorter plugin, and it seems very
performant:

http://109.74.202.200:8080/who_ihr_poe/out/docs/ports.html

--
Cheers,
Knut Staring

_______________________________________________
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp

_______________________________________________
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp

--
--
Jason P. Pickering
email: jason.p.pickering@gmail.com
tel:+260968395190

_______________________________________________
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp

--
Cheers,
Knut Staring

That looks pretty cool. How easy is it to work with the table widget.
Shallow learning curve I hope?

···

On 8 May 2010 18:49, Knut Staring <knutst@gmail.com> wrote:

I have now added maps for (most of) the ports, showing OpenLayers with
OpenStreetMap in an iframe inside the table. This could be quite cool
for health facilities also.

http://bit.ly/aNVA9i

k

On Thu, May 6, 2010 at 3:28 PM, Jason Pickering > <jason.p.pickering@gmail.com> wrote:

Wow. datatables.net examples look very slick.
Would really like to see this integrated into DHIS2!

On Thu, May 6, 2010 at 2:48 PM, Bob Jolliffe <bobjolliffe@gmail.com> wrote:

The jquery table sorter is quite cool but also a bit limited as it is
restricted to using html tables in the dom as its model and doesn't
naturally lend itself to server side pagination - though can be coaxed
no doubt.

http://datatables.net/index looks much better. All the features of
the above but much more flexible.

Not to mention the wonderful array of grid controls which come with
ext-all.js which is already distributed with dhis2 :slight_smile:

Cheers
Bob

On 6 May 2010 00:43, Knut Staring <knutst@gmail.com> wrote:

On the topic of paging and long lists, I just added 1700 rows to an
HTML page with the Jquery table sorter plugin, and it seems very
performant:

http://109.74.202.200:8080/who_ihr_poe/out/docs/ports.html

--
Cheers,
Knut Staring

_______________________________________________
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp

_______________________________________________
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp

--
--
Jason P. Pickering
email: jason.p.pickering@gmail.com
tel:+260968395190

_______________________________________________
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp

--
Cheers,
Knut Staring

That looks pretty cool. How easy is it to work with the table widget.
Shallow learning curve I hope?

For what I have done, yes, I have mainly modified an example. But I
have not linked it to any serverside, this is all javascript and
(generated) html (i.e. you have access to all the source code :wink:

Unfortunately, I just discovered the clever javascript trick for the
zooming of the map URL doesn't work in IE, not even IE8 :frowning:

k

···

On Sat, May 8, 2010 at 8:04 PM, Bob Jolliffe <bobjolliffe@gmail.com> wrote:

On 8 May 2010 18:49, Knut Staring <knutst@gmail.com> wrote:

I have now added maps for (most of) the ports, showing OpenLayers with
OpenStreetMap in an iframe inside the table. This could be quite cool
for health facilities also.

http://bit.ly/aNVA9i

k

On Thu, May 6, 2010 at 3:28 PM, Jason Pickering >> <jason.p.pickering@gmail.com> wrote:

Wow. datatables.net examples look very slick.
Would really like to see this integrated into DHIS2!

On Thu, May 6, 2010 at 2:48 PM, Bob Jolliffe <bobjolliffe@gmail.com> wrote:

The jquery table sorter is quite cool but also a bit limited as it is
restricted to using html tables in the dom as its model and doesn't
naturally lend itself to server side pagination - though can be coaxed
no doubt.

http://datatables.net/index looks much better. All the features of
the above but much more flexible.

Not to mention the wonderful array of grid controls which come with
ext-all.js which is already distributed with dhis2 :slight_smile:

Cheers
Bob

On 6 May 2010 00:43, Knut Staring <knutst@gmail.com> wrote:

On the topic of paging and long lists, I just added 1700 rows to an
HTML page with the Jquery table sorter plugin, and it seems very
performant:

http://109.74.202.200:8080/who_ihr_poe/out/docs/ports.html

--
Cheers,
Knut Staring

_______________________________________________
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp

_______________________________________________
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp

--
--
Jason P. Pickering
email: jason.p.pickering@gmail.com
tel:+260968395190

_______________________________________________
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp

--
Cheers,
Knut Staring

--
Cheers,
Knut Staring

Fixed that, was caused by a superfluous trailing comma.

Even works in IE6, though a bit sluggish.

Knut

···

On Sat, May 8, 2010 at 8:33 PM, Knut Staring <knutst@gmail.com> wrote:

Unfortunately, I just discovered the clever javascript trick for the
zooming of the map URL doesn't work in IE, not even IE8 :frowning:

Have given it a go for facilities - even Chrome couldn't really handle
a table of 6700 for Kenya, though, so had to select one province.

You can see it here (click, then default login to DHIS2, then click again):
http://109.74.202.200:8080/ke/MFL/mfl.html

k

···

On Sat, May 8, 2010 at 7:49 PM, Knut Staring <knutst@gmail.com> wrote:

I have now added maps for (most of) the ports, showing OpenLayers with
OpenStreetMap in an iframe inside the table. This could be quite cool
for health facilities also.

http://bit.ly/aNVA9i

k

On Thu, May 6, 2010 at 3:28 PM, Jason Pickering > <jason.p.pickering@gmail.com> wrote:

Wow. datatables.net examples look very slick.
Would really like to see this integrated into DHIS2!

On Thu, May 6, 2010 at 2:48 PM, Bob Jolliffe <bobjolliffe@gmail.com> wrote:

The jquery table sorter is quite cool but also a bit limited as it is
restricted to using html tables in the dom as its model and doesn't
naturally lend itself to server side pagination - though can be coaxed
no doubt.

http://datatables.net/index looks much better. All the features of
the above but much more flexible.

Not to mention the wonderful array of grid controls which come with
ext-all.js which is already distributed with dhis2 :slight_smile:

Cheers
Bob

On 6 May 2010 00:43, Knut Staring <knutst@gmail.com> wrote:

On the topic of paging and long lists, I just added 1700 rows to an
HTML page with the Jquery table sorter plugin, and it seems very
performant:

http://109.74.202.200:8080/who_ihr_poe/out/docs/ports.html

--
Cheers,
Knut Staring

_______________________________________________
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp

_______________________________________________
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp

--
--
Jason P. Pickering
email: jason.p.pickering@gmail.com
tel:+260968395190

_______________________________________________
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp

--
Cheers,
Knut Staring

--
Cheers,
Knut Staring

I see it's sorting beds alphabetically, but I guess that is possible to change..

Jo

···

Den 9. mai 2010 kl. 16.53 skrev Knut Staring:

Have given it a go for facilities - even Chrome couldn't really handle
a table of 6700 for Kenya, though, so had to select one province.

You can see it here (click, then default login to DHIS2, then click again):
http://109.74.202.200:8080/ke/MFL/mfl.html

Maximum Tries exceeded... Please try after 0 mins :frowning:

···

On 9 May 2010 15:53, Knut Staring <knutst@gmail.com> wrote:

Have given it a go for facilities - even Chrome couldn't really handle
a table of 6700 for Kenya, though, so had to select one province.

You can see it here (click, then default login to DHIS2, then click again):
http://109.74.202.200:8080/ke/MFL/mfl.html

k

On Sat, May 8, 2010 at 7:49 PM, Knut Staring <knutst@gmail.com> wrote:

I have now added maps for (most of) the ports, showing OpenLayers with
OpenStreetMap in an iframe inside the table. This could be quite cool
for health facilities also.

http://bit.ly/aNVA9i

k

On Thu, May 6, 2010 at 3:28 PM, Jason Pickering >> <jason.p.pickering@gmail.com> wrote:

Wow. datatables.net examples look very slick.
Would really like to see this integrated into DHIS2!

On Thu, May 6, 2010 at 2:48 PM, Bob Jolliffe <bobjolliffe@gmail.com> wrote:

The jquery table sorter is quite cool but also a bit limited as it is
restricted to using html tables in the dom as its model and doesn't
naturally lend itself to server side pagination - though can be coaxed
no doubt.

http://datatables.net/index looks much better. All the features of
the above but much more flexible.

Not to mention the wonderful array of grid controls which come with
ext-all.js which is already distributed with dhis2 :slight_smile:

Cheers
Bob

On 6 May 2010 00:43, Knut Staring <knutst@gmail.com> wrote:

On the topic of paging and long lists, I just added 1700 rows to an
HTML page with the Jquery table sorter plugin, and it seems very
performant:

http://109.74.202.200:8080/who_ihr_poe/out/docs/ports.html

--
Cheers,
Knut Staring

_______________________________________________
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp

_______________________________________________
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp

--
--
Jason P. Pickering
email: jason.p.pickering@gmail.com
tel:+260968395190

_______________________________________________
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp

--
Cheers,
Knut Staring

--
Cheers,
Knut Staring

Have given it a go for facilities - even Chrome couldn't really handle
a table of 6700 for Kenya, though, so had to select one province.

You can see it here (click, then default login to DHIS2, then click again):
http://109.74.202.200:8080/ke/MFL/mfl.html

I see it's sorting beds alphabetically, but I guess that is possible to change..

Thanks, fixed now. Was caused by a trailing whitespace, like this: <td>65 </td>

Knut

···

On Sun, May 9, 2010 at 5:24 PM, Jo Størset <storset@gmail.com> wrote:

Den 9. mai 2010 kl. 16.53 skrev Knut Staring:

Jo

--
Cheers,
Knut Staring