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.
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
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 ?
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"
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.
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.