Filtering of Item records

sbhamidi · 2005-11-09

I'm trying to set a filter on the Item records as '<>D*' on the Item Card and Item List report. Neither works. What I want to look at is any items whose No. values do not start with the letter D.
I've tried this in Navision 3.60 and 3.70 A. Neither works.
Any suggestions? I'd appreciate some enlightenment.
TIAdvance.

Savatage · 2005-11-09

..D|E..

themave · 2005-11-09

POST DELETED, SORRY

Savatage · 2005-11-09

NO PROB O:)

sbhamidi · 2005-11-09

Savatage wrote:

..D|E..

WHY didn't I think of that? Thanks!

kriki · 2005-11-11

Savatage wrote:

..D|E..

Actually this is wrong, because if there is an item that has as "No." = 'D', it will be shown.
So the correct one would be :
'<D|E..'

It even gets

(... or

) [... or :? ]:
'<>D*' works with SQL-DB, but NOT with Navision-DB

Savatage · 2005-11-11

the odds are sooooo slim that someone would actually name an item # just "D"

that's why i went with ..D|E.. :whistle:

I guess it's better to be %100 correct

kriki · 2005-11-11

Savatage wrote:

the odds are sooooo slim that someone would actually name an item # just "D"

that's why i went with ..D|E.. :whistle:

I guess it's better to be %100 correct

I thought it too when I wrote it, but... Never make assumptions. When you say : I don't program something, because the user will NEVER do that, you can be 100% sure he will. See Murphy's laws :!:

Filtering of Item records

Comments

Categories