searching record name form the NSQL portlet

[Ram Bandari]

Hi All,

We are having a requirement to search attachment names  from the NSQL portlet filer. But, here we should not use any  asterisk (*) while searching data.
For this I used below parameter in 'where' clause, but here it is giving total results instead of required data.

where (UPPER(X.attch_name) like '%'||@WHERE:PARAM:USER_DEF:STRING:attch_name@||'%'
OR @WHERE:PARAM:USER_DEF:STRING:attch_name@ IS NULL)
AND @FILTER@

Can you please anyone suggest why it is not showing correct results?
Database: postgres
Thanks!!

[David Morton]

Could it be "case"? I've certainly used similar NSQL to this in the past.

Perhaps try;

where (UPPER(X.attch_name) like UPPER('%'||@WHERE:PARAM:USER_DEF:STRING:attch_name@||'%')
OR @WHERE:PARAM:USER_DEF:STRING:attch_name@ IS NULL)

[Ram Bandari]

Hi, David. Thanks for your reply on this post.

Parameter field is not a case sensitive. I tried the given option, but it is not working. And It is displaying all the records. Thanks!