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 |