• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1116
  • Last Modified:

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
0
Treety_Patnaik
Asked:
Treety_Patnaik
  • 3
  • 2
1 Solution
 
shru_0409Commented:
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
0
 
shru_0409Commented:
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

0
 
Treety_PatnaikAuthor Commented:
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.
0
 
shru_0409Commented:
IF dw_2.rowcount() > 0 THEN      
      dw_2.setFilter(" upper(document_no) like '"+ upper(ls_doc) +"'" )      
      dw_2.filter()      
END IF
sorry try this...
0
 
Treety_PatnaikAuthor Commented:
Perfect answer by Shru
0

Featured Post

Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now