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
I have the same question (0)