Contents
Do you need to see the field in soql?
The field does not need to be seen on the page layout, or visible to users unless you want to have it in reports as well. The format can be text and set the formula like IF ( First_Name__c == Last_Name__c, ‘TRUE’, ‘FALSE’).
How does the for loop in soql work?
The for loop goes through all the candidates in your query, but it does not store them all in your collection; only the ones that do have the two columns match. for (Candidate__c c: [SELECT id,first_name__c,last_name__c FROM Candidate__c LIMIT 30000]) {
How to compare two fields in the same record?
This syntax will not work if you are trying to compare two fields in the same record: select First_Name__c , Last_Name__c from Candidate__c where First_Name__c =Last_Name__c Assuming you can form a query small enough for the governor limits, you could use a loop, like this.
How to compare two columns with the same size?
The column that I want to compare is text datatype with the same size .Just wondering I am doing wrong or actually it is limitation. The only solution that I think of is to retrieve the data, put inside the list then write the logic to compare it , then get the match and put in the final list.Not sure if it will hit governor limit.
Do you need unique fields for external ID?
Values in these external ID field must also be unique and we can also determine whether or not value are case sensitive. Custom fields marked as unique also count against an objects limit of external id fields. Unique Fields + external Id fields <= 25.
How is an account associated with an external ID?
The Account sObject has a custom field marked as External ID. An opportunity record is associated to the account record through the custom External ID field. The example assumes that: Before the new opportunity is inserted, the account record is added to this opportunity as an sObject through the Opportunity.Account relationship field.
How are external IDs used in Salesforce integration?
External ID fields contain record IDs from systems outside Salesforce. We can use the upsert call to match against External ID fields during import or integration. Values in these external ID field must also be unique and we can also determine whether or not value are case sensitive.
How to retrieve data with matched value from two columns?
The only solution that I think of is to retrieve the data, put inside the list then write the logic to compare it , then get the match and put in the final list.Not sure if it will hit governor limit. Thanks. Assuming you can form a query small enough for the governor limits, you could use a loop, like this.
How to acces data from the SF database?
To acces data from SF database you have to use SOQL ( SQL simplify by SalesForce) in a controller (apex class) , Thanks for that. I went thru it already but it seem I could not find what I am looking for. I google but found out mostly query is similar like this, need to receive the parameter.
How to retrieve data from multiple objects in one query?
Try install this app from appexchange ,it has only 7 -8 Scontrol means webpage which will help you to built query from multiple object on click . Once you will install this you will get AjaxExplorer on etab in this app .
How to find related list in soql query?
In our case it is “Account” which is located @Contact. So if you go to detail of this field you will find the Child Relationship Name, which should be ” Contacts “. So the child to parent relationship will have this in its from statement.