Making User ID Number Searchable in List

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.

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.

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?

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.

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