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
1
vote
0answers
26 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
28 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
41 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
20 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
44 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
30 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(...
2
votes
1answer
40 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
100 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
329 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]; ...
4
votes
1answer
55 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
62 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?
0
votes
1answer
161 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
0answers
24 views

Error when storing SOSL Result into other list “Final Exception : Collection Is Ready Only”

I have written a SOSL query to search on a Custom Object and a Standard Object. When I am getting the results from it, then I am trying to store the value of fields into a set, to do a SOQL query ...
0
votes
1answer
75 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
43 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
115 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
38 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
73 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
42 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
52 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
137 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
175 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
60 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
0answers
97 views

How to pass id of selected record from sobject list to the pdf page

I have a Visualforce page with a page block table which contains multiple rows based on the search result from sosl query.Now I need to select multiple rows using checkbox and on button click need to ...
0
votes
1answer
24 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. ...
0
votes
1answer
84 views

SOSL No Result in Apex (Not Test Mode)

I want to query matching Accounts based NRIC Passport No AND Service Agent looking up to custom object Agent__c with a set of Ids (for bulkification) and i'm using: FIND '999999' IN ALL FIELDS ...
0
votes
1answer
256 views

SOSL Multiple Search Words

Trying to search multiple terms in SOSL in APEX. I tried this singular, of course works: [FIND 'searchOne' IN ALL FIELDS RETURNING ACCOUNT] But these don't work: [FIND 'searchOne' OR 'searchTwo' ......
2
votes
1answer
67 views

DescribeFieldResult.isQueryable returns true but field is not supported

I'm writing a component to search all possible objects a lookup can point to and am running into an issue. The code below returns a list of strings to be used in a SOSL query. I've hard-coded Task and ...
0
votes
3answers
224 views

How to write SOSL IN query

I've following SOQL query - SELECT Id, Name, Email, Account.Id, Account.Name FROM Contact WHERE Email in :emails Here emails is a comma separated list of email ids. Can I write the same query in ...
3
votes
3answers
93 views

Array notation for List<List<Sobject>>

In an attempt to be as byte pinching as possible(personal goal), I have a question some time on Google has not been able to answer. I did look at some Java documentation to try and resolve the issue ...
0
votes
1answer
56 views

Global Search in salesforce

I was searching for record by passing some value in global search but I am getting different result whenever add '0' prefix to it. When i am searching for '012345' i got three record but when i search ...
0
votes
0answers
41 views

No FirstPublishLocationId for a File after uploading a new version

I have a custom search component that queries ContentVersion for files that are associated with a custom object. The query uses FirstPublishLocationId to check if a certain field is set at the record ...
0
votes
0answers
46 views

SOSL Returning 0 Results For Custom Setting Objects

We have been using SOSL to query a list of countries defined as a custom setting which was working fine until recently. I have also tried SOSL on other custom setting objects and getting 0 results as ...
3
votes
0answers
84 views

How do I get SOSL WITH HIGHLIGHT in Apex?

Is it possible to get the highlight field from a SOSL search within apex? For example: List<List<Contact>> results = [ FIND {text} IN ALL FIELDS RETURNING Contact(Id, Name) WITH ...
0
votes
2answers
83 views

Does SOSL works when probabilistic encryption is enabled

Does Salesforce SOSL works after enabling probabilistic encryption is enabled on the search field ?
4
votes
1answer
148 views

Does SOSL wildcard (*) work with space characters

I am currently trying to implement a sosl search query, so I can filter out non-letter characters for searching inside the salesforce database. Everything works as expected, however when I encounter a ...
0
votes
1answer
44 views

“Invalid USING clause” error when using list view in SOSL

I am trying to implement SOSL list view search and this is sort of follow up question. I am trying this query in from Apex and getting error in title: System.debug( Search.find('FIND \'foo\' ...
1
vote
1answer
36 views

Error “Failed to get metadata of listview foo_baz for entity Account. ” when trying to search list view

I am trying to use 'search in list views' SOSL feature, but receiving the error mentioned in title. The query in itself is: FIND {fook} IN ALL FIELDS RETURNING Account(Id, Name USING LISTVIEW=...
1
vote
1answer
60 views

Can we use distance in a SOSL query?

Can we use distance field on a SOSL? Below query returns an error FIND {CA} IN ALL FIELDS RETURNING Contact (id, CMFSH__Resume_Id__c, name,email,phone,mailingstreet,mailingCity,mailingState,...
1
vote
1answer
109 views

Contacts with MiddleName values and queries

As per this previous question, I believe that Salesforce (still!) has a bug in querying Contact instances when middle names are enabled and set. If I have a Contact with FirstName "Mohammed", ...
1
vote
1answer
28 views

Retrieve Ids of different SObjects using SOSL

I have the following apex: Schema.SObjectField field = doesNotMatter(); String fieldName = field+''; //fieldName now holds "NameOfTheField" Schema.DescribeFieldResult fieldResult = field.getDescribe()...
3
votes
3answers
2k views

SOQL Like Query?

I am trying to make a query that will search for accounts with a name similar or exactly matching a field value. So for example I have "Sales-Force" in the field. There is an account called "...
0
votes
1answer
39 views

SOSL for self lookup fields

Region__c is the self lookup on Agent__c. One region have many agents. When searchString = region name, it displays only one record. I want to display all Agents in that region. How to achieve this? ...
0
votes
1answer
89 views

SOSL on lookup fields

String query = 'FIND \'*' + searchString + '*\' IN ALL FIELDS RETURNING Ticket__C (Region__r.name, Manager__c, Manager__r.name, Name, Notes__c), user(id,Name)'; I am searching with user name and ...
-1
votes
1answer
182 views

Picklist related Query in salesforce

I Have a Picklist Field Like (Orderstatus__c) Field, Values are (A, B, C, D, E, F) This Picklist Field, when i am querying the Orderstatus__c Filed Those values will be displaying like Un order (B, E, ...
0
votes
1answer
191 views

SOSL and returned fields

In SOQL, if you don't specify the returned fields and then try to query them, you get an error. Is it the same in SOSL? List<List<sObject>> values = [FIND 'acme' IN ALL FIELDS RETURNING ...
3
votes
1answer
28 views

SOSL on Permission Sets error when no ID is included

I am testing SOSL's on Permission Sets for something I am building and noticed that if I don't include the ID in the fields to request, the search fails: An unexpected error occurred. Please ...
0
votes
1answer
166 views

Why do SOSL works after enabling Deterministic Encryption?

I have enabled Deterministic Encryption for my org, encrypted field Account.Name and created new Account 'MyAccount'. So, in my classes or in Developer Console I can search this account only by full ...