Showing posts with label cascading. Show all posts
Showing posts with label cascading. Show all posts
Tuesday, February 17, 2015
Cascading multi select parameters example in pentaho CDE
Hello Guys
You will learn how to do cascading with multi select components in pentaho CDE . There is another post on the same topic in this site which was a basic one.
In this you will find the implementation of
1) Custom parameters & default values
2) Multi select input controls cascading.
3) Fixed height & back ground color for input controls.
Final Look of the cascading parameter :
One of the Layouts design for selects (Country select place holder) [Not the Country label place]
Custom Parameters :
param1 for country
Default value in Javascript code ["US","Canada"]
param2 for state
Default value in Javascript code ["BC","WA"]
param3 for city
select1 for country
select2 for state
select2 parameters (at only parameter place give param2)
select3 parameters (at only parameter place give param3)
Query 1 : country query (SELECT DISTINCT country FROM customer)
Query2 : state query
SELECT DISTINCT state_province FROM customer WHERE country IN (${param1})
NOTE : for multiple selection parameter name should be given with in bracket i.e., with in ()
Query 3 : city query
SELECT
DISTINCT city FROM customer
WHERE
(
country IN (${param1})
AND
state_province IN(${param2})
)
NOTE : for multiple selection parameter name should be given with in bracket i.e., with in ()
OUTPUT : Image 1
Download the example : Click Me - Cascading multi select and HTML tabs examples
:-) Sadakar :-)
Subscribe to:
Posts (Atom)