Page Comparison

...

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

Versions Compared

Old Version 4

New Version Current

Key