Contents
Why do we need polymorphic lookups in Dataverse?
That last detail is important because you always know what fields will be available for the lookup. Dataverse also supports polymorphic lookups, which can refer to a record from any entity in a set. For example, the Owner field can refer to a record in the Users entity or the Teams entity.
When do you need a polymorphic ID field?
When creating a custom SObject that needs to be related to lots of different SObjects the use of a polymorphic Id field would be ideal.Then developers would not need to know what is in the user environment, or rely on admins setting up their app correctly. Agree that this is necessary.
Is there a polymorphic ID field for Salesforce?
For Salesforce it may be hard to maintain this kind of field but very useful for implementations. We really need this !!! Please!!! Coding ones own is messy in this respect. Certainly this _could_ be done.
How are relationship fields used in a polymorphic relationship?
In a polymorphic relationship, the referenced object of the relationship can be one of several different types of object. Some fields are relationship fields, which means they can be used to get information about a related object. And some of those relationship fields are polymorphic fields.
When to use typeof in a polymorphic statement?
Use TYPEOF in a SELECT statement to control which fields to query for each object type in a polymorphic relationship. The following SELECT statement returns a different set of fields depending on the object type associated with the What polymorphic relationship field in an Event.
How to create a polymorphic relationship in soql?
You can apply any WHERE comparison operator to the object type strings, such as = (Equals) or LIKE. SOQL supports polymorphic relationships using the TYPEOF expression in a SELECT statement. TYPEOF is available in API version 46.0 and later.