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