SFDC Important Notes

SOSL & SOQL

1.Unlike SOQL, which can only query one object at a time, SOSL enables you to search text, email, and                   phone fields for multiple objects simultaneously.

2.If your organization has relationship queries enabled, SOSL supports SOQL relationship queries.

3.Unlike SOQL, which can only query one object at a time, a single SOSL query can search all objects—including custom objects—to which you have access.

 

4.It does not search the following objects and fields:

   

     ·  Any elements such as pick lists that are defined as not searchable (searchable is false).

     ·  Number, date, or checkbox fields. To search for such information, use the query() call instead.

     · Text area fields, unless you use the ALL FIELDS search group.

     ·  Attachment records associated with certain objects, such as Account, Contact, or Opportunity.

5. Use SOQL with the query() call to select records for a single object & use SOSL with the search() call to find records for one or more objects.

6.The optional IN clause doesn't apply to articles, documents, feed comments, feed items, files, products, and solutions. If any of these objects are specified in the RETURNING clause, the search is not limited to specific fields; all fields are returned.

7.The optional LIMIT clause allows you to specify the maximum number of rows returned in the text query, up to 200. If unspecified, then the default is 200, which is the largest number of rows that can be returned. If you specify a limit of 0, no records are returned for that object.

8.SOSL statements cannot exceed 10,000 characters. For SOSL statements that exceed this maximum length, the API returns an MALFORMED_SEARCH exception code; no result rows are returned.

9. Users can perform searches based on division regardless of whether they have the “Affected by Divisions” permission enabled. All searches within a working division also include the global division. For example, if you search within a working division called Western Division, your results will include records found in both the Western Division and the global division.

Objects & Relationships

1.One Object can have only two Master-Detail relationships.

2.If we delete record First Master detail relationship (always primary) then child record c will be deleted.

3.If child C has two Master record A and B, Where A is primary relation then Child record C will inherit the look and feel of Parent object A.

4.Roll up summary field can only be defined on the master object.

5.Roll-up summary fields calculatevalues from a set of related records, such as those in a related list. 

6.The Roll up Summary field is basically of 4 types:

·          Count

·          Sum

·          Min

·          Max