WebFX WebBoard
Message Thread:
View All Messages
Back to WebFX
 Sortable Tables - Sort column according to hidden value (is this case a date), Pete, December 22, 2004
     Re:Sortable Tables - Sort column according to hidden value (is this case a date), Erik Arvidsson, December 31, 2004
         Re:Sortable Tables - Sort column according to hidden value (is this case a date), Pete, January 12, 2005
     Re:Sortable Tables - Sort column according to hidden value (is this case a date) , Guilherme Blanco, December 29, 2004
     Re:Sortable Tables - Sort column according to hidden value (is this case a date), Jeffrey Jangli, December 23, 2004
         Re:Sortable Tables - Sort column according to hidden value (is this case a date), Pete, December 23, 2004
             Re:Sortable Tables - Sort column according to hidden value (is this case a date), Jeffrey Jangli, December 23, 2004

Subject: Re:Sortable Tables - Sort column according to hidden value (is this case a date) From: Pete Date: December 23, 2004

First off, thanks for the prompt response.

Secondly, can you or someone please show me an example of how you would "HIDE" the this column. I understand the concept, in fact i've even tried it myself. but I guess this is really where the magic in solving this problem is.

 

 thanks in advance.

From: Jeffrey Jangli
Sent: December 23, 2004
Subject: Re:Sortable Tables - Sort column according to hidden value (is this case a date)

Yes this is possible!

Let me try to explain, i use this table:

ID         ISO_DATE       NICE_DATE     DESCRIPTION

3          20041222          22 december      Blaa 1
4          20041219          19 december      Blaa 2

The trick is to HIDE the ISO_DATE colum, so that it only displays like so:
ID        NICE_DATE     DESCRIPTION

3          22 december      Blaa 1
4          19 december      Blaa 2

But you can still use the ISO_DATE column for sorting when clicked on the header, the NICE_DATE column will then always be sorted right.

Jeffrey

    Is it possible to display a date like "Dec 22" , "Jan 5th". But sort according to a hidden date  i.e. (Dec 1, 12-01-04)  (Dec 22, 12-22-04) and (Jan 5, 01-05-05), (Feb 15, 02-15-05)

   Such that the resulting sort would be as follows:

  (Dec 1,Dec 22, Jan 5, Feb 15) or (Feb 15, Jan 5, Dec 22, Dec 1)






Reply
Name: 
Email: 
Subject: 

Enter your reply to this message below. HTML tags are not supported but words that start with http://, ftp:// or mailto: are converted to links.


View All Messages
Back to WebFX