Skip to main content

Notifications

Announcements

No record found.

Finance | Project Operations, Human Resources, ...
Answered

Changes to "Matches" to "Is one of" when filtering in Grid

Posted on by 11
A user reached out to ask about a change they saw to their filter function after an update. They setup a process within their group where they would go into the grid filter, select the /Matches/ and enter several selections separated by a common. Upon applying this filter, it switched from /Matches/ to /Is one of/. Has anyone else seen this change? I can't find any Microsoft documentation of this change, does anyone have any? 
  • Verified answer
    Layan Jwei Profile Picture
    Layan Jwei 7,347 Super User 2024 Season 2 on at
    Changes to "Matches" to "Is one of" when filtering in Grid
    Hi Community member,

    This behavior is not only for "is one of"

    For example if you put Matches *101*  then it will be converted to contains 101
           


    OR if you put matches 101 then it will be converted to is exactly

    So "matches" gives you more flexibility to put anything if you are not sure which other filter to choose. However, if you use "is one of" or "is exactly", then this means you know what you are searching for and that you either really want "is exactly" or "is one of"

    And btw if you use "is exactly" *101* it will also be converted to "contains" 101

    So choose whatever you like, as long as u get the correct result

    Thanks,
    Layan Jweihan
    Please mark this answer as "Verified" if it solved your issue. In order to help others who will face a similar issue in the future
  • Verified answer
    Judy Profile Picture
    Judy Microsoft Employee on at
    Changes to "Matches" to "Is one of" when filtering in Grid
    Hi, I have the same results when I tested on my demo environment, I think it is a standard behavior.
  • Community member Profile Picture
    Community member 11 on at
    Changes to "Matches" to "Is one of" when filtering in Grid
    This is for Finance and Operations. I have included a screen shot of what I am seeing. In this case, I am looking at released products. I select matches then enter data separated by a comma. Then click apply. The Grid filters but then automatically changes from "matches" to "is one of." 
     
     
     
     
  • Judy Profile Picture
    Judy Microsoft Employee on at
    Changes to "Matches" to "Is one of" when filtering in Grid
    Hi, Please share us what product are you using? It is better you can share the screenshot about this issue.
  • andreasraithel Profile Picture
    andreasraithel 4,823 Super User 2024 Season 2 on at
    Changes to "Matches" to "Is one of" when filtering in Grid
    Hy,
     
    as I understood /matches/ can be used like A* or *A with any kind of wildcard as well as using a list of values also having wildcards and seperated by commas e.g. 00018*,00017*
    In contrast /Is One of/ expect as list of values, also wildcards supported. In the value field of /Is one of/ a list of values can be copy and pasted e.g. from a Excel column.
     
    Hope this helps.
     
  • Dengliang Li Profile Picture
    Dengliang Li Microsoft Employee on at
    Changes to "Matches" to "Is one of" when filtering in Grid
    Hi,
     
    Dynamics 365 consists of many applications such as sales, customer service, marketing, Finance and Operations etc.
    You're asking in D365 general forum, therefore it's not clear which product you have in mind.
    Please add this information.
     
    Best Regards,
    Dengliang Li
     

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans