[SOLVED] CB User list country field display

Joomla 3.8.1 CB 2.1.3
I use query select fields for country and state/zone which store a number and display a text drawn from countries or states tables; how can i get a user list to display the text (for a Membership Directory)? I considered writing an SQL on registration that would copy the data into a separate 'country' field. The query that fills the country-select field is of the form 'SELECT `country_id`,`country_name` FROM `#__countries`. Is it possible to read the 'country_name' data from the field into a CBSubs Plan SQL query after Registration? Or is there a simpler solution?

And if I'm writing an SQL Actions query, can I use a substitute value to identify the user by ID? The notes to the SQL Actions plugin offer CB fields, but not the user ID

Don't understand what you're asking. The name should already be displayed if you're outputting country_name as the label for the options. Is the field not showing the country_name on profile of the country the user selected?

And if I'm writing an SQL Actions query, can I use a substitute value to identify the user by ID? The notes to the SQL Actions plugin offer CB fields, but not the user ID

You can substitute user id with [user_id].

Ah,; just checked the database for the comprofiler table to see that the data there is still text in the select fields; I have recently installed the j2Store extension and its CBsync app and it was this that required me to use numbers in the country and state fields (and it was their country and zone tables that provided the source for my query fields.)
I see now that there is more database updating to be done;

You can delete this forum thread