I need to fix my wrong configuration of Country field

I have followed the instruction of Configuring a Country field with CB Query field plugin .

However, I didn't succeed. My front-end is like this:


And my Query is:


And my database is:


I tried to change my query to:
SELECT `iso`, `country`, `continent_full` FROM `#_country_info` ORDER BY continent_full, country

But it's still not working. I really want to fix it.

Thanks for helping me.

You're trying to use Query Validation. That just validates an existing field with your custom database query. You need to create a Query Drop Down (Single Select) field as the tutorial directly states in step 2. Please follow the below tutorial carefully.

www.joomlapolis.com/documentation/345-cb-query-field/tutorials/18377-configuring-a-country-field-with-cb-query-field-plugin

I think I have made this field a "Query Drop Down (single-select), but no change at all.



It seems to me the Query didn't retrieve any data from the table "country_info" at all. The field still works like a Drop-Down single selection, even I select "Query Drop-Down" and put a Query in integration

The parameters for the query field are under the Parameters tab. If the type is correct you are still trying to add query validation under the Integrations tab, which is not correct.