PowerBuilder - Dynamic Search in datawindow

Create an event ue_search and map to pbm_enchange event of sle_search on a window, where sle_search is where you enter the text based on which you want to search column data on a datawindow

in the ue_search event write below

string ls_sc

if trim(this.text)='' then
    dw_1.setfilter('')
    dw_1.filter()
else           
    ls_sc="lower(item_name) like '%"+lower(this.text)+"%'"
    dw_1.setfilter(ls_sc)
    dw_1.filter()
end if