FrodeKommode

NSQL String paramenter

Discussion created by FrodeKommode on Nov 13, 2014
Latest reply on Nov 14, 2014 by FrodeKommode

I'm making a portlet that has some reverse search possibillities but i can't get my string parameter to work.

The NSQL for parameter looks like this:

 

and (@WHERE:PARAM:USER_DEF:STRING:DES@ IS NULL OR inv.ID not IN(
         select inv.ID
        
         from PRTEAM pt
INNER JOIN INV_INVESTMENTS INV ON INV.ID = PT.PRPROJECTID
INNER JOIN ODF_CA_PROJECT op on op.id = inv.ID
INNER JOIN ODF_CA_TEAM CT ON CT.id = PT.PRID


         WHERE ct.discription like '%' + @WHERE:PARAM:USER_DEF:STRING:DES@ + '%'

))

 

Normal sql:

 

and inv.ID not IN(
         select inv.ID
        
        
         from PRTEAM pt
   INNER JOIN INV_INVESTMENTS INV ON INV.ID = PT.PRPROJECTID
   INNER JOIN ODF_CA_PROJECT op on op.id = inv.ID
   INNER JOIN ODF_CA_TEAM CT ON CT.id = PT.PRID


         WHERE ct.discription like '%parameter%'
        
       

         )

 

The sql Query Works fine and i have one almost identical that uses a lookup against roles that also Works.

Outcomes