Questions tagged [soql]
Salesforce Object Query Language (SOQL), modeled on SQL, for accessing information saved in the Salesforce database.
5,537
questions
1
vote
1
answer
32
views
Queries on Large Object (>1 million rows) Fail to Execute
We have an object with approximately 1.5 million records in Salesforce. These records are created in an external system and synced with Salesforce every 24 hours. On a 24 hour basis, we delete all 1.5 ...
- 162
0
votes
0
answers
17
views
SOQL - how to include fields from the grand parent object in the WHERE cleause
I'm carrying out a query on Quote object. A Quote has an Opportunity which has an Account. Both Quote and Account objects have the field Vat_Rate__c. I'd like to run a query that returns all quotes ...
- 168
0
votes
1
answer
20
views
SOQL Aggregate query for related opportunity
I want to use accounts and related Opportunities in my LWC.
@AuraEnabled(Cacheable=true)
public static Account[] getAllAccounts(){
return [SELECT
Id,
...
- 27
2
votes
1
answer
51
views
Is there a way to test a SOQL query would retrieve a specific sObject without running a query
EDIT: on further research what I want is the Apex equivalent of Collection Filters I have looked at Query Utils but other than the complexity there seems to be lots of "DON'T USE THIS UNDER RISK ...
- 388
2
votes
1
answer
34
views
Test Class Out of Bounds Exception
This is the first time I have messed with test classes, so there may be something I am simply overlooking. However, I am trying to test a simple class but am only getting an out of bounds exception as ...
- 31
2
votes
0
answers
86
views
Where is Database.query() spending (so much) CPU time?
My assumption was that only Apex Code is using CPU time. But the what I measure for code that is run by Salesforce's own Backend code speak a different language.
List<SObject> result = Database....
- 34.6k
0
votes
0
answers
21
views
What is a reified column and how to get all value from it?
There are some objects (like FieldDefinition or AppTabMember) that when you want to uses SOSL SELECT all data from them, it fails with "a filter on a reified column is required". I have a ...
0
votes
1
answer
7
views
duplicate alias: name error while grouping
We are using bundle products in salesforce and I am trying to display the Order products in a PDF document which I am creating using VF page.
In the Order detail page the Bundle products appear ...
- 253
0
votes
0
answers
7
views
How to display the Order products in the same Order as they are shown in Order detail page
I am trying to fetch the CPQ bundle products and show it in the PDF in SOQL. But the Order products aren't getting fetched in the same Order as they are shown in the Order detail page. They are ...
- 253
0
votes
1
answer
31
views
Aggregate result not working in soql query
im new to visualforce and i have this problem:
I have a sObject with customField1__c, customField2__c, customField3__c.
In my main page (with a standard controller and an extension) i want to display ...
0
votes
2
answers
36
views
How to query/make a report for All fields on All objects?
We have a very old org with many objects and unused fields, how can i query/make a report to find all fields for all custom objects, and order them by lastmodified date?
the goal is to find which ...
- 13
0
votes
0
answers
105
views
Omission Problem in Query Salesforce
When I execute this query
List<AggregateResult> query = [
SELECT Max(Id) Id, AccountId, Max(CustomField__c)
FROM Asset WHERE Status = 'X'
AND (CustomField__c = 'Z'
OR ...
-1
votes
0
answers
25
views
Too many SOQL queries: 101 stack [closed]
I have a AccountTest class which run with more than 75% coverage in dev env. But when I tried same class in a another sandbox without any code change give this too many soql error. Can someone have ...
- 1
0
votes
1
answer
30
views
DML, SOQL and DML Sequence
Here is my scenario.
Transaction 1: DML to update the Status field from Open to Closed on ABC record.
Transaction 2: SOQL is performed to retrieve the ABC record before the above DML and updates the ...
- 5
-1
votes
1
answer
33
views
Get all records created by user today
We are about to perform Load Testing and we are performing some complex scenarios. We use a CPQ tool that has many custom object records being involved and inserted. Is there an easy way to get ...
- 833
0
votes
1
answer
17
views
How is transaction defined and how is Governor limit applied in Salesforce SDK?
I am creating an app with iOS using Salesforce SDK. How is transaction defined, and how is governor limit applied in this context?
For example, I have an a.swift file where I am throwing API requests ...
- 1
0
votes
0
answers
17
views
Filter out parent records when they contain no child records in apex
So I have a couple aura/lightning components that are displaying a customer order header (the parent record) along with it's order lines (the child records). Here's a pic:
I have two methods that ...
0
votes
1
answer
33
views
SOQL Query for updating related records
I have two Objects: Opportunity and Bid(custom Object). A bid is having a lookup field to opportunity i.e. an opp. can have multiple bids.
I need to update the comment field of Bid records, but the ...
-3
votes
0
answers
24
views
Hi, I am having query with Salesforce Apex and Triggers send email notifications for status changes for Task object [closed]
I have query in Salesforce Apex.
Send an email notifications When we assigned the new task in particular userr EX. Four users only.
send an email notifications when who assigned the task they will ...
0
votes
0
answers
21
views
SOQL LIKE operator on picklist field appears to fetch results based on matches on label not API value
SOQL LIKE operator on picklist field appears to fetch results based on matches on label not API value.
For example, take this query
SELECT Id, Name, RZone__Type__c FROM RZone__PSPayment__c
WHERE ...
- 923
0
votes
0
answers
25
views
414508781-117745 (-1506038047) error in SOQL in Manufacturing Cloud
In Manufacturing Cloud org, I run following SOQL in Developer Console:
SELECT ID FROM AcctMgrPeriodicTargetDstr ORDER BY Period1.Id,Period2.Id
Then I get following error dialog:
Then I change this ...
- 55
0
votes
0
answers
57
views
Query fields based on object names
Is there a way to join FieldDefinition and Entitydefinition?
I would like to run a query like below but it is not working
select id, DataType, NamespacePrefix, DeveloperName, QualifiedApiName FROM ...
- 1
0
votes
1
answer
26
views
Fetch Accounts having more than 3 contact records in it in a single query
I want to Fetch all the accounts records(not the ids) that have 3 or more contacts present in a single query with contact records in it.
I didn't find any reference of these.
I had tried with some of ...
- 111
0
votes
0
answers
39
views
SOQL for email field just returning 'PersonEmail'
i was having trouble accessing an email fields value via a flow so i tried to access it via SOQL and im just getting 'PersonEmail' instead of an actual value...
select account_email__c from Account ...
- 13
3
votes
1
answer
59
views
Retrieving license consumption stats for a Customer Community Login license
I am testing my app: at this moment I check does it properly count licenses.
Everything was fine until I started checking Community licenses. I have created a user with a Customer Community Login ...
-1
votes
0
answers
17
views
fetch record with maximum end date [closed]
I have three record on the same object. All the record have end date filed. I need to fetch out the record which has maximum end date among three.
- 5
-1
votes
1
answer
24
views
How to compare values in soql query when field may have a different format
I don't know if there is a way to solve this, I couldn't find it.
I am importing a CSV file where I am to create an sObject for each line. The thing is, I have to do a query using a value present in ...
- 483
0
votes
0
answers
16
views
ContentDistributionTrigger after insert ContentDownloadUrl null
I have a ContentDistributionTrigger trigger after insert & update which when fired has a null value for ContentDownloadUrl.
The ContentDistribution is created in a ContentDocumentLinkTrigger as ...
2
votes
1
answer
114
views
Lean, fast and flexible replacement for the fflib QueryFactory
I just decided to kick the fflib QueryFactory out of a customer project because of its complexity and sub-par performance.
My Custom Query Building is fast but I fear I will reinvent the wheel.
Which ...
- 34.6k
0
votes
1
answer
83
views
Order By id not support in Publisher
In my apex code, I have this SOQL: [SELECT ID FROM Publisher Order By Id], this SOQL works fine in API 49, after upgrade to API 54, Salesforce will throw error run this SOQL.
After research I found ...
- 55
2
votes
3
answers
25
views
Unable to return list filtered by current user
Pretty new to this and I am creating a Visualforce page that returns a list of contacts that belong to the logged in user. I have the following controller but when I preview the page I get the
error ...
0
votes
1
answer
34
views
How to write Apex unit test for a function that fetches meta data?
I have a function that returns the list of all custom objects that are currently present in the org, as listed below.
@AuraEnabled
public static List<String> getCustomObjectNames()
{ ...
- 35
-1
votes
1
answer
40
views
Fetch Custom metadata values with add where condition without using soql [closed]
I have a soql query to get custom metadata value with where condition. But to avoid the SOQL query, i would like to replace SOQL with getInstance() method to get the custom metadata values but i ...
- 233
0
votes
1
answer
23
views
Blanking a Field that is not writeable and passing to a lightning data table
I am using Apex to call an SOQL query that returns records and a few of their associated fields, some of which are formula fields which (to my understanding) are not writeable. I am then passing this ...
- 31
-1
votes
0
answers
41
views
What is the way to get all fields and records from salesforce through rest API in java code? [closed]
I made a successful connection with salesforce org with rest API, if I use to execute SOQL like:
select id,name,email,............ from Lead then I am getting an exception as 414 bad Message URI to ...
0
votes
0
answers
41
views
Implementing autocomplete suggestion for record ids
The LWC app that I am currently working on has a feature that lets users fetch information for a record whose record ID is entered. I am looking forward to implementing a feature that proactively ...
- 35
-1
votes
1
answer
41
views
Can someone explain me the difference between these two queries [Select a.Name From account a] and [Select Name From account ]
Why do we need to create instance of an object in an query and what difference does it make from normal query.
I tried running these query and couldn't notice a difference
I was going through some old ...
3
votes
1
answer
215
views
Is "FOR UPDATE" available in dynamic SOQL?
The SOQL doc states that FOR UPDATE is available for inline SOQL
To lock a set of sObject records in Apex, embed the keywords FOR UPDATE after any inline SOQL statement. For example, the following ...
- 62.3k
0
votes
0
answers
16
views
Is there a Public Link Sharing list?
New to Salesforce administration, and just found out that there is an option to create a public link for files.
Is there a way to see all public links created in the instance I manage just like in ...
0
votes
0
answers
45
views
Combining multiple SOQL queries on the same object
I have a list of SOQL queries which are used to fetch the objects associated with corresponding list views. The list views are selected manually by the user, and a generous maximum for how many I'd ...
- 1
0
votes
1
answer
25
views
Querying only the first record in a relationship where the relationship can have multiple records
Lets take the example of the standard objects CollaborationGroup(CG) and CollaborationGroupFeed(CGF). A single CG record can have multiple related CGF records. If I have 10 CG records I want to get ...
1
vote
1
answer
40
views
How to fetch name field for a record of given record id but known object?
I am trying to obtain all related child (look up) records of a record whose record id is passed. Salesforce docs say that for every object, regardless of type, name is a standard field, just like Id.
...
- 35
0
votes
1
answer
27
views
Database.query() question
Is it ok to use String.escapeSingleQuotes() inside of a database.query() or do you need to create a new variable using the String.escapeSingleQuotes() first and then use the new variable in the ...
- 11
-2
votes
1
answer
30
views
second order soql injection checkmarx
String keyword= 'abc'
String search = '\ '%' + String.escapeSingleQuotes(keyword) + '%\ '';
String query = 'Select Id From User Where firstName Like ' +search + 'Limit' + 10;
result = new Map<Id, ...
- 11
0
votes
1
answer
29
views
SOQL SELECT query failing with 'No search term found. The search term must be enclosed in braces.'
I have a Kotlin application that uses Fuel for making HTTP requests to the Salesforce API. One of the HTTP requests that uses a SOQL SELECT query is failing, and I'm not sure why.
val ...
- 3
-1
votes
2
answers
22
views
How do I do an upstream soql with the nested columns to the stage of the most recent opportunity for each campaign member
SELECT Id,
( Select (SELECT OpportunityId.Stagename FROM OpportunityContactRole ORDER BY createdDate DESC LIMIT 1) FROM Contact)
FROM CampaignMember limit 10
This is my super ...
0
votes
1
answer
48
views
SOQL - How to query Lead email using Task object? [duplicate]
SOQL only. I can accessed the Name of the Lead from the Task object, however when I accessed the Lead email, even though the Lead record has an existing email, the email wasn't showing up.
This query ...
0
votes
2
answers
27
views
Select maximum of 2 columns
Is it possible to take the maximum of 2 columns as a new column?
Something like:
select max(start_date, end_date) from contract
- 11
-1
votes
1
answer
44
views
SOQL queries Where Clause given Error UNEXPECTED Token
[ SELECT Name,
(SELECT Communication_Type__c, Communication_Mode__c,
Additional_Information__c, CBProgramInformation__r,
Reporting_Type__c FROM Reporting_Detail__c )
FROM ...
0
votes
2
answers
41
views
Speed up REST SOQL Query
Other than reducing the complexity of the Query is there any way of speeding up how quickly you can iterate through a SOQL Rest Query? I can't use bulk SOQL as I require Parent-to-child relationships ...
- 388