advanced Filter in CMSB editor for list field

5 posts by 2 authors in: Forums > CMS Builder
Last Post: July 10, 2018   (RSS)

By kitsguru - July 4, 2018 - edited: July 4, 2018

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.

SELECT 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?

Jeff Shields

By kitsguru - July 10, 2018 - edited: July 10, 2018

I'm using CMSB 3.12.

I disabled all plugins except membership and permalinks. No javascript errors. I traced the execution of the javascript code in developer tools and it runs to completion with no errors, yet the list is not updated.

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.

Jeff Shields

By kitsguru - July 10, 2018

upgrading to 3.13 made no difference.

Jeff Shields

By gregThomas - July 10, 2018

Hi Jeff,

I'll need to take a look at the setup in more detail to work out what's happening. Please, could you send the CMS login and FTP details for the site to support@interactivetools.com?

Greg Thomas







PHP Programmer - interactivetools.com