Clarity

 View Only
  • 1.  searching record name form the NSQL portlet

    Posted Dec 28, 2021 02:09 PM
    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!!


  • 2.  RE: searching record name form the NSQL portlet

    Posted Jan 18, 2022 12:19 PM
    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)


  • 3.  RE: searching record name form the NSQL portlet

    Posted Jan 19, 2022 10:01 AM
    Edited by Ram Bandari Jan 19, 2022 10:03 AM

    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!