Hi, im working with input parameters
something like this:
select product_id, product_name from product
where product_id = ${id}
and that goes well
But im trying to get a NULL value from the input, so if i don’t write anything on the input, it will shows me everything.
I was trying with something similar to store procedures like this:
where ${id} is NULL or product_id = ${id}
But it doesn’t work
What can i do ?
Thanks