Salesforce Stack Exchange is a question and answer site for Salesforce administrators, implementation experts, developers and anybody in-between. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I am trying to filter a query based on a value in the formula field ,which is in hyperlink format .When i try quering the formula field based on its value its not returning any results.Is there any other workaround.But i see its access as filterable in Salesforce schema.

share|improve this question

You must be doing something wrong in your query.

I have created a test1__c formula field(in hyperlink format) and its returning proper result.

here is my Soql

select id,name,test1__c from contact where test1__c like '%google%' limit 10 

One more example:

select id,name,test1__c from contact where test1__c = '' limit 10 
share|improve this answer
I dont want to use keyword like because it will return results like google,google+ ,Googleabc...... for the input google .I need exactly the one which is same as Input.Not like – Manoj Chandran Aug 22 '14 at 9:09
above soql was just example. Use your logic to twist it as per your needs. Updated answer with one more example. – AtulRajguru9 Aug 22 '14 at 10:41

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.