Cb query issue

Hello,
I've created a CB_country dropdown field and used this query  

I activated the plugin render
 

But, all I got is
 

I guess after that I'd make an ajax check or something like a double drop down...
Could you advise the right way please ?
I also checked this (old) tutorial, but I couldn't see some variables, but I guess it should work more or less the same ? (except I'm quering the database directly from comprofiler)
But maybe I'm wrong, this field autoselect field for countries / region is already somewhere natively in CB or CB Sub ??
www.joomlapolis.com/documentation/345-cb-query-field/tutorials/18377-configuring-a-country-field-with-cb-query-field-plugin

Thanks

You didn't configure the query dropdown you configured query validation. You need to create a query select fieldtype and its parameters will be under the Parameters tab (not Integrations tab).

Ah I see now, thanks !
Ok, so, I can have now the countries populated with :
SELECT `country_iso_code2`,`country_name` FROM `#__comprofiler_countries` ORDER BY  country_name
My setup is like this
 
 
 

And I'd like to connect it dynamically to the provinces from #__comprofiler_provinces
I don't understand what is the "simple" way to pass variables between multiple queries here.
Tried this, but of course it doesn't work
SELECT DISTINCT `province_name` FROM `#__comprofiler_provinces` WHERE`[cb_country]`= `[country_iso_code2]`

With this setup on this field
 
 
 

Could you help me out figuring the right way ?
Thanks a lot !

Hello,
I've been to the demo platform of CB, and I really like this demo for these 3 fields 


Is there a full proper tutorial for that ?
I think I'd like that even better for my website
Thanks !

Is there a full proper tutorial for that ?

Login to backend of our demo site and directly copy the cb_region, cb_country, and cb_state fields. cb_country and cb_state utilize the Update On feature of the CB Core Fields Ajax plugin (see Integrations > CB Core Fields Ajax > General for such parameter) to refresh their display based off previous field value change. You also don't have to use Region and can modify cb_country as needed to not include that in the query if you don't want it.

I also recommend taking a look at the address fields provided by CB Quickstart under the Details tab. They provide a more user friendly experience utilizing Query Autocomplete under Integrations > CB Query Field > Autocomplete to suggest countries to them as they type normally in a text field.

Ok, after rethinking about mobile usage and ergonomic, I'll stay with country, then region.
But I can't make it working...
The state field appears after the selection of the country, but empty...
I'm still unsure with the country_id parameter that I don't understand where it comes from...
Could you help me correcting this ?