Toggle Submenu
  1. Forums
  2. Recent
  3. Categories
  4. Tags
  5. Users
  6. Badges
Support is currently Offline
Support Offline
It's past support hour. We are taking some rest and will come back stronger tomorrow. Promise!
Official support hours:
Monday To Friday except Saturday and Sunday
From 09:30 To 17:00
Our current time: Friday 4:15 am
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.