Versions Compared

Old Version 5

changes.mady.by.user Dam

Saved on

compared with

New Version 6

changes.mady.by.user Dam

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Warning

This property has been deprecated in favor of the inline parameters method


Panel
borderColorblack
bgColorlightgrey
Excerpt

When you want to cascade the selection from one list to another list


Class

column

Property

col.xyz.cascade

Formal specification

col.xyz.cascade = column id

Required

no

Default


Version


Comment

When the cascade property is defined on a source list, then the plugin will provide the selected name and value of the source list as a parameter to the target property. The parameter can then be used by the target list query to select the relevant list options.

Example


Code Block
gd.columns=country, city 
 
col.country=Country 
col.country.type=list 
col.country.query=SELECT name, country_id FROM country_tbl 
 
# 
# Cascade the selected value to the city column 
#
col.country.cascade=city 
col.country.query.ds=mysql 
# 
# Use the second parameter of the country query in the city query 
#
col.city=City 
col.city.type=list 
col.city.query=SELECT name, city_id FROM city_tbl WHERE country_id={0} 
col.city.query.param=1 
col.city.query.ds=mysql 
datasource.names=mysql ... 


Reference

col.xyz.type = list 
col.xyz.query.param 
col.xyz.query.ds