function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
jenny jadejenny jade 

Query on Accounts

My query doesn't give any results ,but records do exsists.
Domain is a formula field and its field security is visible to all .
select Id,Domain__c, Name from Account where Domain__c    = 'walmart.com'

Please help
Best Answer chosen by jenny jade
Arti KulkarniArti Kulkarni
Does your Domain match exactly as walmart.com? If not then you should use "Like " is SOQL
select Id,Domain__c, Name from Account where Domain__c  like '%walmart.com%'
Or
select Id,Domain__c, Name from Account where Domain__c  like '%walmart.com'
depending on how the data is stored