case insensitive search

ReportServer (EN)
1

Hi,

I’d like to create a report that will return clients’ data after a user inputs the client’s name fragment into a text parameter field.
The query should be case-insensitive

So far I came to sth like that:

SELECT * FROM CLIENTS WHERE LOWER(NAME) LIKE '%$!{name.toLowerCase()}%'

However, using $!{parameter} is not recommended for security reasons, so my question is if there is a better way to do it.
The underlying database is Postgres and I set readOnly=true in URL.

Cheers,
karolina

2

Hi Karolina,

you should be able to use something like

SELECT * FROM CLIENTS WHERE LOWER(NAME) LIKE CONCAT('%',LOWER(${key}), '%')

Here key is the parameter’s key.

Cheers,
Arno

3

Thanks a lot for this super-fast hint!
karolina