SETFILTER bug with @?

PureHeart

Hi All,

I think I found a bug in NAV related to the char @....

If you use this syntax:

Vendor.SETFILTER(Name,'@%1','pippo');

The setfilter does not work!!!! if you debug it you'll see that filters the name field for "@%1" instead of "@pippo"!!!!!

This instead will work...

Vendor.SETFILTER(Name,'@' + 'pippo');

Did anyone else discover that????

Ciao

Marije_Brummel

AFAIK it has always been a challenge to fiddle with setfilter and * and @.

PureHeart

Just checked with NAV 2009 SP1 and the error is still there I'm surprised Microsoft hasn't fixed it....you would image that setfilter would be able to parse the expression...no?

Marije_Brummel

I agree. Maybe it should be reported then to Microsoft.

PureHeart

Do you know how to report it?
Thanks

Marije_Brummel

Errr, I normaly send an email to one of the PM's in Denmark, but I guess that is not the official way...

There is MS Connect where you should be able to report a bug.

lvanvugt

I wonder if you should call this a bug. The advantage is that you have the option to filter on the character '@' AND you have to possibility to use @ as a filter option.

BTW: if you have access to PartnerSource you can log your bug there.

Belias

PureHeart wrote:

Vendor.SETFILTER(Name,'@%1','pippo');

About the error, i agree with lvanvugt...what if you have to setfilter for @?we don't have an excape key for special characters...

this is OFF TOPIC, sorry:
it's funny that in italy we also use 'pippo' as a "casual tester"...i didn't expect this name is used elsewhere
P.S.: in italy, pippo is the american "goofy" of mickey mouse...

PureHeart

Yes I realized it later...that's what happens when you program in other more "clever" languages....and Yes io sono italiano... Dear pippo friend

Resender

Sorry for raking this one up.
But thank you, I had this problem as well and breaking my head about why the filter was giving me @*%1* instead of the values filled in.

lvanvugt

How about this Dutch character: Pipo de Clown