No more than 20 parent to child relationships can be specified in a query In

No more than 20 parent to child relationships can be

This preview shows page 48 - 50 out of 52 pages.

No more than 20 parent-to-child relationships can be specified in a query. In each specified relationship, no more than five levels can be specified in a child-to-parent relationship. For example, Contact.Account.Owner.FirstName (three levels). In each specified relationship, only one level of parent-to-child relationship can be specified in a query. For example, if the FROM clause specifies Account, the SELECT clause can specify only the Contact or other objects at that level. It could not specify a child object of Contact. The RecentlyViewed object is updated every time the logged-in user views or references a record. It is also updated when records are retrieved Maximum RecentlyViewed records allowed FOR VIEW and FOR REFERENCE using the FOR VIEW or FOR REFERENCE clause in a SOQL query. To ensure that the most recent data is available, RecentlyViewed data is periodically truncated down to 200 records per object. The maximum offset is 2,000 rows. Requesting an offset greater than 2,000 will result in a NUMBER_OUTSIDE_VALID_RANGE error. Maximum number of rows skipped by OFFSET OFFSET clause The following are SOQL limitations and tips that are specific to some Salesforce objects. Description Object A SOQL query must filter on one of Id , ContentDocumentId , or LinkedEntityId . ContentDocumentLink Custom metadata types support the following SOQL query syntax. SELECT fieldList [...] FROM objectType Custom metadata types [USING SCOPE filterScope] [WHERE conditionExpression ] [ORDER BY field {ASC|DESC} [NULLS {FIRST|LAST}] ] The fieldList can include only non-relationship fields. FROM can include only one object. WHERE can use only EQUAL or IN . ORDER BY can list only one field. 44 SOQL and SOSL Limits Force.com Platform Limits
Image of page 48
Description Object You can use IN and = for comparison operators. You can use AND for a logical operator. External objects A subquery that involves external objects can fetch up to 1,000 rows of data. Each SOQL query can have up to 4 joins across external objects and other types of objects. Each join requires a separate round trip to the external system when executing the query. Expect longer response times for each join in a query. External objects don t support the following aggregate functions and clauses. AVG() function COUNT( fieldName ) function (however, COUNT() is supported) HAVING clause GROUP BY clause MAX() function MIN() function SUM() function External objects also don t support the following. EXCLUDES operator FOR VIEW clause FOR REFERENCE clause INCLUDES operator LIKE operator toLabel() function TYPEOF clause WITH clause The following limits apply only to the OData 2.0 adapter for Lightning Connect.
Image of page 49
Image of page 50

You've reached the end of your free preview.

Want to read all 52 pages?

  • Summer '18
  • alan li
  • E-mail, Filename extension, Computer file, File format

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture