having trouble to filter * %1*

yonhantdaenta89@hotmail.com

Hi All,

I have a line of code which is

table.setfilter("No.",*%1*,"Document No.");
if table.findset then ;

if did findset or findfirst, but when I debug it, it goes to the beginning of the data which is not correct.

do you know what is missing from the code ?

thanks,

Wisa123

Wrong: table.setfilter("No.",*%1*,"Document No.");
Right: table.setfilter("No.",'%1','*'+"Document No.");

vaprog

Your question has been answerd already in

Percentage Sign handling in NAV is dangerously flaky

So, in this case, you should use STRSUBSTNO.

yonhantdaenta89@hotmail.com

Hi @vaprog can you please elaborate how to write it ?

thanks,

RockWithNAV

What you really want to achieve.

Write like this

table.RESET;
table.setrange("No.","Document No.");
if table.findset then ;
repeat
until table.next=0;

Which table is it?

ErictP

table.setfilter("No.",STRSUBSTNO('%1%2%1', '*',"Document No."));

Wisa123

Wrong: table.setfilter("No.",*%1*,"Document No.");
Right: table.setfilter("No.",'%1','*'+"Document No.");

vaprog

I'd do it like

table.SETFILTER("No.",STRSUBSTNO('*%1*',"Document No."));

yonhantdaenta89@hotmail.com

hi @vaprog : I haven't test your code yet, but I find out that @wisa123 's code did work

thank you all

vaprog

Hi @yonhantdaenta89@hotmail.com

In @wisa123 's code the trailing '*' is missing, but appart from that, his code is ok.