Edit

Share via

Solution table/entity reference (Microsoft Dataverse)

A solution which contains CRM customizations.

Messages

The following table lists the messages for the Solution table. Messages represent operations that can be performed on the table. They may also be events.

Name
Is Event?		 Web API Operation SDK for .NET
Associate
Event: True		 Associate records Associate records
CloneAsPatch
Event: False		 CloneAsPatch CloneAsPatchRequest
CloneAsSolution
Event: False		 CloneAsSolution CloneAsSolutionRequest
Create
Event: False		 POST /solutions
See Create		 Create records
Delete
Event: False		 DELETE /solutions(solutionid)
See Delete		 Delete records
DeleteAndPromote
Event: False		 DeleteAndPromote DeleteAndPromoteRequest
Disassociate
Event: True		 Disassociate records Disassociate records
Retrieve
Event: False		 GET /solutions(solutionid)
See Retrieve		 Retrieve records
RetrieveMultiple
Event: False		 GET /solutions
See Query data		 Query data
Update
Event: False		 PATCH /solutions(solutionid)
See Update		 Update records
Upsert
Event: False		 PATCH /solutions(solutionid)
See Upsert a table row		 UpsertRequest

Properties

The following table lists selected properties for the Solution table.

Property Value
DisplayName Solution
DisplayCollectionName Solutions
SchemaName Solution
CollectionSchemaName Solutions
EntitySetName solutions
LogicalName solution
LogicalCollectionName solutions
PrimaryIdAttribute solutionid
PrimaryNameAttribute friendlyname
TableType Standard
OwnershipType OrganizationOwned

Writable columns/attributes

These columns/attributes return true for either IsValidForCreate or IsValidForUpdate (usually both). Listed by SchemaName.

ConfigurationPageId

Property Value
Description A link to an optional configuration page for this solution.
DisplayName Configuration Page
IsValidForForm True
IsValidForRead True
LogicalName configurationpageid
RequiredLevel None
Type Lookup
Targets webresource

Description

Property Value
Description Description of the solution.
DisplayName Description
IsValidForForm True
IsValidForRead True
LogicalName description
RequiredLevel None
Type String
Format TextArea
FormatName TextArea
ImeMode Auto
IsLocalizable True
MaxLength 2000

EnabledForSourceControlIntegration

Property Value
Description Indicates if solution is enabled for source control integration
DisplayName Enabled for Source Control Integration
IsValidForForm True
IsValidForRead True
LogicalName enabledforsourcecontrolintegration
RequiredLevel SystemRequired
Type Boolean
GlobalChoiceName solution_enabledforsourcecontrolintegration
DefaultValue False
True Label Yes
False Label No

FriendlyName

Property Value
Description User display name for the solution.
DisplayName Display Name
IsValidForForm True
IsValidForRead True
LogicalName friendlyname
RequiredLevel SystemRequired
Type String
Format Text
FormatName Text
ImeMode Auto
IsLocalizable True
MaxLength 256

PublisherId

Property Value
Description Unique identifier of the publisher.
DisplayName Publisher
IsValidForForm True
IsValidForRead True
LogicalName publisherid
RequiredLevel SystemRequired
Type Lookup
Targets publisher

SolutionId

Property Value
Description Unique identifier of the solution.
DisplayName Solution Identifier
IsValidForForm False
IsValidForRead True
LogicalName solutionid
RequiredLevel SystemRequired
Type Uniqueidentifier

SolutionPackageVersion

Property Value
Description Solution package source organization version
DisplayName Solution Package Version
IsValidForForm False
IsValidForRead True
LogicalName solutionpackageversion
RequiredLevel None
Type String
Format VersionNumber
FormatName VersionNumber
ImeMode Auto
IsLocalizable False
MaxLength 256

SolutionType

Property Value
Description Solution Type
DisplayName Solution Type
IsValidForForm False
IsValidForRead True
LogicalName solutiontype
RequiredLevel None
Type Picklist
DefaultFormValue 0
GlobalChoiceName solution_solutiontype

SolutionType Choices/Options

Value Label
0 None
1 Snapshot
2 Internal

SourceControlSyncStatus

Property Value
Description Indicates the current status of source control integration
DisplayName Source Control Sync Status
IsValidForForm True
IsValidForRead True
LogicalName sourcecontrolsyncstatus
RequiredLevel SystemRequired
Type Picklist
DefaultFormValue 0
GlobalChoiceName solution_sourcecontrolsyncstatus

SourceControlSyncStatus Choices/Options

Value Label
0 Not started
1 Initial sync in progress
2 Errors in initial sync
3 Pending changes to be committed
4 Committed

TemplateSuffix

Property Value
Description The template suffix of this solution
DisplayName Suffix
IsValidForForm True
IsValidForRead True
LogicalName templatesuffix
RequiredLevel None
Type String
Format Text
FormatName Text
ImeMode Auto
IsLocalizable False
MaxLength 65

Thumbprint

Property Value
Description thumbprint of the solution signature
DisplayName Thumbprint
IsValidForForm True
IsValidForRead False
LogicalName thumbprint
RequiredLevel None
Type String
Format Text
FormatName Text
ImeMode Auto
IsLocalizable False
MaxLength 65

UniqueName

Property Value
Description The unique name of this solution
DisplayName Name
IsValidForForm True
IsValidForRead True
LogicalName uniquename
RequiredLevel SystemRequired
Type String
Format Text
FormatName Text
ImeMode Auto
IsLocalizable False
MaxLength 65

Version

Property Value
Description Solution version, used to identify a solution for upgrades and hotfixes.
DisplayName Version
IsValidForForm True
IsValidForRead True
LogicalName version
RequiredLevel SystemRequired
Type String
Format VersionNumber
FormatName VersionNumber
ImeMode Auto
IsLocalizable False
MaxLength 256

Read-only columns/attributes

These columns/attributes return false for both IsValidForCreate and IsValidForUpdate. Listed by SchemaName.

CreatedBy

Property Value
Description Unique identifier of the user who created the solution.
DisplayName Created By
IsValidForForm True
IsValidForRead True
LogicalName createdby
RequiredLevel None
Type Lookup
Targets systemuser

CreatedOn

Property Value
Description Date and time when the solution was created.
DisplayName Created On
IsValidForForm True
IsValidForRead True
LogicalName createdon
RequiredLevel None
Type DateTime
CanChangeDateTimeBehavior False
DateTimeBehavior UserLocal
Format DateAndTime
ImeMode Inactive
SourceTypeMask 0

CreatedOnBehalfBy

Property Value
Description Unique identifier of the delegate user who created the solution.
DisplayName Created By (Delegate)
IsValidForForm True
IsValidForRead True
LogicalName createdonbehalfby
RequiredLevel None
Type Lookup
Targets systemuser

FileId

Property Value
Description File Id for the blob url used for file storage.
DisplayName File Id
IsValidForForm False
IsValidForRead False
LogicalName fileid
RequiredLevel None
Type File
MaxSizeInKB 128000

InstalledOn

Property Value
Description Date and time when the solution was installed/upgraded.
DisplayName Installed On
IsValidForForm False
IsValidForRead True
LogicalName installedon
RequiredLevel None
Type DateTime
CanChangeDateTimeBehavior False
DateTimeBehavior UserLocal
Format DateOnly
ImeMode Auto
SourceTypeMask 0

IsApiManaged

Property Value
Description Information about whether the solution is api managed.
DisplayName Is Api Managed Solution
IsValidForForm False
IsValidForRead True
LogicalName isapimanaged
RequiredLevel SystemRequired
Type Boolean
GlobalChoiceName solution_isapimanaged
DefaultValue False
True Label Yes
False Label No

IsInternal

Property Value
Description Indicates whether the solution is internal or not.
DisplayName Is internal solution
IsValidForForm False
IsValidForRead False
LogicalName isinternal
RequiredLevel None
Type Boolean
GlobalChoiceName solution_isinternal
DefaultValue False
True Label Yes
False Label No

IsManaged

Property Value
Description Indicates whether the solution is managed or unmanaged.
DisplayName Package Type
IsValidForForm True
IsValidForRead True
LogicalName ismanaged
RequiredLevel None
Type Boolean
GlobalChoiceName solution_ismanaged
DefaultValue False
True Label Managed
False Label Unmanaged

IsVisible

Property Value
Description Indicates whether the solution is visible outside of the platform.
DisplayName Is Visible Outside Platform
IsValidForForm False
IsValidForRead True
LogicalName isvisible
RequiredLevel None
Type Boolean
GlobalChoiceName solution_isvisible
DefaultValue True
True Label Yes
False Label No

ModifiedBy

Property Value
Description Unique identifier of the user who last modified the solution.
DisplayName Modified By
IsValidForForm False
IsValidForRead True
LogicalName modifiedby
RequiredLevel None
Type Lookup
Targets systemuser

ModifiedOn

Property Value
Description Date and time when the solution was last modified.
DisplayName Modified On
IsValidForForm False
IsValidForRead True
LogicalName modifiedon
RequiredLevel None
Type DateTime
CanChangeDateTimeBehavior False
DateTimeBehavior UserLocal
Format DateAndTime
ImeMode Inactive
SourceTypeMask 0

ModifiedOnBehalfBy

Property Value
Description Unique identifier of the delegate user who modified the solution.
DisplayName Modified By (Delegate)
IsValidForForm True
IsValidForRead True
LogicalName modifiedonbehalfby
RequiredLevel None
Type Lookup
Targets systemuser

OrganizationId

Property Value
Description Unique identifier of the organization associated with the solution.
DisplayName Organization
IsValidForForm False
IsValidForRead True
LogicalName organizationid
RequiredLevel SystemRequired
Type Lookup
Targets organization

ParentSolutionId

Property Value
Description Unique identifier of the parent solution. Should only be non-null if this solution is a patch.
DisplayName Parent Solution
IsValidForForm True
IsValidForRead True
LogicalName parentsolutionid
RequiredLevel None
Type Lookup
Targets solution

PinpointAssetId

Property Value
Description
DisplayName
IsValidForForm False
IsValidForRead True
LogicalName pinpointassetid
RequiredLevel None
Type String
Format Text
FormatName Text
ImeMode Inactive
IsLocalizable False
MaxLength 255

PinpointPublisherId

Property Value
Description Identifier of the publisher of this solution in Microsoft Pinpoint.
DisplayName
IsValidForForm False
IsValidForRead True
LogicalName pinpointpublisherid
RequiredLevel None
Type BigInt
MaxValue 9223372036854775807
MinValue -9223372036854775808

PinpointSolutionDefaultLocale

Property Value
Description Default locale of the solution in Microsoft Pinpoint.
DisplayName
IsValidForForm False
IsValidForRead True
LogicalName pinpointsolutiondefaultlocale
RequiredLevel None
Type String
Format Text
FormatName Text
ImeMode Inactive
IsLocalizable False
MaxLength 16

PinpointSolutionId

Property Value
Description Identifier of the solution in Microsoft Pinpoint.
DisplayName
IsValidForForm False
IsValidForRead True
LogicalName pinpointsolutionid
RequiredLevel None
Type BigInt
MaxValue 9223372036854775807
MinValue -9223372036854775808

PublisherIdOptionValuePrefix

Property Value
Description
DisplayName
IsValidForForm False
IsValidForRead True
LogicalName publisheridoptionvalueprefix
RequiredLevel None
Type Integer
MaxValue 2147483647
MinValue -2147483648

PublisherIdPrefix

Property Value
Description
DisplayName
IsValidForForm False
IsValidForRead True
LogicalName publisheridprefix
RequiredLevel None
Type String
Format Text
FormatName Text
ImeMode Auto
IsLocalizable False
MaxLength 256

UpdatedOn

Property Value
Description Date and time when the solution was updated.
DisplayName Updated On
IsValidForForm False
IsValidForRead True
LogicalName updatedon
RequiredLevel None
Type DateTime
CanChangeDateTimeBehavior False
DateTimeBehavior UserLocal
Format DateAndTime
ImeMode Inactive
SourceTypeMask 0

UpgradeInfo

Property Value
Description Contains component info for the solution upgrade operation
DisplayName
IsValidForForm False
IsValidForRead True
LogicalName upgradeinfo
RequiredLevel None
Type Memo
Format TextArea
FormatName TextArea
ImeMode Auto
IsLocalizable False
MaxLength 1073741823

VersionNumber

Property Value
Description
DisplayName
IsValidForForm False
IsValidForRead True
LogicalName versionnumber
RequiredLevel None
Type BigInt
MaxValue 9223372036854775807
MinValue -9223372036854775808

Many-to-One relationships

These relationships are many-to-one. Listed by SchemaName.

fileattachment_solution_fileid

One-To-Many Relationship: fileattachment fileattachment_solution_fileid

Property Value
ReferencedEntity fileattachment
ReferencedAttribute fileattachmentid
ReferencingAttribute fileid
ReferencingEntityNavigationPropertyName fileid
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: NoCascade
Delete: RemoveLink
Merge: NoCascade
Reparent: NoCascade
RollupView: NoCascade
Share: NoCascade
Unshare: NoCascade

lk_solution_createdby

One-To-Many Relationship: systemuser lk_solution_createdby

Property Value
ReferencedEntity systemuser
ReferencedAttribute systemuserid
ReferencingAttribute createdby
ReferencingEntityNavigationPropertyName createdby
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: NoCascade
Delete: NoCascade
Merge: NoCascade
Reparent: NoCascade
RollupView: NoCascade
Share: NoCascade
Unshare: NoCascade

lk_solution_modifiedby

One-To-Many Relationship: systemuser lk_solution_modifiedby

Property Value
ReferencedEntity systemuser
ReferencedAttribute systemuserid
ReferencingAttribute modifiedby
ReferencingEntityNavigationPropertyName modifiedby
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: NoCascade
Delete: NoCascade
Merge: NoCascade
Reparent: NoCascade
RollupView: NoCascade
Share: NoCascade
Unshare: NoCascade

lk_solutionbase_createdonbehalfby

One-To-Many Relationship: systemuser lk_solutionbase_createdonbehalfby

Property Value
ReferencedEntity systemuser
ReferencedAttribute systemuserid
ReferencingAttribute createdonbehalfby
ReferencingEntityNavigationPropertyName createdonbehalfby
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: NoCascade
Delete: NoCascade
Merge: NoCascade
Reparent: NoCascade
RollupView: NoCascade
Share: NoCascade
Unshare: NoCascade

lk_solutionbase_modifiedonbehalfby

One-To-Many Relationship: systemuser lk_solutionbase_modifiedonbehalfby

Property Value
ReferencedEntity systemuser
ReferencedAttribute systemuserid
ReferencingAttribute modifiedonbehalfby
ReferencingEntityNavigationPropertyName modifiedonbehalfby
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: NoCascade
Delete: NoCascade
Merge: NoCascade
Reparent: NoCascade
RollupView: NoCascade
Share: NoCascade
Unshare: NoCascade

organization_solution

One-To-Many Relationship: organization organization_solution

Property Value
ReferencedEntity organization
ReferencedAttribute organizationid
ReferencingAttribute organizationid
ReferencingEntityNavigationPropertyName organizationid
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: NoCascade
Delete: NoCascade
Merge: NoCascade
Reparent: NoCascade
RollupView: NoCascade
Share: NoCascade
Unshare: NoCascade

publisher_solution

One-To-Many Relationship: publisher publisher_solution

Property Value
ReferencedEntity publisher
ReferencedAttribute publisherid
ReferencingAttribute publisherid
ReferencingEntityNavigationPropertyName publisherid
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: Cascade
Delete: Restrict
Merge: NoCascade
Reparent: Cascade
RollupView: NoCascade
Share: Cascade
Unshare: Cascade

solution_configuration_webresource

One-To-Many Relationship: webresource solution_configuration_webresource

Property Value
ReferencedEntity webresource
ReferencedAttribute webresourceid
ReferencingAttribute configurationpageid
ReferencingEntityNavigationPropertyName configurationpageid
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: NoCascade
Delete: RemoveLink
Merge: NoCascade
Reparent: NoCascade
RollupView: NoCascade
Share: NoCascade
Unshare: NoCascade

solution_parent_solution

One-To-Many Relationship: solution solution_parent_solution

Property Value
ReferencedEntity solution
ReferencedAttribute solutionid
ReferencingAttribute parentsolutionid
ReferencingEntityNavigationPropertyName parentsolutionid
IsHierarchical
CascadeConfiguration Archive: NoCascade
Assign: Cascade
Delete: Restrict
Merge: NoCascade
Reparent: Cascade
RollupView: NoCascade
Share: Cascade
Unshare: Cascade

One-to-Many relationships

These relationships are one-to-many. Listed by SchemaName.

FileAttachment_Solution

Many-To-One Relationship: fileattachment FileAttachment_Solution

Property Value
ReferencingEntity fileattachment
ReferencingAttribute objectid
ReferencedEntityNavigationPropertyName regardingobjectid_fileattachment_solution
IsCustomizable True
AssociatedMenuConfiguration AvailableOffline: True
Behavior: DoNotDisplay
Group: Details
Label:
MenuId: null
Order:
QueryApi: null
ViewId: 00000000-0000-0000-0000-000000000000

FK_CanvasApp_Solution

Many-To-One Relationship: canvasapp FK_CanvasApp_Solution

Property Value
ReferencingEntity canvasapp
ReferencingAttribute solutionid
ReferencedEntityNavigationPropertyName FK_CanvasApp_Solution
IsCustomizable False
AssociatedMenuConfiguration AvailableOffline: True
Behavior: DoNotDisplay
Group: Details
Label:
MenuId: null
Order:
QueryApi: null
ViewId: 00000000-0000-0000-0000-000000000000

solution_fieldpermission

Many-To-One Relationship: fieldpermission solution_fieldpermission

Property Value
ReferencingEntity fieldpermission
ReferencingAttribute solutionid
ReferencedEntityNavigationPropertyName solution_fieldpermission
IsCustomizable False
AssociatedMenuConfiguration AvailableOffline: True
Behavior: DoNotDisplay
Group: Details
Label:
MenuId: null
Order:
QueryApi: null
ViewId: 00000000-0000-0000-0000-000000000000

solution_fieldsecurityprofile

Many-To-One Relationship: fieldsecurityprofile solution_fieldsecurityprofile

Property Value
ReferencingEntity fieldsecurityprofile
ReferencingAttribute solutionid
ReferencedEntityNavigationPropertyName solution_fieldsecurityprofile
IsCustomizable False
AssociatedMenuConfiguration AvailableOffline: True
Behavior: DoNotDisplay
Group: Details
Label:
MenuId: null
Order:
QueryApi: null
ViewId: 00000000-0000-0000-0000-000000000000

solution_parent_solution

Many-To-One Relationship: solution solution_parent_solution

Property Value
ReferencingEntity solution
ReferencingAttribute parentsolutionid
ReferencedEntityNavigationPropertyName solution_parent_solution
IsCustomizable False
AssociatedMenuConfiguration AvailableOffline: True
Behavior: DoNotDisplay
Group: Details
Label:
MenuId: null
Order:
QueryApi: null
ViewId: 00000000-0000-0000-0000-000000000000

solution_privilege

Many-To-One Relationship: privilege solution_privilege

Property Value
ReferencingEntity privilege
ReferencingAttribute solutionid
ReferencedEntityNavigationPropertyName solution_privilege
IsCustomizable False
AssociatedMenuConfiguration AvailableOffline: True
Behavior: DoNotDisplay
Group: Details
Label:
MenuId: null
Order:
QueryApi: null
ViewId: 00000000-0000-0000-0000-000000000000

solution_role

Many-To-One Relationship: role solution_role

Property Value
ReferencingEntity role
ReferencingAttribute solutionid
ReferencedEntityNavigationPropertyName solution_role
IsCustomizable False
AssociatedMenuConfiguration AvailableOffline: True
Behavior: DoNotDisplay
Group: Details
Label:
MenuId: null
Order:
QueryApi: null
ViewId: 00000000-0000-0000-0000-000000000000

solution_roleprivileges

Many-To-One Relationship: roleprivileges solution_roleprivileges

Property Value
ReferencingEntity roleprivileges
ReferencingAttribute solutionid
ReferencedEntityNavigationPropertyName solution_roleprivileges
IsCustomizable False
AssociatedMenuConfiguration AvailableOffline: True
Behavior: DoNotDisplay
Group: Details
Label:
MenuId: null
Order:
QueryApi: null
ViewId: 00000000-0000-0000-0000-000000000000

solution_solutioncomponent

Many-To-One Relationship: solutioncomponent solution_solutioncomponent

Property Value
ReferencingEntity solutioncomponent
ReferencingAttribute solutionid
ReferencedEntityNavigationPropertyName solution_solutioncomponent
IsCustomizable False
AssociatedMenuConfiguration AvailableOffline: True
Behavior: DoNotDisplay
Group: Details
Label:
MenuId: null
Order:
QueryApi: null
ViewId: 00000000-0000-0000-0000-000000000000

Solution_SyncErrors

Many-To-One Relationship: syncerror Solution_SyncErrors

Property Value
ReferencingEntity syncerror
ReferencingAttribute regardingobjectid
ReferencedEntityNavigationPropertyName Solution_SyncErrors
IsCustomizable True
AssociatedMenuConfiguration AvailableOffline: True
Behavior: DoNotDisplay
Group: Details
Label:
MenuId: null
Order:
QueryApi: null
ViewId: 00000000-0000-0000-0000-000000000000

user_settings_preferred_solution

Many-To-One Relationship: usersettings user_settings_preferred_solution

Property Value
ReferencingEntity usersettings
ReferencingAttribute preferredsolution
ReferencedEntityNavigationPropertyName user_settings_preferred_solution
IsCustomizable True
AssociatedMenuConfiguration AvailableOffline: True
Behavior: DoNotDisplay
Group: Details
Label:
MenuId: null
Order: 10000
QueryApi: null
ViewId: 00000000-0000-0000-0000-000000000000

Many-to-Many relationships

These relationships are many-to-many. Listed by SchemaName.

package_solution

See package package_solution Many-To-Many Relationship

Property Value
IntersectEntityName package_solution
IsCustomizable False
SchemaName package_solution
IntersectAttribute solutionid
NavigationPropertyName package_solution
AssociatedMenuConfiguration AvailableOffline: True
Behavior: DoNotDisplay
Group: Details
Label:
MenuId: null
Order:
QueryApi: null
ViewId: 00000000-0000-0000-0000-000000000000

See also

Dataverse table/entity reference
Dataverse Web API Reference
solution