Error: Invalid field ‘Opportunity.Contract’ specified
Exception: Error: Invalid field 'Opportunity.Contract' specified Resolution: Use ContractId instead of Contract. Sample Query: SELECT Name, ContractId FROM Opportunity LIMIT 2
Tag: Salesforce SOQL
How to get converted Contact Id after Lead conversion in Salesforce?
When the Lead is converted to Account, Contact and Opportunity in Salesforce, ConvertedContactId on the Lead Object will contain the Contact Id after the Lead Conversion. Sample Query: SELECT Name, ConvertedContactId FROM ....
How to check the login histories of all the users in Salesforce?
To check the login histories of all the users in Salesforce, go to Setup --> Administer --> Manage Users --> Login History. SOQL: SELECT Id, LoginTime, UserId FROM LoginHistory WHERE ....
How to query Field History Tracking records in Salesforce?
If field history tracking is enabled for an object, the changes are stored in history table for that particular object. The API name of these tables follows a simple convention ....
How to query setup objects inSalesforce Developer console?
Salesforce Tooling API’s SOQL capabilities for many metadata types allow us to retrieve metadata using queries. Enable "Use Tooling API" to query setup objects in Developer console in Salesforce. Please check ....
How to fetch report name and format using SOQL in Salesforce?
Sample SOQL: SELECT Name, Format FROM Report here Name - Name of the report. Format - Format of the report(Tabular, Summary, Matrix, MultiBlock(Joined report)). For additional queries and fields, check https://developer.salesforce.com/docs/atlas.en-us.api.meta/api/sforce_api_objects_report.htm
How to fetch records form recycle bin in Salesforce?
"ALL ROWS" keyword is used to fetch records form recycle bin in Salesforce. Sample SOQL: SELECT Id, AccountId FROM Contact WHERE IsDeleted = true ALL ROWS Execute the below code in ....
How to get all the trigger names from a Salesforce Organization?
All the Salesforce triggers will be stored in ApexTrigger Entity. So, we can execute a SOQL fetch all the trigger names from a Salesforce Organization. Sample SOQL: SELECT Id, Name, TableEnumOrId ....
How to change the owner to the default owner when transferring records from one org to another using SALESFORCE TO SALESFORCE?
ConnectionReceivedId is the ID of the PartnerNetworkConnection that shared record with your organization. So, write a trigger on before insert that owner should be changed to default owner, when ConnectionReceivedId is ....
How to get Product Name from Opportunity Line item in SOQL?
Sample Query: SELECT PricebookEntry.Product2.Name FROM OpportunityLineItem (Or) SELECT PricebookEntry.Name FROM OpportunityLineItem LIMIT 10 Sample Code: for ( OpportunityLineItem OLI : [ SELECT PricebookEntry.Product2.Name, PricebookEntry.Name FROM OpportunityLineItem LIMIT 10 ] ) ....