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 ως μηχανισμό ανάδρασης για το περιεχόμενο και θα το αντικαταστήσουμε με ένα νέο σύστημα ανάδρασης. Για περισσότερες πληροφορίες, ανατρέξτε στο θέμα:Υποβολή και προβολή σχολίων για