Simple Question: filter option (item."Item Type") option

dianageledianagele Member Posts: 14
edited 2015-02-02 in NAV Three Tier
EASY Question for you folks.
It has been 2 years since I've jumped back in & cannot recall the proper structure

I want to filter out an option field called Item."Item Type"
but it is a field filter.
IF "Item No." <> item."No." THEN
  item.GET("Item No.");

I understand it is something like this:
SalesOrderLine.Type::Item

Comments

  • ppavukppavuk Member Posts: 334
    SalesLine.setfilter(Type, '%1|%2|%3|%4', type::Item, Type::G/L Acc, Type::FA, Type::Resource)
    
    for multiple option

    Or
    SalesLine.Setrange(Type, type::Item)
    
    for single option
  • dianageledianagele Member Posts: 14
    thank you -- however, I understand how to setrange.
    I need to omit items of a category "Item Type"

    this scenario:
    if Item."Item Type" <> "Container"
    

    but it is a flow filter...

    would it be something like this?:
    Item.setfilter("Item Type", '%<>1', "Item Type"::"Container")
    
  • geordiegeordie Member Posts: 655
    You can use this syntax:
    IF Item."Item Type" <> Item."Item Type"::"Container" THEN
    
Sign In or Register to comment.