Questions tagged [sosl]
SOSL the Salesforce Object Search Language syntax. Use this tag for questions related to SOSL and handling query ouput.
292
questions
0
votes
0answers
14 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
16 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
15 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
30 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
23 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
25 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
113 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
46 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
26 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
78 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&...
2
votes
1answer
114 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
44 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
30 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
27 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
33 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
58 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>> ...
0
votes
0answers
15 views
SOSL distance function is not giving result with encrypted mailing field of contact?
I am using encrypted mailing field for distance search in Apex code and queryEditor, but its not working with encrypted mailing address.
Below is my query:
SELECT id, DISTANCE( MailingAddress, ...
1
vote
1answer
362 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
49 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
24 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
53 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 ...
2
votes
1answer
107 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
129 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
132 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
140 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
114 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
226 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
125 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
0
votes
1answer
64 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 ...
0
votes
1answer
60 views
Help with the SOQL query on multiple objects
Need SOQL or SOSL query to return the Accounts Name having at least a Partner, and/or Contact and/or an Activity attached to it.
So far i am able to get the account name where owner ID is '...
0
votes
1answer
39 views
SOSL issue- Ranking of results set
We're using SOSL to search Account and Contact objects and facing an issue.
Records are returned in a variable of type List<List<sobject>> say searchList
I'm using this variable(...
3
votes
1answer
113 views
SOSL query on Lightning Knowledge Articles returns only 250 records even if there are more than 2000+ matching records
Below query returns 250 records
FIND {*test*} IN ALL FIELDS RETURNING Knowledge__kav(Id, Title WHERE PublishStatus='online' AND Language= 'en_US')
Below query returns 2000 records
FIND {*test*} IN ...
2
votes
1answer
633 views
SOSL not returning all expected results
I'm trying to SOSL search a custom object we have, by a phone number field but the results are not working as I'd expect. The issue seems to be around missing characters at the start of the search ...
0
votes
2answers
1k views
What is the data type returned by the following SOSL search
While preparing for DEV450 I got below question in one of the sample test
What is the data type returned by the following SOSL search? [FIND 'Acme*' IN NAME FIELDS RETURNING Account, Opportunity];
A -...
4
votes
1answer
83 views
SOSL Doesn't find data with wildcards
I'm working on a query to find some duplicate records by name. I take the name and replace anything thats not a letter with a wildcard. I wind up with a query that looks like this:
FIND {Name*Name*} ...
1
vote
0answers
28 views
How to get list of all sobject records modified today in the system? [duplicate]
I need a list of all sobject records that got modified today. this is not just for one object but for all objects in the system. Is there a simpler way to do this?
Please reply.
1
vote
1answer
123 views
How to get list of all sobject records modified today in the system?
I need a list of all sobject records that got modified today. this is not just for one object but for all objects in the system. Is there a simpler way to do this?
1
vote
1answer
1k views
System Permissions Assigned to Permission Set
Is there a SOQL/SOSL to export/FETCH only the System Permissions from a Specific Permission Set in Salesforce.
0
votes
1answer
225 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.
...
0
votes
1answer
422 views
Sidebar fields in the 'IN Searchroup' in SOSL?
I have read in the developer guide that I can also search for Sidebar fields but I was wondering what exactly does he mean by Sidebar fields ? I would be greatful if someone gave me some examples.
...
-2
votes
2answers
749 views
How to create very generic dynamic SOSL query [closed]
I have this below method which i want to make it more generic which can be used for any object and pass any filter to SOSL query according to object passed(build dynamic) . From lightning component i ...
0
votes
1answer
42 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 ...
5
votes
1answer
295 views
Is there a reliable way to know which SObjects are supported by a SOSL search?
Having some trouble as an ISV with dynamic SOSL. I have a search box that searches all records. When building the SOSL query, I only add objects that have the IsSearchable flag set to true on the ...
0
votes
2answers
256 views
SOSL not returning record in test
I have EditorModalController.searchDoctors that returns a list of contacts.
public class EditorModalController {
@AuraEnabled
public static List<Contact> searchDoctors(String ...
0
votes
1answer
73 views
Most efficient way to get all child records for a specific record
I have an account record that I want to get every single possible child record - ideally as a list of IDs.
Currently I am doing the following:
for(Opportunity opp : [SELECT ID From Opportunity ...
9
votes
1answer
224 views
SOSL query having issues with quotes (in the record(s) that should be returned, not the query string)
Tried to do some due diligence before asking this one. I have read the SOSL documentation, and have done some cursory searching here on SFSE.
Scenario
I have an integration with an external system, ...
2
votes
1answer
2k views
Does containsIgnoreCase() and contains() string methods , work with a Rich Text Field?
I am working on use case, where i need to search a keyword on a custom Object containing three Rich Text Fields. I am using the string method containsIgnoreCase(). But even if the field contains the ...
0
votes
0answers
25 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 ...
0
votes
3answers
65 views
type error with apex
with a list of "mails", I want to search for emails in my salesforce object "PrincipalProduit__c", but I find errors in my variable "var and searchList"
public List<String> getValo(){
List<...
0
votes
1answer
38 views
Search in All Fields plus topics for feeditems
I currently have an SOSL query
[FIND :finalSearchText IN ALL FIELDS RETURNING FeedItem(Id, Title WHERE Type = 'QuestionPost') LIMIT 10];
This works great for searching the feed item title and body.
...
