Link to home
Start Free TrialLog in
Avatar of Treety_Patnaik
Treety_PatnaikFlag for India

asked on

filter expression

Hi all,

    i have written a filter expression but i am getting a error as
   "Expecting True/False Expression"

please check my expression

IF dw_2.rowcount() > 0 THEN      
      dw_2.setFilter("document_no like '"+ upper(ls_doc) +"' or document_no like '"+ lower(ls_doc) +"'")
      dw_2.filter()      
END IF
Avatar of shru_0409
shru_0409
Flag of India image

IF dw_2.rowcount() > 0 THEN      
      dw_2.setFilter("document_no like '"+ upper(ls_doc) +"' or document_no like '"+ lower(ls_doc) +"'")
      dw_2.filter()      
END IF

triy this
sorry try this

IF dw_2.rowcount() > 0 THEN      
      dw_2.setFilter("document_no like '"+ upper(ls_doc) +" or document_no like "+ lower(ls_doc) +"'")
      dw_2.filter()      
END IF

Avatar of Treety_Patnaik

ASKER

it is totally not working ............. my expression is giving me the correct result but it is showing that message .....

But shru your expression is giving me no result .... the dw_2 is getting blank.
ASKER CERTIFIED SOLUTION
Avatar of shru_0409
shru_0409
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Perfect answer by Shru