Where the Event Invitee list stored in SFDC Object? Events details stored in EVENT Object and Event Invitee list stored in the EventRelations Salesforce Standard Object. How to retrive the …
SOQL
-
-
How to use Salesforce Multipicklist field in SOQL? Consider here BillingState is a Multipicklist and we need to list out only certain states like California and New York. We can …
- APEXSALESFORCESOQL
SObject row was retrieved via SOQL without querying the requested field in Salesforce
SObject row was retrieved via SOQL without querying the requested field in Salesforce Error: SObject row was retrieved via SOQL without querying the requested field: Contact.Name. Solution: If we used …
-
When to use SOQL and SOSL When to use SOQL: The sObject type is predetermined. Result data needs to be joined. You want to query beyond text, email, or phone …
-
Salesforce – List has no rows for assignment to SObject if you using following code in Apex and Error should throw like “List has no rows for assignment to SObject”. …
-
Checking the Current DateTime field in SOQL Apex Code Example: Event e=[Select ActivityDateTime From Event where whatid=:tsk.whatid and what.type = ‘Account’ and ActivityDateTime <> null and ActivityDateTime <=:system.now()];
-
Below is the Query to get the Owner Name and Last Modified By Name in Task Object SOQL: select owner.name,LastModifiedBy.name from task where id =t.id
- APEXSALESFORCESOQL
How to get the current year records from custom object where year is in a text field
How to get the current year records from custom object where year is in a text field? String dateOfToday = String.valueOf(Date.today().year()); Then your SOQL would include this in the where …
-
Scenario: Need to do Totals of Stages in Opportunity for the entire org. Thought Process: What are the columns involved? Answer: StageName and Count or Total What methods will we …
-
Dynamic SOQL and SOSL: Dynamic SOQL/SOSL is nothing but the creation of a SOQL/ SOSL string at runtime with an Apex script. Dynamic SOQL enables you to create more flexible …