Options

SETRANGE or SETFILTER for "Not Empty" fields

IsalandIsaland Member Posts: 52
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

  • Options
    bbrownbbrown 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

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

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

    Help avoid an index scan.
    There are no bugs - only undocumented features.
Sign In or Register to comment.