Setfilter

sabzam
sabzam Member Posts: 1,149
edited 2008-01-29 in NAV/Navision Classic Client
Hi Everybody,

I have used the setfilter extensively but for some reason or another the following code is not working properly. Could anyone help me to solve this issue.

The code in question is:
Transactions.SETFILTER (OURREF, '<>%1&<>%2', 'SOR*','POR*');

Practically I am filtering a table by the OURREF field, where the field contents doesn't begin with SOR or POR.

For some reason they are still being extracted even though they begin with POR or SOR.

Comments

  • Jut
    Jut Member Posts: 72
    What do you mean by "even though they begin with POR or SOR".

    Actually you filter condition just shows all records where OUREF does NOT start with SOR and POR what is equal to your statement that "they are still being extracted even though they begin with POR or SOR."
  • sabzam
    sabzam Member Posts: 1,149
    Well actually that is what I want...I do not want those that begin with POR and SOR to be shown but they are still being shown
  • kapamarou
    kapamarou Member Posts: 1,152
    Does
    Transactions.SETFILTER (OURREF, '<>SOR*&<>POR*')

    Work??
  • Belias
    Belias Member Posts: 2,998
    http://www.mibuso.com/forum/viewtopic.php?t=23219&highlight=setfilter
    -Mirko-
    "Never memorize what you can easily find in a book".....Or Mibuso
    My Blog

Categories