Questions tagged [sosl]

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

Filter by
Sorted by
Tagged with
0 votes
0 answers
18 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.8k
1 vote
0 answers
34 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
40 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
2 votes
1 answer
113 views

SOSL query the encrypted text field is possible but NOT in Apex test class?

I created an classic encrypted text field called "encryptedPIIData__c" in User object and added the User data. I created a function that is able query out via SOSL based on the encrypted ...
compski's user avatar
  • 1,320
0 votes
0 answers
82 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
35 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
32 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
3 votes
1 answer
155 views

SOSL Find query not returning Standard Profiles, only Custom

Hello! I have a lookup component that uses a dynamic query based around FIND. It works great except when querying Standard Profiles. If I search for profiles, only custom profiles are returned. ...
Tom Adam's user avatar
0 votes
1 answer
71 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
43 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
41 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,543
0 votes
0 answers
58 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
177 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,271
0 votes
2 answers
2k views

SOQL: How to query records based on CreatedDate?

From the opportunity object, using SOQL, I want to query records which have been created x days (say 30 days) before today. I have written the following code: List<Opportunity> oppList = [SELECT ...
user275494's user avatar
0 votes
1 answer
457 views

How to query Master object record only if they have a child record associated to it?

I want to filter out the contacts only if they have at least 1 serviceContract associated to it ? I know this is possible using apex ( query all childs in inner query and iterate through using .size() ...
LWC_Beginner's user avatar
1 vote
1 answer
271 views

Does SOSL work when there is a criteria for filtering the searched object through a lookup?

I have a SOSL query that queries on three different objects. A standard and two custom objects. After implementing the WHERE clause the query on the standard object is the only part that works. When I ...
Renato Oliveira's user avatar
0 votes
1 answer
180 views

Getting Error at Query: SOQL SOSL Injection while using checkmarx scan

global void execute(Database.BatchableContext BC, List<sobject> referenceRecords) { try{ List<Connection_Custom_Setting__c> connection = [select Id, ...
sri's user avatar
  • 1
0 votes
1 answer
412 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
1 answer
90 views

Unpredictable behavior while escaping special characters in sosl

According to SOSL reference here ? & | ! { } [ ] ( ) ^ ~ * : \ " ' + - are reserved characters and need to be escaped by \ I have a rather simple dynamic SOSL Query for searching inside ...
Aman Sharma's user avatar
-1 votes
2 answers
536 views

How can I find a value in all fields using SOSL?

I want to find if any records have a value "Test123" How could I do this using SOSL and Apex? I tried this: List<List<SObject>> l = [FIND 'test123' limit 10]; But it throws an ...
SFGest's user avatar
  • 1
0 votes
1 answer
150 views

How to resolve SOQL SOSL Injection security error

I am fairly new to salesforce. I am getting the soql sosl injection error in the below method while doing query. How to resolve this error? public static Days_Unavailable__c getAvlRecordById(String ...
goel123's user avatar
  • 15
2 votes
1 answer
230 views

SOSL Alphanumeric Search String Behavior, solution using %

I'm trying to understand some SOSL behavior. I had an issue where I needed to do a SOSL search using alphanumeric search strings. EX: 'blue1' We found that attempts to search using alphanumeric data ...
user122313's user avatar
-2 votes
1 answer
121 views

How can I show the Result with the trigger that I created?

So, I'm studying Apex Triggers in Salesforce with a practical exercise. As long as I was developing the exercise, I thought at my logical code, but when I tested the components, I had a problem with ...
Tio Feliz's user avatar
0 votes
1 answer
294 views

How to use WHERE clause in SOSL query

I am trying to use the existing LWC with some modifications to get records on the basis of RecordType.Id but it's throwing an error instead. System.QueryException: expecting a right parentheses, found ...
user avatar
0 votes
2 answers
672 views

Can you look for record ID's using SOSL?

I'm trying to play around with SOSL and was wondering is it possible to look for record ID's using SOSL? I tried FIND {0D56F0000DPRLnKSQX} IN ALL FIELDS RETURNING FeedItem(id,body) But it comes back ...
Hulk Buster's user avatar
1 vote
1 answer
2k views

How to return List of a list in Apex Rest Get Method Using SOSL

I tried make this restapex code, and tried to using SOSL to find value this is my apex code when i used SOQL and it works well. @RestResource(urlMapping='/Account/*') global with sharing class ...
Mustika Farma's user avatar
-3 votes
1 answer
63 views

Illegal assignment from List<String> to List<Order> (4:21)",

Im having this issue which I dont understand. Any advice?
happyLion's user avatar
1 vote
1 answer
214 views

Can I use SOSL to identify all records with a certain lookup value?

What happened: someone incorrectly merged two contacts. A host of related objects had lookups populated to these two contacts. When the contacts merged, all those objects were updated to all point to ...
smohyee's user avatar
  • 3,814
0 votes
0 answers
241 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,560
3 votes
0 answers
362 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
0 votes
0 answers
155 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
-2 votes
2 answers
96 views

because you can't populate a map with lists of lists

trying to populate a map with a list list like this: map<integer , listlist<<sobject>>> mpsosl=[find ' ba' IN all Fields RETURNING contact(name)]; error:Illegal assignment from List&...
Luca Pompili's user avatar
1 vote
1 answer
501 views

Why is "you must specify a language where clause for knowledge articles in this API version" error occurring on API version 51?

I have SOSL queries in my Apex which work well on Knoledge__kav object. When running test classes I receive the "you must specify a language where clause for knowledge articles in this API ...
RedQueries's user avatar
0 votes
1 answer
2k views

SOSL use FIND with bind list of Strings - Specified search expression can not be converted to string

I have a list of strings (phones) which I'm trying to use inside my SOSL Find clause and its giving me issues: List<String> phonesList = new List<String>(); for(Account acc : acclist) { ...
BoDiE2003's user avatar
  • 437
4 votes
1 answer
110 views

What really happens when a SOSL SearchQuery is longer that 4000 characters?

According to the SOQL and SOSL Reference page on FIND {SearchQuery}: If the SearchQuery string is longer than 10,000 characters, no result rows are returned. If SearchQuery is longer than 4,000 ...
Jason Clark's user avatar
  • 11.8k
1 vote
1 answer
198 views

How can I get Record Type, Link and Name of child records from a SOSL search?

I am building a small lightening component that on input search it should return account record names alongside contact record names alongside their types if they are account of contact and a link to ...
Chinomso Johnson's user avatar
2 votes
0 answers
226 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
10 votes
1 answer
7k views

SOQL query to fetch records with reserved characters ('*', '/', '(', ')')

Hoping there is a simple answer that I am overlooking. Currently, we are able to search for the following reserved characters with an escape sequence, eg a backslash character '\', in SOSL: & | ! ...
Evelyn Grizzle's user avatar
2 votes
2 answers
2k views

Is it not possible to search by Id field with SOSL?

Why can't I do this? FIND "0Hn8A00000093AvSAI" IN ALL FIELDS RETURNING Contact(Name, Id) If I put a part of the Name of the contact with that ID, I get that contact back. But when I put the ...
Bloke's user avatar
  • 217
0 votes
2 answers
244 views

SOQL Query to extract certain attachments fails

I want to export attachments of those Owners who belong to a certain Organisation. I tried: SELECT BodyLength FROM Attachment WHERE OwnerId.Organisation_Name__r = 'ExampleCompanyName', but got the ...
Lekü's user avatar
  • 3
0 votes
0 answers
183 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
3 votes
1 answer
442 views

Apex SOSL-query doesn't work

Query Result why SOSL-query is empty?
Ilya Startsev's user avatar
0 votes
1 answer
2k views

Query involving parent and child objects in where, group by and order by clause

I have an object called SRC which has account as lookup in it. SRC content will be as shown below: SRC ID Account__c Status City__c LastModifiedOn 1 1 Yes Delhi 12-Apr 2 1 No Cochin 13-Apr 3 2 No ...
User1230321's user avatar
0 votes
1 answer
175 views

Converted SOSL from SOQL is not working

SOQL query SELECT Id, Name FROM Opportunity WHERE College__r.Phone LIKE '%7411162213' OR College__r.OtherPhone LIKE '%7411162213' on running on developer console it gives result total ...
gourav kumar's user avatar
2 votes
1 answer
132 views

Why does SOQL show there is data but SOSL returns no results?

I want to search for a list of phrases. I used SOSL to search for a string to begin with but it is returning zero results yet when I run a soql I can see there is data. Any ideas? Thanks. FIND {Animal}...
Pauline's user avatar
  • 375
0 votes
1 answer
610 views

SOSL , in all fields and in any fields [closed]

I'm confused on when do i really need to use IN ANY FIELDS and in ALL Fields . Can someone clear things out for me thank you!
Snorlax's user avatar
  • 37
1 vote
2 answers
1k views

History field is blank for this query, Please help :)

I am new to salesforce, please help me out with this one: I am trying the following SOQL query to retrieve the changes made to the teacher object but I am getting nothing in the history tab. I turned ...
abhishek0514's user avatar
0 votes
1 answer
678 views

SOSL Query returning different results in anonymous and class

We are facing a strange error when running SOSL query in our production environment. We have a component that runs SOSL queries within a custom object, looking in all text fields When we run this SOSL ...
mnunezdm's user avatar
  • 900
1 vote
1 answer
899 views

Locating Email within Contact and Leads records using SOSL and LIMIT keyword

I have a question regarding a SOSL statement used with a Limit of 1 in trying to search for an email address in either contact or lead records but I only want to return the first occurrence using the ...
Anthony Williams's user avatar
1 vote
1 answer
399 views

What's the main differences between isQueryable() vs isSearchable()

What's the main differences between isQueryable() vs isSearchable() ? I couldn't find any reasonable information
Swan768's user avatar
  • 41

1
2 3 4 5
7