I’ve got a table of 60 rows and 5 columns. the first column in a row contains a date and the other 4 columns in the row have data associated with the date.
I’d like to sort the table by column 1 - like the way you can do a sort in 1-2-3 or excel. Does anyone have any suggestions on a efficient way to code this kind of sort?
Thanks …
Ron
Subject: sorting a table
It sounds like you mean you have a table on your form with a field in each cell. The best way to sort this is with LotusScript code using the back-end methods (NotesDocument). The best time to do it is probably when the user requests it or when they save the document. The technique should involve creating a custom class or datatype with the contents of a row in it, then just using a brain-dead technique like exchange sort to sort these in an array, and copy the results back into fields. You could keep track of the initial position of the cursor so as to put it back at the new position of the same row.
Subject: Sorting tables in any Notes doc
Tables in Notes documents are a great feature…Just … if only there were an agent or so to sort a table by any column, or filter them (like in Excel).
Maybe the way to do it is by defining it as a new kind of “object” you can create into the document.
Looking forward to suggestions … or better still: finding it in a patch and future releases of Notes !
Pascal