web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Season of Giving Solutions is Here!
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / "Does not contain...
Microsoft Dynamics CRM (Archived)

"Does not contain" option in advance find

(1) ShareShare
ReportReport
Posted on by Christine P 55

Hi,


This could be a very basic question but I can't find the answer and it's driving me potty.


I am trying to create a list of contacts which excludes the word "Chair" from a particular field (eg Chair of housing). But if I create query which says [fieldx] [does not contain] [chair] this doesn't seem to work, the Chairs are still in the list.

It's particularly frustrating as if I do the opposite [contains] then it's works as I would expect it to.

Am I missing something basic? Or could it be something to do with how our system has been set up?
Thanks


Christine

*This post is locked for comments

I have the same question (0)
  • Phillip U. Profile Picture
    Phillip U. 2 on at

    I know this doesn't help a lot but I cannot replicate your experience using 2013 SP1.  I performed you exact example - one record with the word "chair" and another with "chairs" and if I search for does not contain chair, neither was returned as expected.  Is there a case-sensitivity issue here perhaps?

  • Royal King Profile Picture
    Royal King 27,686 on at

    type "chair *"   it will get only records without word chair. Note the space between chair and *. If you want to exclude chair and chairs type "Chair*"

  • Community Member Profile Picture
    Community Member on at

    Hi,

    I have the same problem and I'm still not able to find any answer to it, despite

    Chitrarasan Duraisamy's answer below...

  • ThomasN Profile Picture
    ThomasN 3,190 on at

    Hi Christine, thanks for reaching out.

    Can you share a screenshot of your advanced find query? Thanks.

  • Suggested answer
    Nithya Gopinath Profile Picture
    Nithya Gopinath 17,078 on at

    Hi Christine,

    Can you give the query as follows?

    "Does not Contain" *chair*

    This will exclude all the records with word chair.

    Hope this will help you.

  • Suggested answer
    PS Profile Picture
    PS 23,577 on at

    Add * both as prefix and suffix to the word chair and then it should give you expected results

    Although your query us right and system must give you results for that but somehow there's a problem

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

News and Announcements

Season of Giving Solutions is Here!

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
SA-08121319-0 Profile Picture

SA-08121319-0 4

#1
Calum MacFarlane Profile Picture

Calum MacFarlane 4

#3
Alex Fun Wei Jie Profile Picture

Alex Fun Wei Jie 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans