I have simple question but very annoy me… I want to filter Item No. The scenario like this : Item No : MMNOOOO345/1-5 PHEETELGBY450/1-1 PHEETELGBY450/1-2 PHEETELGBY45/1-1 PHEETELGBY45/1-2 I want to get Item No : all PHEETELGBY but I want to reject all PHEETELGBY450. I have filter like this : Item.setfilter(“Item No.”,’%1 & <>%2’,PHEETELGBY*,PHEETELGBY450*); The result are : PHEETELGBY450/1-1 PHEETELGBY450/1-2 PHEETELGBY45/1-1 PHEETELGBY45/1-2 The RIGHT result that I want are : PHEETELGBY45/1-1 PHEETELGBY45/1-2 But the result Not show as I want. Any one can advise me,pleaseeeeeee…
Hi Arnoldus It is not possible to apply this filter in Navision. The <> operator isn’t supported properly. If you run SQL version you can have other options, there are threads here that describe how to do it.