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.


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 = 'https://www.google.co.in' limit 10 
| 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 clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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