Sorting/Alphabetizing Member List

The default implementation for the member's list is to sort by order of entry. Is there a configuration somewhere that will allow me to sort by last name or other fields?

If this doesn't exist, which component file should I modify to get this behavior and how can I change the sort criteria? I'm well versed in PHP, but I'm still in the process of learning Joomla's MVC component structure and I'm not very familiar with how their database classes work.

Furthermore I came across the following post from and older thread:

joomdonation.com/forum/membership-pro/44...ip-pro.html?start=30

hjames wrote: For those of you who want to make your membership table sortable you can follow this quick guide:

1. Download the attached sortable.js file and upload it to templates/your_template/js
2. Open your templates file which references the "head: of the template (Different frameworks do this differently)

• Check the template root "index.php
• Check the template root > layouts > blocks

3. Find the references to other JS and add a new line as follows:

Code:

$this->API->addJS($this->API->URLtemplate() . '/js/sortable.js');

4. Open the file: default.php in the following folder: components/com_osmembership/views/members/tmpl
5. Edit the following line 30:

from:

Code:

<table class="table table-striped table-bordered table-condensed">

to:

Code:

<table class="table table-striped table-bordered table-condensed sortable">

6. Upload this new file to the following: your_template/html/com_osmembership/members

Once all of these changes have been made and are in the correct places your entire table will be sortable.

Thanks,
James

Has anyone achieved this type of sorting behavior in their member's list?

I tried to implement this in my template following the format of other javascript includes, but was unable to get anywhere. Having the ability to sort these fields and have more reliable searching capabilities would be ideal. I've noticed that you can only search for a single word, otherwise the search returns nothing.

Hi

You don't have to customize the code. Actually, when you create menu item to display members list, there is a parameter in the menu allow you to choose to sort subscribers by what custom field.

Could you please check the menu item again?

Tuan

Wow. I missed that one. I've even been in that menu before! Thanks Tuam!

Unfortunately another problem has cropped up. For some reason the ASC/DESC selections aren't working. It always sorts it in reverse alphabetical order (DESC), even if I pick ASC. Both options render the same sort.

Any idea why this wouldn't be working properly?

Hi Michael

What version of the extension you are using? I remember that it was a bug in older version of Membership Pro and it was fixed. So you can download latest version of Membership Pro, upgrade it to your site and check it again

It should work well

Regards,

Tuan