Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Filter
Microsoft Dynamics NAV (Archived)

Filter

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

Hello

We are using incadea.myengine, a microsoft dynamics nav 2009 r2 based system.

I need to filter out certain type of items by VINNR (* are unknown letter/number) jmzke****00109955 up to jmzke****00248136. so the numberintervall range i need to see is between 109955 to 248136(this is what i need to filter)

I have tried the following filters:
jmzke****00109995..248136

and all other variables from this site:
https://msdn.microsoft.com/en-us/library/hh879066(v=nav.71).aspx

Please help me get the filter command right.

*This post is locked for comments

  • mmv Profile Picture
    mmv 11,467 on at
    RE: Filter

    Hi,

    While using the wildcards (*) in filter, you need to enclose them in single quotes, like the below:-

    'jmzke*109955'..'jmzke*248136'

  • Suggested answer
    Alex A Profile Picture
    Alex A 2,348 on at
    RE: Filter

    Please elaborate on how your item numbering scheme currently looks and what you need to do. It sounds like you are saying you want to filter so that you only see the numbers jmzke****00109955 up to jmzke****00248136, where the asterisks represent unknown characters?

    The problem seems that you don't know all the characters for the first and last value? You need to get the full Item numbers for the first and last values, then you can put ".." between them to get what you want.

    For example,

    jmzkeAAAA00109955..jmzkeZZZZ00248136


    You could try the following, but it would be better if you knew the first and last values:

    *109955..*248136

    *00109955..*00248136

    *00109955*..*00248136*

    ..*00248136 & *00109955..

    >*00109955&<*00248136

    >*00109955*&<*00248136*

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Filter

    Hello

    and thank you for your reply, unfortunatly, it does not work.

    below the filter, it shows results until i type jmzke*00109995..j

  • Tharanga Chandrasekara Profile Picture
    Tharanga Chandrasekara 23,116 on at
    RE: Filter

    Try with the jmzke*109955..jmzke*248136

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Filter

    Hi

    Try jmzke*00109995..jmzke*00248136.

    Neil

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,489 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,305 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans