Notice

The forum is in read only mode.

Support Forum

Welcome! Support Forums have been reactivated
Welcome the Technical Support section. Help us in assisting you by providing us with a concise and descriptive elaboration of your issues. Be specific and if possible, provide us with a step-by-step instruction in replicating your problem.

How to sort members by last name

8 years 8 months ago
  • Edward's Avatar
    Topic Author
  • Edward
  • Offline
  • Fresh Boarder
  • Posts: 4
  • Thank you received: 0
Licenses:
JomSocial Active

ISSUE SUMMARY:
When we list the Member Directory, the alphabetical listing is by first name, we would like it by last name
Or the listing is sorted by Joomla name.
STEPS TO REPLICATE:
1 Log in as a member
2 Select Member Directory
3 Select abc
4
5
RESULT
You will see that the names are sorted by first name
EXPECTED RESULT
Want to change that to last name
BROWSER
Any

8 years 8 months ago
  • Dimas's Avatar
  • Dimas
  • Visitor
  • Thank you received: 0
Licenses:

Hi Edward,

sorting by last name is not possible, since the database stucture is hard to achive this.
may i know what do you mean sorted by Joomla name? do you mean username ?

thank you!

8 years 8 months ago
  • Edward's Avatar
    Topic Author
  • Edward
  • Offline
  • Fresh Boarder
  • Posts: 4
  • Thank you received: 0
Licenses:
JomSocial Active

Thank you for your reply!
Why can't we sort by FIELD_FAMILYNAME?
By Joomla Name I mean the value of the field Name in the Joomla User data

8 years 8 months ago
  • Dimas's Avatar
  • Dimas
  • Visitor
  • Thank you received: 0
Licenses:

Hi Edward,

Since the query is not be designed to be sorted by our custom fields..

Actaully the sorting will be respected from configuration->layouts->Display Name, so if you wanna change the sort depend fullname from Joomla you need to change the display name to "Real Name"

thank you!

8 years 8 months ago
  • Edward's Avatar
    Topic Author
  • Edward
  • Offline
  • Fresh Boarder
  • Posts: 4
  • Thank you received: 0
Licenses:
JomSocial Active

Thank you for your reply.

We already have it sate to Real Name, and as I said before, that creates a listing by Joomla User Name field. That field is usually, but not always, a concatenation of the first name and the last name, so sorting by that is essentially sorting by first name. Which is not what we want.

I do not understand why if you have all these cool custom fields, we can use them to sort by. Not really a hard SQL query to implement.

Where can I lobby for it in a future release?

Regards,
Dom

8 years 8 months ago
  • Dimas's Avatar
  • Dimas
  • Visitor
  • Thank you received: 0
Licenses:

Hi Edward,

I am sorry we cant make it on this short time, the stucture on custom field and query to show list users is different.. if you really want to achive this you need to hire 3rd party developer.

thank you!

Moderators: Piotr Garasiński
Powered by Kunena Forum

Join 180,000 websites creating Amazing communities

JomSocial is the most complete, easy-to-use addon that turns Joomla CMS into a
full -fledged, social networking site

TRY NOW BUY NOW