Jump to content

Problem with 'like' option in where clause in jasper 


Recommended Posts

Hi there 

I need to publish a report based on a sql query (mysql) that I am not allowed to modify.

The user has decided to use a column as a filter for the report. This column has multiple value options: concatenated results (value1,value2,value3) , single values or can even be null.

I have created a multi selected query and  a string parameter:

select a.*from (sql_query) as awhereCASE WHEN $P(parameter) IS NULL THEN TRUE ELSE a.find_in_set($P(parameter), a.filter_column)[/code]

However I am not getting any result.

Im I doing something wrong, something is missing....

I would appreciate any answer you can give me.


Link to comment
Share on other sites

  • Replies 0
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Create New...