Support

  1. anderslolk
  2. Support
  3. Monday, February 04 2019, 08:54 PM
  4.  Subscribe via email
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)
References
  1. http://gwc.dk
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 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.

Request Support

Support is currently Offline

Support Availability

Working days: Monday to Friday. The support staff is not available on weekends; in the most of cases tickets will not be answered during that time.

Reply time: Depending on the complexity of your support issue it's usually between a few minutes and 24 hours for paid members and about one week for free members. When we expect longer delays we will notify you.

Guidelines

Before you post: read the documentation and search the forums for an answer to your question.

When you post: include Site Details if you request a support (you can use the form below the reply in Site Details tab).

Auto Solved Question: If after a week the author of the post does not reply to a request by moderator, the question will be marked as resolved.

Language: only English

Search Users

Easy Profile® is not affiliated with or endorsed by Open Source Matters or the Joomla Project. Joomla is Free Software released under the GNU/GPL License.