cascading input control with single select query

[dibyasagar]

i have a table named accounts which has two columns as shipping_address_country and shipping_address_city. 

so i made two parameters named:- country and city (both have data type as string). 

now i have two input controls. the first input control is named country which selects countries from the table accounts. 

the query is select shipping_address_country from accounts

the second input control is named city and its query is select shipping_address_city from accounts where $X{EQUALS,shipping_address_country,country}

 

 i want to populate country on the first control and then its city accordingly on the second control.

for now i get error that says No clause function for id EQUALS found.

[reportdev]

There is No $X{EQUALS} condition in Jasper.

as per documentation

http://community.jaspersoft.com/documentation/tibco-jaspersoft-studio-user-guide/v60/using-parameters-queries

use $X{EQUAL, column_name, param_name}

or

$X{IN, column_name, param_name}

[dibyasagar]

using EQUAL actually worked. but the problem now i am facing is that i need to deselect already selected value on city

input control. like say:- if i have selected usa as country it populates new york. it is fine till here. now i select uk as country

then the city value selected is still new york and i have to choose deselect(---) first then only i can change value to london on second input control. i want to change value to london automatically if i choose country as uk. thanks 

 

 

[reportdev]

Use $X{IN} condition. it changes dynamically