Hi
We currently have a problem with the order of users. A last name of a
user is currently ordered mathematically. Though in most cases this is
very confusing for the end user because they don't want to worry whether
there is a space or another special character into the name when
ordering / search for names. In the old D days we solved this by adding
a new column to the user table with a sort name. This sort name was
never visible on the screen but was used to order the last name of a
user table. The sort name contained the last name of the user but
without spaces and special characters. Thus all the users would be
sorted alphabetically (without taking the special characters into account).
We would like to introduce this in chamilo 2.0 but are not sure how we
could solve this issue. We propose two solutions. One that will affect
the specific user table, or one that will affect the entire platform:
* We could add a new field to the user table called sortname, fill
it up automatically by parsing all the special characters and
spaces out of the name. Add this sortname to the userlist in place
of where the lastname is now and change the translation to last
name. Change the cellrenderer to display the contents of the last
name in the sort name column and it will look as it is the last
name but will sort on the sortname.
* We could add an additional parameter to the object column which
introduces the column on which should be sorted. Default this is
the same column / property as the property for which the column
has been defined. When doing this we can define specific sort
columns for better visual order methods in multiple tables.
I would really appreciate it if i could have some input on this because
this is a very very important feature for us.
--
Met vriendelijke groeten
Sven Vanpoucke
Digitaal Leren
Directie Onderwijs
Hogeschool Gent
http://digitaal-leren.hogent.be/
_______________________________________________
Dev mailing list
Dev@lists.chamilo.org
http://lists.chamilo.org/listinfo/dev
