Toggle Submenu
  1. Forums
  2. Recent
  3. Categories
  4. Tags
  5. Users
  6. Badges
Support is currently Online
Add a reply View Replies (2)

Resolved Ordering username in frontend

  1. anderslolk
    anderslolk
  2. Support
  3. Monday, February 04 2019, 08:54 PM
Hi there.

I'm using Easy Profile on a site, where all usernames are numbers (the number is the membership number in the club). There is a problem with ordering the members in a user list at frontend, where the members can see all other members.

The order is by username (ascending), but is doesn't sort it right. First is all members starting with 0 showing, then all members starting with 1, then all members stating with 2..... So, number 1002 is showed before number 201. See the file (Medlemsnummer = username).

Isn't it possible to order it as numbers?
Attachments (1)
Skærmbillede 2019-02-04 kl. 20.39.38.png Skærmbillede 2019-02-04 kl. 20.39.38.png
References
  1. http://gwc.dk
Responses (2)
admin
admin Accepted Answer
Admin
Hi,
sorry for late reply.

Unfortunately this is not possible natively because Username field is a text and not a number.

Anyway if you want to make this then you need to make following code change at file /components/com_jsn/models/list.php
Line 214 from 
elseif($orderCol=='username') $orderCol=$db->quoteName('a.username');
to 
elseif($orderCol=='username') $orderCol=$db->quoteName('a.username').' * 1';
  1. more than a month ago
  2. Support
  3. # 1
anderslolk
anderslolk Accepted Answer
Pro
Great. Thanks.
  1. more than a month ago
  2. Support
  3. # 2
  • Page :
  • 1


There are no replies made for this post yet.
However, you are not allowed to reply to this post.