thank you / jQuery sorting bug / clickable data columns for query

[Paul Traina]

First off Andrew, I just wanted to say thank you for table gear! It
is absolutely lovely to be able to use this.

I've built a lightweight CRM for our non-profit and use TG for all of
our reports.
We're using TG in a read only mode (no editable cells).

1. Bug report -- sorting

TG 1.6.1 jQuery version (does not happen in the MooTools version!)
Happens with jQuery 1.5.1 min also the same jQuery that you are using
(I think 1.4.2 from google apis) in your example table.

I have about 15 entries in my view, all indexed off of a SQL datetime
variable. If I click on any of the column headers, the sorting is not-
random but very wrong. I noticed that in some instances, the sorting
occurs for the next (wrong) column over, but this is not consistent
among columns.

For example

A B C D E

If I click on B, C will be sorted in ascending order.

If I look at the HTML that the .php file generated, everything looks
absolutely lovely and everything is being rendered perfectly, just
sorting is whacked. I can provide you with a private copy of the
table I was using to generate the bad page, but it needs to be via
private e-mail as I can't really sanitize it.

Hope this helps get you started. Again, mootools version works great.

2. Feature idea --> click to follow generated link for non-editable
cells...

I'm generating weekly traffic reports for our call in switchboard.

We generate tables that look something like (for the last 7 days):

http://foo.org/report?type=last7days

date clientname agent synopsis prognosis

4/1 freddy paul foo bar

It would be lovely if, when I click on freddy, I could generate a new
page that contained ALL of freddy's call history.

i.e. I'd love if freddy's cell was richtext and by clicking on freddy,
I could generate a URL to http://foo.org/report?type=clientreport&client=freddy

Any ideas or suggestions on how that might be doable now? I may have
missed something subtle.

Again, thanks so much for your awesome work. I was starting to write
my own report generator and yours is 20x better than anything I would
have come up with.

[Andrew]

Thank you for the feedback.. Unfortunately I've been far too lax in
responding to feedback recently but I'm hoping to rectify that... I'll
have a look asap and see what I can do...

Andrew

[Paul Traina]

Just to follow-up...

Figured out how to do the feature using transforms, thanks!

[Paul Traina]

Final followup -- the sorting bug I saw in v1.6.1 for jQuery is not
reproducible in 1.6.2, so both mootools and jQuery versions are
working again for me.

Thank you!

[Andrew Plummer]

Good to hear!