Questions tagged [sosl]

SOSL the Salesforce Object Search Language syntax. Use this tag for questions related to SOSL and handling query ouput.

67 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
4 votes
1 answer
385 views

Salesforce search engine vs SOSL

Below is my SOSL query - FIND {searchString} IN ALL FIELDS RETURNING Account(Id,Account_Number__c, RecordType.Name,Name LIMIT 16) 1) When I put searchString = '42430' in sosl query Query 1: ...
Rohit Patil's user avatar
4 votes
1 answer
1k views

SOSL Query against Custom setting object

I am experiencing some inconsistent behavior. On one org - I'm doing a SOSL (Search Query) against a custom setting and it works fine. But on a different org - I get entity type My_Custom_Setting__c ...
Patrick's user avatar
  • 378
3 votes
0 answers
380 views

Bind Variables and Inconsistent Results in SOSL

I have some Apex code that does a SOSL query. If it uses bind variables, some users don't get results. If I build the query with string concatenation, then the results are consistent across users. ...
Daniel Hoechst's user avatar
3 votes
0 answers
66 views

How to make existing custom setting searchable?

I have one custom setting in our org which is not searchable, as verified by confirming that searchable = FALSE when viewing the object info via Workbench. Dozens of other custom settings in our org ...
Martha Seneta's user avatar
3 votes
0 answers
1k views

Salesforce limitation - SOSL search not returning records through keyword exists in the records

In our org there are more than 5 Millon CaseComment record exists. User will navigate from Account record and opens a page upon a button click. User enters the keyword and it should search on the ...
Santanu Boral's user avatar
3 votes
1 answer
596 views

sosl exception on searching with one character

On doing a sosl search with just one character search parameter, I am getting an exception. To overcome this i have used custom error message in the catch block.However I am unable to cover the catch ...
starhunter's user avatar
3 votes
0 answers
1k views

regEx + search capability in sfdc platform

Looking for suggestions on accomplishing search + regEx in sfdc, to search cases which have occurrence of the phrase 'PROVIDED BY:' in case history and get the case number where this phrase was found ...
madballoonist's user avatar
3 votes
1 answer
136 views

how to add a value from a text box to SOSL querry dynamically?

I have written an sosl querry. for(List<SObject> obj:[FIND **'jose'** IN ALL FIELDS RETURNING Lead(id,name,Company,Phone,Street,City,State,PostalCode,Country,Owner.id WHERE (Owner.id=:UserInfo....
user12024's user avatar
3 votes
0 answers
108 views

SOSL unusual behaviour

I have faced and have been facing issues using the SOSL query or I may say SOSL query confuses me every time with its result/output. i have encountered situations when the SOSL search query doesn't ...
Bharadwaj Urma's user avatar
3 votes
0 answers
720 views

How can I access Record Tags and/or Content tags via Apex & SOQL & SOSL

I have a requirement to produce a unified search across Salesforce records using tags and documents in Content. Both records and Content items may have received the same tag from a user and my ...
Ray's user avatar
  • 513
2 votes
0 answers
234 views

SOSL - binding a list of IDs to an IN clause

SOSL is returning different results when using a bind variable. For example, the following code snippet returns fewer results when a bind variable is used and returns more results when the bind ...
Anudeep Gopagoni's user avatar
2 votes
0 answers
84 views

SOSL Wildcart Search Returning Multiple Objects Excludes Results

I am running a SOSL with a query similar to the one below: FIND {joh* OR smith*} IN ALL FIELDS RETURNING Account(Firstname,Lastname WHERE Firstname LIKE 'joh%' AND Lastname LIKE 'smith%'), Contact(...
jordan.baucke's user avatar
2 votes
0 answers
153 views

Searching ContentDocument with SOSL 'Name Fields' appears to return documents with the search string in the content

It looks like when I issue a SOSL statement against NAME FIELDS in ContentDocument, I get documents that have the search string in the content as well. I really need it to just search the name fields,...
Rob Baillie's user avatar
2 votes
1 answer
289 views

Inline edit - record not updating [only last record updating]

whenever i used to edit these records by inline edit function - only the last records getting updated, rest of the records not updating. visualforce code: <apex:page sidebar="false" ...
salesforce's user avatar
2 votes
0 answers
47 views

Search in related objects fields

Is there a way to make a single SOSL query to search in fields of related objects? For example: "find all tasks related to accounts are named X*".
Tzach's user avatar
  • 684
2 votes
0 answers
269 views

GROUP BY Clause in SOSL (FIND instead of SELECT)

I am looking for the equivalent of the GROUP BY statement but then for a FIND query. I want to do a search on all fields of ContentVersion by a keyword and I want it to return a list of all values in ...
Wim's user avatar
  • 574
2 votes
1 answer
496 views

combine two SearchGroups in SOSL search

Can I combine two SearchGroup in one SOSL query? I want to search both in Name Fields and in Phone fields. Something like FIND {78*} IN (NAME , PHONE) FIELDS RETURNING Contact(id,name,phone)
Polina F.'s user avatar
  • 123
1 vote
0 answers
40 views

SOSL Problem - Unexpected Results

I'm doing a parameterized search, but unfortunately I'm getting strange results. I've added a long text field that, using a flow, is populated with the contents of a group of important fields: Project ...
dmgig's user avatar
  • 196
1 vote
0 answers
73 views

Does filtering in lightning-record-picker support SOSL?

I am using the lightning-record-picker component and I am querying an object which has its 'Name' field encrypted. This means that I'm returning a 'the like operator is not supported on an encrypted ...
Andy Hitchings's user avatar
1 vote
0 answers
407 views

Dynamic SOSL with multiple search terms not returning records with email or phone number

I am facing couple of challenges with Dynamic SOSL. Records are available with "[email protected] or [email protected]" and "(123) 456-7890"(based on locale). we are using ...
Ragavendra's user avatar
1 vote
0 answers
238 views

SOQL query with 'LIKE not giving expected results

In my org, I've set up some custom metadata on which I have all text fields which I am querying. On my query without anything in the where condition SELECT Label,Fields__c,Labels__c,Scheme__c from ...
N_H1922's user avatar
  • 315
1 vote
0 answers
283 views

SOSL Filter on Community Topics

Back in 2014 @pchittum had mentioned in the Discussion Forums that he hoped that maybe some day we might be able to filter by topics using SOSL: My wish is that some day in the future you can just ...
glls's user avatar
  • 20.1k
1 vote
0 answers
63 views

Too may query rows:50001

There are more than 40,000 records in my production database. Whenever I Search using these queries I get this error: Too may query rows:50001 SOSL query: String searchQuery = 'FIND \' '+...
Trishagni's user avatar
1 vote
0 answers
204 views

Return category group with salesforce knowledge articles

I' writing one sosl query, where I'm facing problem while returning category group. FIND {tourism} RETURNING KnowledgeArticleVersion (Id, Title WHERE PublishStatus='draft') WITH DATA CATEGORY ...
salesforce Developer's user avatar
1 vote
0 answers
248 views

How to select the first record from multiple records from SOSL query

I am using SOSL query: List<List<Account>> acclist = [FIND :newstring IN ALL FIELDS RETURNING Account(id,Name,FirstName,LastName,Territory_vod__c,NPI_vod__c where RecordType.Name='...
devsfdc's user avatar
  • 441
1 vote
0 answers
884 views

SOSL with multiple conditions not working

I have a SOSL search Query String suppliedSearchText1 = 'account'; Set<String> setselectedObjects = new Set<String>{'Account','contact'}; String SearchQuery = 'FIND \'' + ...
Shilpa's user avatar
  • 687
1 vote
0 answers
195 views

accessing related lookup in SOQL query

Hi I am writing a SOQL query. I use Fuse IT to check my SOQL queries. So the Query is: Select Id,Name,Material__r.APS_Account__r.FirstName, Material__r.APS_Account__r.LastName from Material_Order ...
Dino's user avatar
  • 139
1 vote
0 answers
1k views

Access email subject and email body data in global search

I just noticed that in global search results, data mentioned in email body or email subject is not accessible for search results (SOSL) due to salesforce search limitations. Ref: https://help....
Dave's user avatar
  • 507
1 vote
1 answer
182 views

how to find a word in url column in a given object

I am looking for SOQL/SOSL to find records in object having a URL column with some filter(text in column( on URL column, tries like and sosl, both doesn't work. Any help ?
Ashish Narang's user avatar
0 votes
0 answers
18 views

can I create SOQL or SOSL command to get content of a report?

I know nothing about SF. I want to get content - preferably as .csv - or a report that someone created for me. I do not have SF account. I have access to an integration account that I managed to ...
Radek's user avatar
  • 101
0 votes
0 answers
20 views

What does SOSL's "Update Tracking" actually update?

The SOSL Documenation's Update an Article’s Keyword Tracking with SOSL page states: Track keywords that are used in Salesforce Knowledge article searches with the UPDATE TRACKING optional clause on a ...
Jason Clark's user avatar
  • 11.9k
0 votes
0 answers
98 views

Performing Fuzzy search by using multiple keywords, on a specific long text area field which has keywords, hashtags on a custom object

I have a requirement to perform fuzzy search on a specific long text area field on a custom object and return the results, where long text area field can have some keywords, hashtags or quantity of ...
Vasudev Pai's user avatar
0 votes
0 answers
41 views

SOSL Returning incorrect result

We have one Unit Object and it has Description Text Field 255 char. Unit Object has 50 records with '48" Test Description' As a value in description__c field. Now We have SOSL Query as below, ...
Sagar Thoriya's user avatar
0 votes
0 answers
42 views

SOSL Trailhead Challenge Issue

I'm new to salesforce but learing a bunch. I'm working on the SOSL challenge. My code is returning the correct data (I think) but I still fail the challenge. Any guidance would be super appreciated. ...
CasaCoding's user avatar
0 votes
1 answer
77 views

Run SOSL without any search term

I have read the documentation for SOSL and have a usecase which is not explicitly mentioned anywhere. I can not use SOQL as it takes over 15 seconds. We have some non-index fields and wild cards ...
Dave's user avatar
  • 1
0 votes
0 answers
46 views

SOSL email search is unable to locate a record in Salesforce immediately after the record has been saved (AWS and Salesforce)

I am using 2 platforms to do Extract , Transform, Load (ETL): Salesforce (SF) AWS I need to ingest taxonomy CSV files based on specific campaigns - called MVIs - into Salesforce. There are ...
Anthony Williams's user avatar
0 votes
0 answers
47 views

How are snippets generated when searching Knowledge Articles with SOSL and including the WITH SNIPPET keyword?

My user has admin profile and I made sure that I have at least read access on all fields on Knowledge__kav object. When I execute the below query in Developer Console I often do not get any snippets ...
smukov's user avatar
  • 5,553
0 votes
0 answers
60 views

'includes' search behavior on SOSL

Reading about 'includes' filter on SOSL I have a question: What happens if I do: ...MyCustomField__c includes ('valueA,valueB') ? What i know:. If I do: ...MyCustomField__c includes ('valueA;valueB') ...
Catarina Nogueira's user avatar
0 votes
0 answers
187 views

Is there a way to fetch the query plan for or insights about any specific SOSL execution?

Is there an alternate way to fetch the query plan of a SOSL execution (other than thru Developer Console > Query Editor)? My objective is to get some insights about any specific SOSL execution (...
arut's user avatar
  • 5,281
0 votes
1 answer
433 views

I want to add no of count of task on lead

There are 2 fields in the lead object ,total_count__c is for count the total no of task on the lead and in the No_of_Call_Count__c i want only those task whose subject contains 'Call' in the subject ...
user122731's user avatar
0 votes
0 answers
251 views

What should be used to search a string across multiple fields of a single object? SOQL or SOSL

I want to search records for a particular object based on filter string that can match multiple fields on that object. This can be achieved via both SOQL and SOSL: SOQL : using like operator, applying ...
Sarang's user avatar
  • 2,580
0 votes
0 answers
160 views

Need help in putting not equal to field in SOSL in Salesforce

I have created the below SOSL for my Apex class as per the req to return the queried valued from the data base , but i am not able to put the not equal to operator in below SOSL, i have tried the ...
Sumintha's user avatar
0 votes
0 answers
185 views

SOSL does not find gmail domain in emails for Site Guest User

When running a SOSL query as the Site Guest User in an Experience Site, I am unable to retrieve any results if I return more than one object at a time while the search query is 'gmail.com' As an ...
nuadaria's user avatar
0 votes
0 answers
60 views

Mysterious SOSL results for Product2: adding term increases number of results

I am running SOSL queries on the Product2 table and I am getting results that I don't understand. Our Product2 table contains about 17,000 items, most of them tyres. A typical product name is "...
Sander de Jong's user avatar
0 votes
0 answers
92 views

Getting Error while querying Account list -sosl -salesforce

I am getting error while querying Account & cusst obj Customer ,Below is my error and query. Error :"Line: 9, Column: 29 Incompatible types since an instance of List<SObject> is never ...
AM_SFDC's user avatar
  • 21
0 votes
0 answers
253 views

Lookup text field is returned as object in SOSL query

this query is run on the Contact object. I need to get the name of the Account which is assigned to current contact. the query works with simple SOQL: SELECT Account.Name FROM Contact LIMIT 1 Output ...
Valentine Potapov's user avatar
0 votes
1 answer
161 views

SOSL return failing manage package

SOSL running fine on lower instances with no namespace getting failed in manage package.Although the SOSL EXECUTE returns rows but final output always remains 0. Working fine on unmanage. searchQuery ...
AvengerSF's user avatar
  • 212
0 votes
1 answer
499 views

How to use dynamic filters in SOSL queries

I have this below 2 SOSL queries. One which is simple one and 2nd is dynamic. I am passing the below data to this method. The 1st SOSL is returning the data, but the dyanamic SOSL is returning NULL. ...
learningmode's user avatar
0 votes
1 answer
71 views

Replacing SOQL By SOSL- facing issue

So, I've parent object and approx 17-18 child object(most connected via Look ups relationship). Data goes into child object based on some conditions. Not all child objects are required to be filled at ...
curious_techy's user avatar
0 votes
0 answers
34 views

What are the ways in which access to a field by query can be changed?

On a visualforce page with a controller, users could previously search on a custom contact field via SOSL. A few weeks ago, something changed and users get no results back in the search as if they ...
S.B.'s user avatar
  • 2,071