Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 6 Next »


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

  • No labels