col.xyz.cascade - deprecated

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

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



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