Countries and cities

Hi,

I tested it now several times and changed some setting. But my situation is with the latest plugin versions:

1) all ok without being part of a field group !
2) cities not saved if both, country and city fields, are part of a field group

I am working with both field as "Query Drop Down (Multi-select)".

Options:
Value Column = geonameid
(unique id)

Label Column = label

Can you please check this?

Thanks, best regards
Eric

Hi,

I can set Display on profiles as "ordered list", by this the choosen values comes as

1. value 1
2. value 2
and so on

The order I can normally set in the query with ORDER BY column ASC/DESC.

But is there a possibility to get the order exactly in the same order as the values were picked out of the drop down list. So the first value will become the 1. value and the second 2. value, no matter in which order they are in the drop down list?

And is it possible to get the choosen values in the profile edit dropable with the mouse so that the order for the profile view can be determined?

Thanks, best regards
Eric

ericmuc wrote: Hi,

I tested it now several times and changed some setting. But my situation is with the latest plugin versions:

1) all ok without being part of a field group !
2) cities not saved if both, country and city fields, are part of a field group

I am working with both field as "Query Drop Down (Multi-select)".

Code:

SELECT *, CONCAT_WS(' / ', city, subcountry, country) AS label FROM #__cities WHERE FIND_IN_SET( country_3code, REPLACE( '[cb_country]', '|*|', ',' ) ) > 0

Options:
Value Column = geonameid
(unique id)

Label Column = label

Can you please check this?

Thanks, best regards
Eric

I've already tested this as working perfectly fine with chaining query selects in a field group. The below is a permanent test case that I used during all field group regression testing. I've retested it again as working fine.

Name: cb_fieldgroup_country
Type: Query Drop Down (Single Select)
Query: Value Column: country_iso_code2
Label Column: country_name

Name: cb_fieldgroup_state
Type: Query Drop Down (Single Select)
Query: Value Column: province_iso_code
Label Column: province_name
Update On: cb_fieldgroup_country

This will update the state dropdown based off the selected country. The above uses the tables provided by CBSubs Tax integration for CBSubs. Both values save perfectly fine. Try making your query more specific with the following and see if that helps.

But is there a possibility to get the order exactly in the same order as the values were picked out of the drop down list. So the first value will become the 1. value and the second 2. value, no matter in which order they are in the drop down list?

No, it will always follow the order of the options in the dropdown.

And is it possible to get the choosen values in the profile edit dropable with the mouse so that the order for the profile view can be determined?

The order of the field group rows? Yes, turn on sorting within your field group field. If you mean in the dropdown then no.

Hi,
Thanks.
Now I made the test and switches both Query Drop Down (Multi Select) to Query Drop Down (Single Select) type.
That works also in a field group.
But not if both are Query Drop Down (Multi Select).
Can you please check this?
Thanks, best regards
Eric

Ah, yup the country field being a multiselect causes the state field to fail to save due to the country value still being an array causing the substitution to fail. I see the issue and am working on a fix. New CB Field Groups build should be out sometime today fixing the issue.

forge.joomlapolis.com/issues/8416

This is now fixed in latest CB Field Groups build release available now.