• Devon Fritz
  • NEWBIE
  • 0 Points
  • Member since 2017

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 1
    Questions
  • 1
    Replies
We're using a matching rule for Accounts (aka 'companies') on SF that basically says 'If a company has both the "same name" and an identical company number, consider them duplicates' and a duplicate rule that prevents said duplicates from being created. 

'Same name' uses SF's `FUZZY: COMPANY NAME` logic, which means on creation it's smart enough to recognise eg `Microsoft Inc.` as the same company as `Microsoft` if they share a number.

Unfortunately for us, the SOQL queries don't have the same intelligence - if I run the query "select Id from Account where Name = 'Microsoft'", and I have a company with the name `Microsoft Inc.` I find no results.

Is there a built-in way to do a 'fuzzy search', so that we find any record(s) that would be considered a match according to our matching rules?

Thanks all.
I am really frustrated with a problem that only occurs for me using Chrome and Lightning experience.

When I go to setup, and click on a "classic" setup page like "users", instead of opening it in the LEX iframe in setup, it opens a new browser tab with the setup page in it, but it is non-functional since it expects to be inside of an iframe.

I have tried removing cookies and plugins, but the problem keeps reoccuring and is driving me crazy!

Any help would be greatly appreciated, this has to have affected someone else out there besides me!