Questions tagged [sosl]
SOSL the Salesforce Object Search Language syntax. Use this tag for questions related to SOSL and handling query ouput.
313
questions
0
votes
1answer
27 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) {
...
4
votes
1answer
33 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 ...
0
votes
0answers
23 views
Executing the searchContactsAndLeads method failed. Either the method does not exist, is not static, or doesnot return the expected search results [duplicate]
public class ContactAndLeadSearch {
public static List<List<sObject>> searchContactsAndLeads(String searchword) {
String searchQuery = 'FIND \'' + searchword + '\' IN ALL ...
1
vote
1answer
38 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 ...
1
vote
0answers
45 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 ...
7
votes
1answer
429 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: & | ! ...
0
votes
2answers
85 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 ...
0
votes
2answers
41 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 ...
0
votes
0answers
55 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 ...
0
votes
1answer
77 views
How to get custom field from ProcessInstance Object
I am trying to get Approval Status and some fields via TargetObjectId.
SELECT Id, TargetObjectId, TargetObject.Name From ProcessInstance Where TargetObjectId='XYZ'
The above SOQL works fine but when ...
1
vote
1answer
58 views
0
votes
1answer
62 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
...
0
votes
1answer
47 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 ...
0
votes
0answers
25 views
How does SOSL match the search term with Email fields?
I want to use SOSL to search for a Contact or Lead with a certain email. I want it to be an exact match but I am not sure about how SOSL matches the email fields with the search term.
Given this SOSL ...
2
votes
1answer
33 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}...
0
votes
1answer
100 views
Getting Malformed Query error when hitting SOSL using Rest Assured
I have a requirement to fetch query results of a SOSL query using REST API. Even after encoding the SOSL search I keep on getting Malformed Query error. I am so far unable to find a reason to it.
This ...
0
votes
1answer
38 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!
1
vote
2answers
90 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 ...
0
votes
0answers
15 views
SOSL for phone fields or email fields but not other fields
SOSL allows you to search within PHONE FIELDS, EMAIL FIELDS, or ALL FIELDS (and a couple of others). Can a single SOSL query be run for a combination of PHONE FIELDS and EMAIL FIELDS?
0
votes
1answer
108 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 ...
0
votes
1answer
32 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 ...
1
vote
1answer
142 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
0
votes
1answer
104 views
SOSL query ApexClass not returning result with Name Fields search group
I'm trying to SOSL search ApexClass below.
FIND {MyTestClass} IN NAME FIELDS RETURNING ApexClass(Name)
The Name on ApexClass is a name field. Why this SOSL query has no record returned?
0
votes
0answers
18 views
SOQL query to get files names related to account [duplicate]
I want to get the names of all related files in the Account object. Below is my query:
SELECT Name, (SELECT Id from Attachments) FROM Account WHERE Id= '0014K00000C6b7pQAB'
When I run the query, it ...
0
votes
0answers
20 views
Underscore returns sosl results
I have a lightning component with an account search. When I type an account name it doesnt show but If i add an underscore to the end of the name, the search result displays.
Ex:
Account1: Medicaid ...
0
votes
1answer
34 views
setFixedSearchResults not working?
I have a test method calling setFixedSearchResults with 5 ids, and then a method performing an SOSL search.
I expect my search to return 5 records. In fact, it did in my previous scratch org, test ...
1
vote
0answers
58 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 "test.abc1@test.digital or test.abc@test.com" and "(123) 456-7890"(based on locale).
we are using ...
0
votes
0answers
26 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 "...
0
votes
1answer
50 views
SOSL Query on Product does not search the standard Family field
I am executing the following query:
FIND {LANDWAGEN} IN ALL Fields RETURNING Product2(ProductCode ORDER BY ProductCode)
I know there are products with this value in the Family field, but 0 rows are ...
0
votes
1answer
628 views
SOSL syntax to search from all objects
I need to create a custom search on Lightning Component where I should be able to search the text from all the objects through SOSL. I followed the module on trailhead and was able to create a custom ...
0
votes
0answers
48 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 ...
0
votes
0answers
33 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 ...
0
votes
2answers
175 views
SOSL Query and Update
I am practicing SOSL queries. I tried to find the matching records of given Email ID across all objects and update it to new Email ID using SOSL query.
My Code:
public class Soslxmpl{
public List&...
3
votes
1answer
264 views
Can we have sub query in SOSL?
I have to retrieve parent and related child records in a query . The way we do it in SOQL is
SELECT Name, Description__c, (SELECT Description__c, Name FROM Child__r)
FROM Parent
Similarly I have ...
1
vote
0answers
60 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 ...
3
votes
0answers
40 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 ...
2
votes
0answers
28 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(...
0
votes
1answer
48 views
SOSL Query: Getting different number of records while searching with 1234* and abcd1234*
I have a community page. It has a search box and a list view to display the search result. Below is the Query I'm building: (It will search in 15M total records)
List<List<sObject>> ...
-1
votes
1answer
107 views
Why the SOSL doesn't get what it needs?
SOSL
String searchword ='Red';
String searchStr1 = '*'+searchword+'*';
String searchQuery = 'FIND \'' + searchStr1 + '\' IN ALL FIELDS RETURNING Product2(Id,Name)';
List<List<sObject>> ...
1
vote
1answer
1k views
SOSL query searching in multiple fields
I want to search in multiple fields using SOSL. I know that it allows to search in all fields using below syntax-
FIND {"Smith"} IN ALL FIELDS RETURNING contact (name), lead (name)
And also works ...
1
vote
1answer
194 views
Does Global Search in lightning truly not have the ability to actually search all records?
I know this is old news, but I wanted to make sure I understood the limitations of Global Search before I go ranting on the IdeaXchange, because it still boggles my mind that you cannot actually ...
0
votes
1answer
128 views
Filter Object Queries Based On Profile Name
So, as the title says, I would like to find all the records of an object that have been created by OR are only visible by a certain profile.
Here is a query I have tried
SELECT Id, Subject, ...
0
votes
1answer
86 views
How Do I Find What Field the SOSL Find value is in?
For example I am searching for a value of a0I1300002XwIQj. My SOSL returns 33 accounts, but I am trying to find what field on the account that the value is in. How would I go about that? Our org has a ...
3
votes
1answer
151 views
SOSL Query not returning wildcard results
I am developing a search function for a community that has to implmenent a SOSL Query against multiple objects in order to return the accurate results. The issue I've run into is that when querying ...
1
vote
1answer
220 views
SOSL query getting malformed query exception
I have built up a dynamic search query using sosl
The query string given below
FIND {a016g00000D57xKAAR} IN ALL FIELDS RETURNING Attachment(ParentId), ContentVersion(FirstPublishLocationId), ...
1
vote
1answer
278 views
Using SOSL with wildcards in apex
I have a contact with name Test Contact in the Org.
I run the SOSL like below in Query Editor and able to get results of contacts containing Test in their name:
Find {*Test*} IN ALL FIELDS RETURNING ...
1
vote
1answer
309 views
Not able to search fields using SOSL for Case module
I am trying to fire a SOSL query in Apex to find phone number exits in Case module. Below is the example of one of the cases that I am trying to search.
I am using following query to search the ...
1
vote
1answer
205 views
SOSL using POST REST /parameterizedSearch API
I got the "/services/data/v46.0/parameterizedSearch" POST API working for a complex SOSL search I want to perform.
I am referring to the Salesforce documentation here: https://developer.salesforce....
1
vote
2answers
441 views
Search with accent and return with/without accent
I was wondering if there is a way for me to search for a non-accented value in SOQL and the results would bring me words with and without accent.
Example:
I searched for "helló" and the result ...
2
votes
1answer
187 views
Variable in SOSL Query
In SOSL can I add a variable to the fields? As:
FIND {Clinica} IN Name Fields RETURNING Account(VARIABLE HERE)
Thanks