query parameter return no records

Question

i've created a query with string parameter( string & date parameter as string) but it return no records but when i execute the query in mysql/mariadb there are data. FYI i've set the dialect in datasource mysql/maridb(innodb). Pls help how to resolve..

Comments

Dear Arif

We need to know what type of DBMS are you using and the sql query.

What type of data contains the select statement ?

Best Regards

A.