Versions Compared

Old Version 2

changes.mady.by.user svitlana (Deactivated)

Saved on

compared with

New Version Current

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

Inject the cascaded values into the query used to build the content of a dynamic list.

Class

column

Property

col.xyz.query.param

Formal specification

col.xyz.query.param = <cascading field identifier>

Required

no

Default

none

Version

1.5

Comment


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