I have a parameter named shipcountry which I have created on the jasper studio 5.6 version now I trying to pass the value of it which select distinct orders.shipcountry FROM orders to the main dataset which is below but I get error when I preview the data in query dialog
SELECT orders.orderid,
orders.orderdate,
orders.shipcountry,
orders.customerid
FROM orders
where $X{IN, orders,shipcountry}
ERROR :Parameter shipcountry doesnt exist
Also is it true that on the jasperstudio wecant create the list of values as i dont see any option to create.
Only I get on server .