Skip to main content

New answers tagged

-1 votes

Query subscribers who have not opened an email in the last XX days

SELECT DISTINCT s.SubscriberKey, s.SubscriberId AS EmailId, s.jobid FROM _Sent s LEFT JOIN _Open o ON s.SubscriberKey = o.SubscriberKey AND o.IsUnique = 1 WHERE o.SubscriberKey IS NULL
Drashti Varaiya's user avatar
0 votes
Accepted

SOQL help with ProcessInstance related objects

Your child select in semi-join does nothing. If you want to query 2 child objects you just do SOQL on the parent and put sub-queries into SELECT I think what you are looking for it is SELECT Id, (...
ytiq's user avatar
  • 4,587
2 votes

Apex Batch QueryLocator : SOQL statements cannot query aggregate relationships more than 1 level away from the root entity object

Even if this were supported, this is a bad idea. Even using just plain one-level subquery causes significant performance penalties in batchable classes in the start method. You can, and should, query ...
sfdcfox's user avatar
  • 497k
1 vote

data is not showing on UI screen what is error in my program plz ans if any know this what mistake i m doing in this

You have declared searchInput twice in your JavaScript file. In your @wire service, you're using searchInput: '$searchKey', but searchKey is not defined anywhere in your code. You should use ...
Tushar Jadav's user avatar
  • 2,268
1 vote

Querying parent-->Child-->Grand child data using salesforce API

I know I'm way late to the party, but now in the Summer '24 release you can traverse five levels of parent child records. List<Account> accts = [SELECT Name, (SELECT LastName, (...
Kevin Antonioli's user avatar
0 votes

Data Loader - Unable to Proceed beyond Edit Your Query

finally i am able to solve the issue. please close data loader and open again with "Run As a Administrator" option it will work
sid matte's user avatar

Top 50 recent answers are included