Filtering problem

Cem_Karaer

Hi all,

I have item nos with a pattern X.XXXX.XX.XXX.XX. I can set a filter as M.*.EB.*.TUM which means: 'filter ones starting with M., ending with .TUM and having .EB. somewhere inside. But I can not negate that expression. <>M.*.EB.*TUM does not mean: 'filter ones NOT starting with M. and NOT ending with .TUM and NOT having .EB. somewhere inside'. Is it possible to make such a filter in Navision?

amunozsu

Have you tried with something like: <M*.*.EP.*.*TUM|>M.*.EP.*.*TUM

bab

cemkaraer, i think you already have the answer:

'filter ones NOT starting with M. (<>M.*) and (&) NOT ending with .TUM (<>*.TUM) and (&) NOT having .EB. somewhere inside (<>*.EB.*)'

<>M.*&<>*.TUM&<>*.EB.*