Introduction
Are you wondering if there is a way to cascade a value to two columns?
Assume you want to setup a 3 way cascade. The user should select continent, country , city (in that order),
Also assume you have a table listing all the cities in the world (worldcities) - containing 3 attributes
- Continent
- Country, countryCode
- City
- Address
Solution
You can now setup a 3 way cascade as follows
gd.columns = continent, country, city, deliveryAddress gd.ds = igrid_test gd.tablename = locations col.continent = Continent col.continent.type = list col.continent.query = select distinct continent from worldcities col.continent.query.ds = igrid_test # # Country column should only list the countries belonging to # the selected continent # col.country = Country col.country.type = list col.country.query = select distinct country, countryCode from worldcities where continent = {continent.value} col.country.query.ds = igrid_test # # City column should only list the cities belonging to the selected country # col.city = City col.city.type = list col.city.query = select distinct city, zipcode, address from worldcities where countryCode = {country.value} col.city.query.ds = igrid_test # # DeliveryAddress # The delivery address is the delivery address associated to the selected city # col.deliveryAddress = Deliver to col.deliveryAddress.type = string col.deliveryAddress.formula = {city.address}