[aendrew]

Hi there,

I’ve created a custom profile field called “Company”, which I ultimately need the option to sort by alphabetically on the member list page. Ideally, this would be an option in the “Order by” dropdown on /members/.

Is there any way to do this without hacking bp-core-classes.php? I’ve thought about adding code around line 144 like so:

if ( ‘company’ == $type )
$sql = “AND pd.field_id = 2”;

and at line ~190:

case ‘company’:
$sql[] = “ORDER BY pd.value ASC”;

Thanks!

Note that I don’t want to search for it so much as sort by it; I’m basically using this page as a roster of organization members.

Would it make more sense to do companies as groups, then do some language file overrides renaming “Group” to “Company”, etc.?

Thanks!

-Æ.

[Tosh]

I’m looking to do something similar. I want to sort members by who has the most points. Any direction would be helpful.

Here is the sql when points are logged:

‘ global $wpdb;
$wpdb->query(“INSERT INTO `”.CPDB.”` (`id`, `uid`, `type`, `source`, `points`, `timestamp`)
VALUES (NULL, ‘”.$uid.”‘, ‘”.$type.”‘, ‘”.$source.”‘, ‘”.$points.”‘, “.time().”);”);’

[Tosh]

@aendrew Did you have any luck with this?

[Tosh]

@aendrew this might be a good started point? I’ll look at this more in depth later.

https://buddypress.org/community/groups/third-party-components-plugins/forum/topic/bp-member-filter/?topic_page=4&num=15

[remotedevice]

anyone figured this out?

[Tosh]

Nothing yet

[aendrew]

Apologies for kinda abandoning this thread. Thanks for finding me that post, xberserker; I’ll give that a shot!

Cheers!

[mistercyril]

Hello guys,

I’m interested in doing the same thing. Have you figured out a way of doing this without writing an SQL query?

I would be ok with hard coding the field I need to sort by.

My current query looks like this (default buddypress) but how can I have it look for a specific field value?
`$queryString = “type=alphabetical&action=alphabetical&per_page=150”;`

In WordPress I would use this `orderby=field_name` but thats not doing anything here…

Any help would be greatly appreciated,

Thanks,
C.

[cparkinson]

Hi

I need to sort the members directory to. I want to do it by Membership Level from the Membership plugin, but being able to do it by any profile field would be a start. I’ll look into modifying ‘BP Profile Search’ as suggested in the thread Tosh linked to.

thanks,
C