Member List Search Issue

If you have questions about using mojoPortal, you can post them here.

You may want to first review our site administration documentation to see if your question is answered there.

This thread is closed to new posts. You must sign in to post in the forums.
7/5/2012 8:37:23 AM
Gravatar
Total Posts 199

Member List Search Issue

In the member list I have members with their state defined.  Can I search by STATE?  I tried typing in PA in the search field with no results.  Do I have to wait for the index to catch up?

I also wanted to change the display of the member list (what fields show up and what do not) is that possible?

Is it possible to allow/add a drop menu search in that member list grid (possible state drop down search)?

thanks in advance

7/5/2012 8:44:36 AM
Gravatar
Total Posts 18439

Re: Member List Search Issue

no, we don't have any built in search on custom profile fields. That would require custom development it isn't something we could bake in. The way the custom profile properties are stored in a separate table as key value pairs makes it difficult to have any generic query on those in any efficient way. It would require very specific sql to do it efficiently which would mean knowing what the properties are in advance. In other words its difficult to provide built in efficient search on arbitrary data properties.

7/5/2012 9:14:34 AM
Gravatar
Total Posts 199

Re: Member List Search Issue

If I know that state will always be a field for members would it be easier for me to just build a custom module and allow that capability or would you recommend a different way?

I see that the "mp_Users" table contains (Name, loginName, e-mail, country, state, interests) all or some which I would like to loop through in a search if possible.

do you see any any future problem with that approach?

as always thanks

7/5/2012 10:34:06 AM
Gravatar
Total Posts 18439

Re: Member List Search Issue

It should be fine to search those fields in a custom solution.

Search by admins already searches email and loginName. The coming release will also search FirstName and LastName when an admin is the one doing the searching. The coming release will also allow toggling the sort between displayname (the Name field) and created date so it is easier to find new users.

Best,

Joe

You must sign in to post in the forums. This thread is closed to new posts.