Solution table/entity reference
Note
Unsure about table vs. entity? See Developers: Understand terminology in Microsoft Dataverse.
A solution which contains CRM customizations.
Messages
Message | Web API Operation | SDK class or method |
---|---|---|
CloneAsPatch | CloneAsPatch | CloneAsPatchRequest |
CloneAsSolution | CloneAsSolution | CloneAsSolutionRequest |
Create | POST /solutions See Create |
CreateRequest or Create |
Delete | DELETE /solutions(solutionid) See Delete |
DeleteRequest or Delete |
DeleteAndPromote | DeleteAndPromote | DeleteAndPromoteRequest |
Retrieve | GET /solutions(solutionid) See Retrieve |
RetrieveRequest or Retrieve |
RetrieveMultiple | GET /solutions See Query Data |
RetrieveMultipleRequest or RetrieveMultiple |
Update | PATCH /solutions(solutionid) See Update |
UpdateRequest or Update |
Properties
Property | Value |
---|---|
CollectionSchemaName | Solutions |
DisplayCollectionName | Solutions |
DisplayName | Solution |
EntitySetName | solutions |
IsBPFEntity | False |
LogicalCollectionName | solutions |
LogicalName | solution |
OwnershipType | OrganizationOwned |
PrimaryIdAttribute | solutionid |
PrimaryNameAttribute | friendlyname |
SchemaName | Solution |
Writable columns/attributes
These columns/attributes return true for either IsValidForCreate or IsValidForUpdate (usually both). Listed by SchemaName.
- ConfigurationPageId
- Description
- FriendlyName
- PublisherId
- SolutionId
- SolutionPackageVersion
- SolutionType
- TemplateSuffix
- Thumbprint
- UniqueName
- Version
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 |
Targets | webresource |
Type | Lookup |
Description
Property | Value |
---|---|
Description | Description of the solution. |
DisplayName | Description |
FormatName | TextArea |
IsLocalizable | True |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | description |
MaxLength | 2000 |
RequiredLevel | None |
Type | String |
FriendlyName
Property | Value |
---|---|
Description | User display name for the solution. |
DisplayName | Display Name |
FormatName | Text |
IsLocalizable | True |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | friendlyname |
MaxLength | 256 |
RequiredLevel | SystemRequired |
Type | String |
PublisherId
Property | Value |
---|---|
Description | Unique identifier of the publisher. |
DisplayName | Publisher |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | publisherid |
RequiredLevel | SystemRequired |
Targets | publisher |
Type | Lookup |
SolutionId
Property | Value |
---|---|
Description | Unique identifier of the solution. |
DisplayName | Solution Identifier |
IsValidForForm | False |
IsValidForRead | True |
IsValidForUpdate | False |
LogicalName | solutionid |
RequiredLevel | SystemRequired |
Type | Uniqueidentifier |
SolutionPackageVersion
Property | Value |
---|---|
Description | Solution package source organization version |
DisplayName | Solution Package Version |
FormatName | VersionNumber |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | solutionpackageversion |
MaxLength | 256 |
RequiredLevel | None |
Type | String |
SolutionType
Property | Value |
---|---|
Description | Solution Type |
DisplayName | Solution Type |
IsValidForForm | False |
IsValidForRead | True |
IsValidForUpdate | False |
LogicalName | solutiontype |
RequiredLevel | None |
Type | Picklist |
SolutionType Choices/Options
Value | Label | Description |
---|---|---|
0 | None | |
1 | Snapshot | |
2 | Internal |
TemplateSuffix
Added by: Solutions Framework Metadata Solution
Property | Value |
---|---|
Description | The template suffix of this solution |
DisplayName | Suffix |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | True |
IsValidForRead | True |
IsValidForUpdate | False |
LogicalName | templatesuffix |
MaxLength | 65 |
RequiredLevel | None |
Type | String |
Thumbprint
Added by: Solutions Framework Metadata Solution
Property | Value |
---|---|
Description | thumbprint of the solution signature |
DisplayName | Thumbprint |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | True |
IsValidForRead | False |
IsValidForUpdate | False |
LogicalName | thumbprint |
MaxLength | 65 |
RequiredLevel | None |
Type | String |
UniqueName
Property | Value |
---|---|
Description | The unique name of this solution |
DisplayName | Name |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | True |
IsValidForRead | True |
IsValidForUpdate | False |
LogicalName | uniquename |
MaxLength | 65 |
RequiredLevel | SystemRequired |
Type | String |
Version
Property | Value |
---|---|
Description | Solution version, used to identify a solution for upgrades and hotfixes. |
DisplayName | Version |
FormatName | VersionNumber |
IsLocalizable | False |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | version |
MaxLength | 256 |
RequiredLevel | SystemRequired |
Type | String |
Read-only columns/attributes
These columns/attributes return false for both IsValidForCreate or IsValidForUpdate. Listed by SchemaName.
- ConfigurationPageIdName
- CreatedBy
- CreatedByName
- CreatedOn
- CreatedOnBehalfBy
- CreatedOnBehalfByName
- CreatedOnBehalfByYomiName
- FileId
- InstalledOn
- IsApiManaged
- IsInternal
- IsManaged
- IsVisible
- ModifiedBy
- ModifiedByName
- ModifiedOn
- ModifiedOnBehalfBy
- ModifiedOnBehalfByName
- ModifiedOnBehalfByYomiName
- OrganizationId
- OrganizationIdName
- ParentSolutionId
- ParentSolutionIdName
- PinpointAssetId
- PinpointPublisherId
- PinpointSolutionDefaultLocale
- PinpointSolutionId
- PublisherIdName
- PublisherIdOptionValuePrefix
- PublisherIdPrefix
- UpdatedOn
- UpgradeInfo
- VersionNumber
ConfigurationPageIdName
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | configurationpageidname |
MaxLength | 256 |
RequiredLevel | None |
Type | String |
CreatedBy
Property | Value |
---|---|
Description | Unique identifier of the user who created the solution. |
DisplayName | Created By |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | createdby |
RequiredLevel | None |
Targets | systemuser |
Type | Lookup |
CreatedByName
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | createdbyname |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
CreatedOn
Property | Value |
---|---|
DateTimeBehavior | UserLocal |
Description | Date and time when the solution was created. |
DisplayName | Created On |
Format | DateAndTime |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | createdon |
RequiredLevel | None |
Type | DateTime |
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 |
Targets | systemuser |
Type | Lookup |
CreatedOnBehalfByName
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | createdonbehalfbyname |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
CreatedOnBehalfByYomiName
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | createdonbehalfbyyominame |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
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 |
InstalledOn
Property | Value |
---|---|
DateTimeBehavior | UserLocal |
Description | Date and time when the solution was installed/upgraded. |
DisplayName | Installed On |
Format | DateOnly |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | installedon |
RequiredLevel | None |
Type | DateTime |
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 |
IsApiManaged Choices/Options
Value | Label | Description |
---|---|---|
1 | Yes | |
0 | No |
DefaultValue: 0
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 |
IsInternal Choices/Options
Value | Label | Description |
---|---|---|
1 | Yes | |
0 | No |
DefaultValue: 0
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 |
IsManaged Choices/Options
Value | Label | Description |
---|---|---|
1 | Managed | |
0 | Unmanaged |
DefaultValue: 0
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 |
IsVisible Choices/Options
Value | Label | Description |
---|---|---|
1 | Yes | |
0 | No |
DefaultValue: 1
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 |
Targets | systemuser |
Type | Lookup |
ModifiedByName
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | modifiedbyname |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
ModifiedOn
Property | Value |
---|---|
DateTimeBehavior | UserLocal |
Description | Date and time when the solution was last modified. |
DisplayName | Modified On |
Format | DateAndTime |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | modifiedon |
RequiredLevel | None |
Type | DateTime |
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 |
Targets | systemuser |
Type | Lookup |
ModifiedOnBehalfByName
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | modifiedonbehalfbyname |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
ModifiedOnBehalfByYomiName
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | modifiedonbehalfbyyominame |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
OrganizationId
Property | Value |
---|---|
Description | Unique identifier of the organization associated with the solution. |
DisplayName | Organization |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | organizationid |
RequiredLevel | SystemRequired |
Targets | organization |
Type | Lookup |
OrganizationIdName
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | organizationidname |
MaxLength | 100 |
RequiredLevel | SystemRequired |
Type | String |
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 |
Targets | solution |
Type | Lookup |
ParentSolutionIdName
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | parentsolutionidname |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
PinpointAssetId
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | pinpointassetid |
MaxLength | 255 |
RequiredLevel | None |
Type | String |
PinpointPublisherId
Property | Value |
---|---|
Description | Identifier of the publisher of this solution in Microsoft Pinpoint. |
DisplayName | |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | pinpointpublisherid |
MaxValue | 9223372036854775807 |
MinValue | -9223372036854775808 |
RequiredLevel | None |
Type | BigInt |
PinpointSolutionDefaultLocale
Property | Value |
---|---|
Description | Default locale of the solution in Microsoft Pinpoint. |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | pinpointsolutiondefaultlocale |
MaxLength | 16 |
RequiredLevel | None |
Type | String |
PinpointSolutionId
Property | Value |
---|---|
Description | Identifier of the solution in Microsoft Pinpoint. |
DisplayName | |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | pinpointsolutionid |
MaxValue | 9223372036854775807 |
MinValue | -9223372036854775808 |
RequiredLevel | None |
Type | BigInt |
PublisherIdName
Property | Value |
---|---|
Description | name of the publisher. |
DisplayName | Publisher |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | publisheridname |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
PublisherIdOptionValuePrefix
Property | Value |
---|---|
Description | |
DisplayName | |
Format | None |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | publisheridoptionvalueprefix |
MaxValue | 2147483647 |
MinValue | -2147483648 |
RequiredLevel | None |
Type | Integer |
PublisherIdPrefix
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | publisheridprefix |
MaxLength | 256 |
RequiredLevel | None |
Type | String |
UpdatedOn
Property | Value |
---|---|
DateTimeBehavior | UserLocal |
Description | Date and time when the solution was updated. |
DisplayName | Updated On |
Format | DateAndTime |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | updatedon |
RequiredLevel | None |
Type | DateTime |
UpgradeInfo
Added by: Solutions Framework Metadata Solution
Property | Value |
---|---|
Description | Contains component info for the solution upgrade operation |
DisplayName | |
Format | TextArea |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | upgradeinfo |
MaxLength | 1073741823 |
RequiredLevel | None |
Type | Memo |
VersionNumber
Property | Value |
---|---|
Description | |
DisplayName | |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | versionnumber |
MaxValue | 9223372036854775807 |
MinValue | -9223372036854775808 |
RequiredLevel | None |
Type | BigInt |
One-To-Many Relationships
Listed by SchemaName.
- solution_solutioncomponent
- solution_parent_solution
- Solution_SyncErrors
- FK_CanvasApp_Solution
- solution_fieldpermission
- solution_fieldsecurityprofile
- solution_privilege
- solution_role
- user_settings_preferred_solution
solution_solutioncomponent
Same as the solution_solutioncomponent many-to-one relationship for the solutioncomponent table/entity.
Property | Value |
---|---|
ReferencingEntity | solutioncomponent |
ReferencingAttribute | solutionid |
IsHierarchical | False |
IsCustomizable | False |
ReferencedEntityNavigationPropertyName | solution_solutioncomponent |
AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
CascadeConfiguration | Assign: Cascade Delete: Cascade Merge: NoCascade Reparent: Cascade Share: Cascade Unshare: Cascade |
solution_parent_solution
Same as the solution_parent_solution many-to-one relationship for the solution table/entity.
Property | Value |
---|---|
ReferencingEntity | solution |
ReferencingAttribute | parentsolutionid |
IsHierarchical | False |
IsCustomizable | False |
ReferencedEntityNavigationPropertyName | solution_parent_solution |
AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
CascadeConfiguration | Assign: Cascade Delete: Restrict Merge: NoCascade Reparent: Cascade Share: Cascade Unshare: Cascade |
Solution_SyncErrors
Same as the Solution_SyncErrors many-to-one relationship for the syncerror table/entity.
Property | Value |
---|---|
ReferencingEntity | syncerror |
ReferencingAttribute | regardingobjectid |
IsHierarchical | False |
IsCustomizable | True |
ReferencedEntityNavigationPropertyName | Solution_SyncErrors |
AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
CascadeConfiguration | Assign: Cascade Delete: Cascade Merge: Cascade Reparent: Cascade Share: Cascade Unshare: Cascade |
FK_CanvasApp_Solution
Same as the FK_CanvasApp_Solution many-to-one relationship for the canvasapp table/entity.
Property | Value |
---|---|
ReferencingEntity | canvasapp |
ReferencingAttribute | solutionid |
IsHierarchical | False |
IsCustomizable | False |
ReferencedEntityNavigationPropertyName | FK_CanvasApp_Solution |
AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
CascadeConfiguration | Assign: NoCascade Delete: NoCascade Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
solution_fieldpermission
Same as the solution_fieldpermission many-to-one relationship for the fieldpermission table/entity.
Property | Value |
---|---|
ReferencingEntity | fieldpermission |
ReferencingAttribute | solutionid |
IsHierarchical | False |
IsCustomizable | False |
ReferencedEntityNavigationPropertyName | solution_fieldpermission |
AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
CascadeConfiguration | Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
solution_fieldsecurityprofile
Same as the solution_fieldsecurityprofile many-to-one relationship for the fieldsecurityprofile table/entity.
Property | Value |
---|---|
ReferencingEntity | fieldsecurityprofile |
ReferencingAttribute | solutionid |
IsHierarchical | False |
IsCustomizable | False |
ReferencedEntityNavigationPropertyName | solution_fieldsecurityprofile |
AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
CascadeConfiguration | Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
solution_privilege
Same as the solution_privilege many-to-one relationship for the privilege table/entity.
Property | Value |
---|---|
ReferencingEntity | privilege |
ReferencingAttribute | solutionid |
IsHierarchical | False |
IsCustomizable | False |
ReferencedEntityNavigationPropertyName | solution_privilege |
AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
CascadeConfiguration | Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
solution_role
Same as the solution_role many-to-one relationship for the role table/entity.
Property | Value |
---|---|
ReferencingEntity | role |
ReferencingAttribute | solutionid |
IsHierarchical | False |
IsCustomizable | False |
ReferencedEntityNavigationPropertyName | solution_role |
AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
CascadeConfiguration | Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
user_settings_preferred_solution
Added by: Solutions Framework Metadata Solution
Same as the user_settings_preferred_solution many-to-one relationship for the usersettings table/entity.
Property | Value |
---|---|
ReferencingEntity | usersettings |
ReferencingAttribute | preferredsolution |
IsHierarchical | False |
IsCustomizable | True |
ReferencedEntityNavigationPropertyName | user_settings_preferred_solution |
AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: 10000 |
CascadeConfiguration | Assign: NoCascade Delete: RemoveLink Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
Many-To-One Relationships
Each Many-To-One relationship is defined by a corresponding One-To-Many relationship with the related table. Listed by SchemaName.
- lk_solution_createdby
- lk_solution_modifiedby
- solution_parent_solution
- solution_configuration_webresource
- lk_solutionbase_modifiedonbehalfby
- organization_solution
- lk_solutionbase_createdonbehalfby
- publisher_solution
lk_solution_createdby
See the lk_solution_createdby one-to-many relationship for the systemuser table/entity.
lk_solution_modifiedby
See the lk_solution_modifiedby one-to-many relationship for the systemuser table/entity.
solution_parent_solution
See the solution_parent_solution one-to-many relationship for the solution table/entity.
solution_configuration_webresource
See the solution_configuration_webresource one-to-many relationship for the webresource table/entity.
lk_solutionbase_modifiedonbehalfby
See the lk_solutionbase_modifiedonbehalfby one-to-many relationship for the systemuser table/entity.
organization_solution
See the organization_solution one-to-many relationship for the organization table/entity.
lk_solutionbase_createdonbehalfby
See the lk_solutionbase_createdonbehalfby one-to-many relationship for the systemuser table/entity.
publisher_solution
See the publisher_solution one-to-many relationship for the publisher table/entity.
Many-To-Many Relationships
Relationship details provided where the Solution table is the first table in the relationship. Listed by SchemaName.
package_solution
See the package_solution many-to-many relationship for the package table/entity.
See also
Dataverse table/entity reference
Web API Reference
solution EntityType
משוב
https://aka.ms/ContentUserFeedback.
בקרוב: במהלך 2024, נפתור בעיות GitHub כמנגנון המשוב לתוכן ונחליף אותו במערכת משוב חדשה. לקבלת מידע נוסף, ראה:שלח והצג משוב עבור