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:
Post Comments (Atom)
No comments:
Post a Comment
Note: Only a member of this blog may post a comment.