How do I find members by state?
Permalink Browser Info Environment
I'm using the Enhanced User List to format dealer listings. I want to use the member search to search by state, and list only the dealers in that state. How would I approach that?
Member search is successful. I really would like to know how to return only the dealers in a certain state. Members have a checked attribute Dealer. They also have the attribute Country, which contains their address.
Thanks!
Member search is successful. I really would like to know how to return only the dealers in a certain state. Members have a checked attribute Dealer. They also have the attribute Country, which contains their address.
Thanks!
| Type: | Discussion |
|---|---|
| Status: | New |
Thanks for the lightning-fast response!
I can see my job is cut out for me. EUL is for formatting the results only. I'll see what I can do with C5 member search.
And I think a search function (such as I described, with more flexible options) would be an awesome addition to your product.
Thanks,
Richard
I can see my job is cut out for me. EUL is for formatting the results only. I'll see what I can do with C5 member search.
And I think a search function (such as I described, with more flexible options) would be an awesome addition to your product.
Thanks,
Richard
> EUL is for formatting the results only.
Among EUL's features are the ability to FILTER by group and SORT by user attribute.
> I'll see what I can do with C5 member search.
How many dealers are in your list? If it's only a couple hundred or so, simply sorting the list by state and specifying a page size of 20 or 25 would result in just a few pages to navigate for the user and might work well enough until I release a version that supports searching (which will likely be after version 5.5 of C5 is released).
In other words, it might not be worth the time and effort for you to implement if it's not a huge list and if a searchable version of EUL is on the way.
> And I think a search function (such as I described, with more flexible options) would
> be an awesome addition to your product.
I appreciate the feedback. As I said, it's on my list. Searching is, after all, a type of filtering -- i.e. returning a subset of the full list. However, I'm leaning toward a simpler implementation at this point -- one with just a single search field that will search the contents of all user attributes for the string entered by the user.
What that would mean is that someone searching your dealer list for "Connecticut" would get not only dealers in the state of Connecticut but also any dealers located on Connecticut Street, regardless of the state in which they reside.
To allow more "advanced" searching would, I think, needlessly complicate things. I'd like to keep the block and UI relatively simple.
-Steve
Among EUL's features are the ability to FILTER by group and SORT by user attribute.
> I'll see what I can do with C5 member search.
How many dealers are in your list? If it's only a couple hundred or so, simply sorting the list by state and specifying a page size of 20 or 25 would result in just a few pages to navigate for the user and might work well enough until I release a version that supports searching (which will likely be after version 5.5 of C5 is released).
In other words, it might not be worth the time and effort for you to implement if it's not a huge list and if a searchable version of EUL is on the way.
> And I think a search function (such as I described, with more flexible options) would
> be an awesome addition to your product.
I appreciate the feedback. As I said, it's on my list. Searching is, after all, a type of filtering -- i.e. returning a subset of the full list. However, I'm leaning toward a simpler implementation at this point -- one with just a single search field that will search the contents of all user attributes for the string entered by the user.
What that would mean is that someone searching your dealer list for "Connecticut" would get not only dealers in the state of Connecticut but also any dealers located on Connecticut Street, regardless of the state in which they reside.
To allow more "advanced" searching would, I think, needlessly complicate things. I'd like to keep the block and UI relatively simple.
-Steve
Hi Steve,
I agree with simplicity in UI and function, and thanks for clarifying. I'm trying to meet a client's goals, which include specific marketing reasons to search for dealers by state and display only those in that state (filtering by state). Since I'm a designer, not a programmer, I'm trying to find a point-and-click solution, or one with not much php modification. I plan now to filter users by state, and by whether they're a dealer. That should do the job.
Unfortunately, I can't wait for the next version to launch the dealer search. You've been very helpful, thanks.
Best,
Richard
I agree with simplicity in UI and function, and thanks for clarifying. I'm trying to meet a client's goals, which include specific marketing reasons to search for dealers by state and display only those in that state (filtering by state). Since I'm a designer, not a programmer, I'm trying to find a point-and-click solution, or one with not much php modification. I plan now to filter users by state, and by whether they're a dealer. That should do the job.
Unfortunately, I can't wait for the next version to launch the dealer search. You've been very helpful, thanks.
Best,
Richard
Also, after re-reading your post, it's unclear to me what type of attribute "Country" is and why it would contain an address. I would suggest using an attribute of type "Address" for the dealer address. That will allow you to sort the list by dealer state (which is part of an "Address" attribute type).
Hope that makes sense. If not, let me know, and I'll attempt to clarify.
-Steve
Hope that makes sense. If not, let me know, and I'll attempt to clarify.
-Steve
Hi Steve, that does make sense. I found Country somehow, because some of our dealers will be in Canada. Address sounds better, and I'll deal with Canada later.
Thanks again for the quick help. It really helps me move forward.
Blessings,
Richard
Thanks again for the quick help. It really helps me move forward.
Blessings,
Richard
> Members have a checked attribute Dealer.
Instead of an attribute, consider creating a group called "Dealers" instead. I think that would offer more power and flexibility down the road. The only consideration is how users would be added to that group. It would either have to be done manually, or it would require a bit of custom coding.
Then again, if you are allowing ONLY dealers to create accounts on your site, then perhaps something like the following free add-on might be helpful...
http://www.concrete5.org/marketplace/addons/registrant-group/...
It allows users to automatically be added to a specific group upon registering.
Just some things to consider...
-Steve
Instead of an attribute, consider creating a group called "Dealers" instead. I think that would offer more power and flexibility down the road. The only consideration is how users would be added to that group. It would either have to be done manually, or it would require a bit of custom coding.
Then again, if you are allowing ONLY dealers to create accounts on your site, then perhaps something like the following free add-on might be helpful...
http://www.concrete5.org/marketplace/addons/registrant-group/...
It allows users to automatically be added to a specific group upon registering.
Just some things to consider...
-Steve
>Instead of an attribute, consider creating a group called "Dealers" instead.
I have users in groups, but I've also been trying whatever I could think of to get them to filter by state. Address/Dealer group is a good way to go. Our dealer qualification is fairly involved, so dealer registration doesn't work for us -- we add them manually.
You've given me much to consider, and have helped me find a direction. Lots of good karma to you!
Richard
I have users in groups, but I've also been trying whatever I could think of to get them to filter by state. Address/Dealer group is a good way to go. Our dealer qualification is fairly involved, so dealer registration doesn't work for us -- we add them manually.
You've given me much to consider, and have helped me find a direction. Lots of good karma to you!
Richard
The best you can do with EUL at this time would be to sort the dealer list by state. Users would then have to navigate the list using the pagination facility.
If you want to search members, you'll have to use C5's built-in member list/search.
If you have any other questions, let me know.
Regards,
-Steve