Tag: SOQL

We are trying to find tasks of the same Subject that occupy a lot of records. For example, there might be 4,000 tasks all titled “Opportunity closing in 3 days”…Read moreSOQL query to find Tasks by Subject and Count

According to the documentation here It states the following: When a SOQL query is executed, up to 2,000 records can be returned at a time in a synchronous request. In…Read moreSOQL limitation in Salesforce standard REST API

I am running a group by query. As part of this, I want to check the sum of one field, and then check if that sum exceeds a number. The…Read moresoql – Combining where and having clauses in group by

Would I be shooting myself in the foot if I manually deleted a single record from the GroupMember object that links an inactive user to a queue? Is there something…Read moresoql – Manually delete GroupMember Record

I have defined 2 sets investmentTeamIds and teamMemberIds, and I am using these sets in this SOQL query List<InvestmentTeam__Share> investmentTeamShares = [ SELECT Id FROM InvestmentTeam__Share WHERE ParentId IN :investmentTeamIds…Read moreMultiple IN clause in SOQL query separated by AND

One more thing please,How would I make the previous month dynamic? Current Code:Report_Month_Start_HARD = DATEADD(DAY,-31,cast(‘2022-11-01’ as date)),Report_Month_End_HARD = DATEADD(DAY,-1,cast(‘2022-11-01’ as date)) That gives me a range of Saturday, October 01,…Read moreHelp with a constant in SOQL (Salesforce)

I ran this query below select id, owner.name, ownerid, title from contentdocument where id = ‘0695i000007L0FIAA0’ I got this results which shows me the owner id I then ran another…Read moreSOQL Query for ContentDocument – Salesforce Stack Exchange

What’s the size of records returned in the SOQL query from REST API? I have an object which I’m querying using REST API SOQL query. It’s returning less than 2000…Read moreSize of records returned in REST API SOQL query

String query = ‘SELECT id,CreatedById,Product.Id,POCGrades__c ,fm_pocname__c,product.Name ,Visit.placeId, fm_poccode__c, createdby.LastName,Visit.LastModifiedDate, createddate, ActualBooleanValue’ + ‘ FROM retailvisitkpi’ + ‘ WHERE createddate = last_month and ‘ + ‘ ( Product.Id = \’01t5j000003tszWAAQ\” +…Read moreSOQL Group by IN Salesforce

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…Read moresoql – Fetch Accounts having more than 3 contact records in it in a single query

When a SOQL query has both a LIMIT clause and a Sforce-Query-Options: batchSize with different but valid values, which one of these gets a higher precedence? A query with only…Read moreRest API – Which has higher priority in a SOQL query, LIMIT clause OR Sforce-Query-Options: batchSize?

I know it’s not the correct way to write the code like this. But can anyone help me to optimize this code without for loop? String userName=”test@test.com%”; List<String> objectNames =…Read moresoql – Can anyone write this code in optimized way?

To effectively use query() at all or use external IDs with upsert() or get(), quoting/escaping must be applied. Think it would be good for this to be built into the…Read moreEnhancement: Quoting/escaping for SOQL values and external IDs

I am trying to run a SOQL query in the dev console to get resultant records where a Contact’s MailingStreet matches a particular LIKE query but can’t seem to get…Read moreSOQL – Contact Mailing Address

We are getting UNABLE_TO_LOCK_ROW error couple time a week. This time I was able to get the logs of it by setting user trace flag on production. When I check…Read moreperformance – Soql taking too long – log says 15 seconds

I have a doubt. Sometimes the developer repeats many queries in different places, but what changes is the number of fields. I sometimes think about centralizing queries, but queries can…Read morebestpractice – SOQL query performance with many or few fields