advanced Filter in CMSB editor for list field
This is for CMSB not the front end.
I have province/state table and a country table that are fully populated.
I have fields in my contacts table for the country and prov.
I have set up the province to change when the country changes. The ESCAPED_FILTER_VALUE is the country name.
FROM `<?php echo $TABLE_PREFIX ?>_sc_provinces`
where country = '<?php echo $ESCAPED_FILTER_VALUE ?>'
When I save the record the province updates to the list for the country selected. However when the country is changed will editing, the province select list does not re-populate. I had the impression that this was to update automatically.
Am I missing something here?
You're correct, the page should still refresh the dropdown list, even when you edit it. I've done some testing locally (using version 3.13) using the same code as you've provided along with the Country and province sections and data from Simple Cart and the page refreshed successfully when I edited it.
PHP Programmer - interactivetools.com
I'm using CMSB 3.12.
One other thing I did was replace the $ESCAPED_FILTER_VALUE with Canada, and it worked fine. It appears that the ESCAPED_FILTER_VALUE is not being picked up.