SETRANGE or SETFILTER for "Not Empty" fields

Isaland
Isaland Member Posts: 52
edited 2012-08-16 in NAV/Navision Classic Client
Hello guys. I have one small question.
There is a Code DataType Field which i need to sort.
But i can`t find how to make SETRANGE or SETFILTER for "no empty" value :|

P.s. Field is No. of payroll order. And i need to sort records, where "Order No." is "no empty"
MB7-840

Best Answer

  • bbrown
    bbrown Member Posts: 3,268
    Answer ✓
    I vote for:
    Setfilter("Order No.",'>%1','') ;

    Help avoid an index scan.
    There are no bugs - only undocumented features.

Answers

  • Isaland
    Isaland Member Posts: 52
    #-o 
    MiscCardsData.SETFILTER("Order No.",'>0');
    MB7-840
  • dans
    dans Member Posts: 148
    SETFILTER(Field,'<>%1','')
    Microsoft Certified IT Professional for Microsoft Dynamics NAV

    Just a happy frood who knows where his towel is
  • MBerger
    MBerger Member Posts: 413
    I'd use 
    Setfilter("Order No.",'<>%1','') ;
  • bbrown
    bbrown Member Posts: 3,268
    Answer ✓
    I vote for:
    Setfilter("Order No.",'>%1','') ;

    Help avoid an index scan.
    There are no bugs - only undocumented features.

Categories