Options

FILTER: Including Works, Excluding Don't works?

elToritoelTorito Member Posts: 191
Hi,

heavy Topic :roll: i know, but i don't know how formule it ...

well...

We have Items that have follow codes:

A50-XXX-1
A50-XXX-2
A50-XXX-3
A51-YYY-1
A51-YYY-2
A51-YYY-3

If I Would Only see this Items I set a filter :

Field: No.:
A5*

it displays me all Items init by A5

But if i set Filter:
<>A5*

it displays me too the Items ....
i have try various filter statements but if i would exclude the Items init by A5 i don't get any result, every time it are listed.

:-k

Any Tips? What i'm making wrong? It's a simple filter only ... (*,) ](*,) ](*,)
Thanks. ]
(Oo)=*=(oO)

Comments

  • Options
    SavatageSavatage Member Posts: 7,142
  • Options
    afarrafarr Member Posts: 287
    Savatage has the right idea, though I guess he means <A5|>=A6
    The filter ..A5 would exclude A50-XXX-1, but include an item whose code is exactly A5
    Alastair Farrugia
  • Options
    kinekine Member Posts: 12,562
    Look there: http://www.mibuso.com/forum/viewtopic.php?t=4067

    Check the posts about versions (it is working only on 3.70> and on MS SQL DB)
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • Options
    KowaKowa Member Posts: 918
    Try <A5&>=A6
    Kai Kowalewski
  • Options
    elToritoelTorito Member Posts: 191
    Kowa wrote:
    Try <A5&>=A6

    This Don't display Results.
    Savantage wrote:
    ..A5|A6..

    This works Nice =D>

    I Don't Think that futurily they are savin an item with code exactly A5 ...
    So i get this for work, but <>A5* is for me the logicalest way :lol:

    But if i understand correctly the <>A5* only works with SQL Server Option?

    I Thanks all for you answers.

    PS: We are Working with Nav Clients 3.70A
    (Oo)=*=(oO)
  • Options
    kinekine Member Posts: 12,562
    Yes, it works only on MS SQL and only for version 3.70+
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
Sign In or Register to comment.