Making User ID Number Searchable in List

11 years 9 months ago #207523 by marriage_minded_man
Making User ID Number Searchable in List was created by marriage_minded_man
How can I make a User ID Number, searchable in a user list?

Cant find it in Field Manager, and if I try putting it into a field delimiter it doesn't give me the option to make the field searchable in list.

Is this possible somehow?

I just want users to be able to search the list based on the User ID number. I'm able to display it fine using CB content, but can't seem to make it searchable in lists.

Please Log in to join the conversation.

11 years 9 months ago #207567 by krileon
Replied by krileon on topic Re: Making User ID Number Searchable in List
You'd need to use CB Auto Actions with the after registration trigger and a Field action to push the user_id to a read only field. You'd then be able to use the field as you would any other for searching, etc.. For existing users you'd need to manually fix.


Kyle (Krileon)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Documentation + Search the forums
CB links: Documentation - Localization - CB Quickstart - CB Paid Subscriptions - Add-Ons - Forge
--
If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
--
If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please send me a private message with your thread and will reply when possible!
--
Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
--
My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.

Please Log in to join the conversation.

11 years 9 months ago #207615 by marriage_minded_man
Replied by marriage_minded_man on topic Re: Making User ID Number Searchable in List
How do I "push the user_id to a read only field"?

And how do I fix the existing users? Is this something I have to go into MySql for?

Please Log in to join the conversation.

11 years 9 months ago #207673 by krileon
Replied by krileon on topic Re: Making User ID Number Searchable in List
Create a read only field. Then setup a Field auto action after the registration trigger. Then set that read only field to [user_id]. Existing users you'd need to update the field manually. Yes, you could use phpmyadmin to update all of them, example as follows.
UPDATE `#__comprofiler` SET `cb_userid` = `id`

Of course make a backup before running any such query. Also change `cb_userid` to the actual name of your field.


Kyle (Krileon)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Documentation + Search the forums
CB links: Documentation - Localization - CB Quickstart - CB Paid Subscriptions - Add-Ons - Forge
--
If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
--
If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please send me a private message with your thread and will reply when possible!
--
Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
--
My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.

Please Log in to join the conversation.

Moderators: beatnantkrileon
Time to create page: 0.186 seconds

Facebook Twitter LinkedIn