Filter Doubt

Kc_NirvanaKc_Nirvana Member Posts: 146
Hello....
Thanks for the help in advance....
It is possible to have a text field like a filter field with '1*..2*' and have a setfilter like Record.SETFILTER("No.",FilterText)?
Junior Consultant & Developer in Dynamics NAV

"I'm worse at what I do best
And for this gift I feel blessed
Our little group has always been
And always will until the end"

Nirvana - Nevermind - Smells Like Teen Spirit

Answers

  • DenSterDenSter Member Posts: 8,305
    That would be a pretty straightforward thing to try :mrgreen: go ahead and try, see if that'll work
  • Kc_NirvanaKc_Nirvana Member Posts: 146
    What i want to do is like:
    IF Rec."No." IN [ '1*..2*'] THEN

    Can someone help?
    Junior Consultant & Developer in Dynamics NAV

    "I'm worse at what I do best
    And for this gift I feel blessed
    Our little group has always been
    And always will until the end"

    Nirvana - Nevermind - Smells Like Teen Spirit
  • kinekine Member Posts: 12,562
    No, you cannot do it in this way, it was already discussed and could be found on the forum.

    Main idea is to insert the value into temp table, set filter, and look if the record is within the filter or not... ;-)
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • kinekine Member Posts: 12,562
    And, of course, for your example the result will be same like
    IF Rec."No."[1] IN [ '1','2'] THEN
    
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • DenSterDenSter Member Posts: 8,305
    Again something that is easy to just try.
  • Kc_NirvanaKc_Nirvana Member Posts: 146
    Thanks for all
    It has resulted with a temp table
    Junior Consultant & Developer in Dynamics NAV

    "I'm worse at what I do best
    And for this gift I feel blessed
    Our little group has always been
    And always will until the end"

    Nirvana - Nevermind - Smells Like Teen Spirit
Sign In or Register to comment.