Hi,

I think, you just need some "OR"-Checks in your SQL-Statement...

Like this:

select *
from account_statement
where (
date = ${ userdate }
or '${ userdate }' is null
)
and (
gender = ${ usergender}
OR '${ usergender}' like 'all'
)

so both parameters can have a kind of "default/select all" value which is considered in the SQL...

HTH,

Tom