Current location - Recipe Complete Network - Catering franchise - The query function of Pb9.0 realizes the compound and fuzzy query of codes,
The query function of Pb9.0 realizes the compound and fuzzy query of codes,
It can be realized by the following functions:

Dw.setfilter (query condition string)

Filter ()

-

String ls_filter

Long ll_rtn

Ls _ filter = '('+[ column name ]+" like'% "+[ value ]+" ')"+" and('+[ column name ]+" like'% "+[ value]+")"

You can continue to pay attention to the conditions in the future.

setfilter(ls_filter)

ll_rtn = dw.filter()

If ll_rtn =-1

F_msg ('Error in finding filter formula, please check the formula. ~r~n' + ls_filter)

return

If ... it will be over.

-If the search formula is wrong, please adjust it yourself. It's usually the quotation marks.