SETFILTER bug with @?

PureHeart · 2010-01-22

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 · 2010-01-22

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

PureHeart · 2010-01-22

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 · 2010-01-22

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

PureHeart · 2010-01-22

Do you know how to report it?
Thanks

Marije_Brummel · 2010-01-22

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 · 2010-01-22

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 · 2010-01-22

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 · 2010-01-22

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 · 2012-03-21

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 · 2012-03-21

How about this Dutch character: Pipo de Clown

SETFILTER bug with @?

Comments

Categories