how to correctly use not-like operator in FetchXML ?

(0) Share

Report

Posted on by umma

235

In below FetchXML I m trying to do basic not-like operator demo (get records which do not have a 'sample' in name) but records returned are not as expected. Can you please guide where I m doing wrong. Thanks

<fetch mapping='logical'> 
           <entity name='account'>
                      <attribute name='accountid'/> 
                      <attribute name='name'/> 
                             <filter type='and'>
                             <condition attribute='name' 
                             operator='not-like' value='sample'/>
                             </filter>
           </entity>
</fetch>

Sample Data:

*This post is locked for comments

All responses (3)

Answers (1)

Verified answer

Haansi 1,433 Moderator on at

Like (1)

Report

RE: how to correctly use not-like operator in FetchXML ?

CRM 'Advanced Find' let user build queries. It generates fetch XML behind which can be viewed and downloaded.

Back to your query you are doing exact match. Replacing sample with %sample% will return required results.
Suggested answer

BharatPremji 2,485 on at

Like (1)

Report

RE: how to correctly use not-like operator in FetchXML ?

Hi,

Try this:

<condition attribute="name" operator="not-like" value="%sample%" />

Bharat
Suggested answer

ScottDurow 19 on at

Like (2)

Report

RE: how to correctly use not-like operator in FetchXML ?

Hi,

You need to use the % wildcard ,so operator='not-like' value='%sample%'

Hope this answers your question?