편집

Column Permission Profile (mspp_columnpermissionprofile) table/entity reference

  • 아티클

Note

Unsure about table vs. entity? See Developers: Understand terminology in Microsoft Dataverse.

Added by: Power Pages Apps Solution

Messages

Message Web API Operation SDK class or method
BulkRetain This message is to be executed only by Dataverse to trigger registered plug-ins and flows.
Create POST /mspp_columnpermissionprofiles
See Create		 CreateRequest or
Create
CreateMultiple CreateMultiple CreateMultipleRequest
Delete DELETE /mspp_columnpermissionprofiles(mspp_columnpermissionprofileid)
See Delete		 DeleteRequest or
Delete
PurgeRetainedContent This message is to be executed only by Dataverse to trigger registered plug-ins and flows.
Retain This message is to be executed only by Dataverse to trigger registered plug-ins and flows.
Retrieve GET /mspp_columnpermissionprofiles(mspp_columnpermissionprofileid)
See Retrieve		 RetrieveRequest or
Retrieve
RetrieveEntityChanges RetrieveEntityChangesRequest
RetrieveMultiple GET /mspp_columnpermissionprofiles
See Query Data		 RetrieveMultipleRequest or
RetrieveMultiple
RollbackRetain This message is to be executed only by Dataverse to trigger registered plug-ins and flows.
Update PATCH /mspp_columnpermissionprofiles(mspp_columnpermissionprofileid)
See Update		 UpdateRequest or
Update
UpdateMultiple UpdateMultiple UpdateMultipleRequest
ValidateRetentionConfig This message is to be executed only by Dataverse to trigger registered plug-ins and flows.

Properties

Property Value
CollectionSchemaName mspp_columnpermissionprofiles
DisplayCollectionName Column Permission Profiles
DisplayName Column Permission Profile
EntitySetName mspp_columnpermissionprofiles
IsBPFEntity False
LogicalCollectionName mspp_columnpermissionprofiles
LogicalName mspp_columnpermissionprofile
OwnershipType OrganizationOwned
PrimaryIdAttribute mspp_columnpermissionprofileid
PrimaryNameAttribute mspp_profilename
SchemaName mspp_columnpermissionprofile

Writable columns/attributes

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

mspp_allcolumnpermissions

Property Value
Description
DisplayName All Column Permissions
IsValidForForm True
IsValidForRead True
LogicalName mspp_allcolumnpermissions
RequiredLevel None
Type MultiSelectPicklist

mspp_allcolumnpermissions Choices/Options

Value Label Description
746610000 Create
746610001 Read
746610002 Update

mspp_columnpermissionprofileId

Property Value
Description Unique identifier for entity instances
DisplayName Column Permission Profile
IsValidForForm False
IsValidForRead True
IsValidForUpdate False
LogicalName mspp_columnpermissionprofileid
RequiredLevel SystemRequired
Type Uniqueidentifier

mspp_createdby

Property Value
Description Shows who created the record.
DisplayName Created By
IsValidForForm True
IsValidForRead True
LogicalName mspp_createdby
RequiredLevel None
Targets systemuser
Type Lookup

mspp_createdon

Property Value
DateTimeBehavior UserLocal
Description Shows the date and time when the record was created.
DisplayName Created On
Format DateAndTime
IsValidForForm True
IsValidForRead True
LogicalName mspp_createdon
RequiredLevel None
Type DateTime

mspp_modifiedby

Property Value
Description Shows who last updated the record.
DisplayName Modified By
IsValidForForm True
IsValidForRead True
LogicalName mspp_modifiedby
RequiredLevel None
Targets systemuser
Type Lookup

mspp_modifiedon

Property Value
DateTimeBehavior UserLocal
Description Shows the date and time when the record was modified.
DisplayName Modified On
Format DateAndTime
IsValidForForm True
IsValidForRead True
LogicalName mspp_modifiedon
RequiredLevel None
Type DateTime

mspp_profilename

Property Value
Description
DisplayName Profile Name
FormatName Text
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName mspp_profilename
MaxLength 400
RequiredLevel ApplicationRequired
Type String

mspp_tablename

Property Value
Description
DisplayName Table Name
FormatName Text
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName mspp_tablename
MaxLength 100
RequiredLevel ApplicationRequired
Type String

mspp_websiteid

Property Value
Description
DisplayName Website
IsValidForForm True
IsValidForRead True
LogicalName mspp_websiteid
RequiredLevel ApplicationRequired
Targets mspp_website
Type Lookup

statecode

Property Value
Description Status of the Column Permission Profile
DisplayName Status
IsValidForCreate False
IsValidForForm True
IsValidForRead True
LogicalName statecode
RequiredLevel SystemRequired
Type State

statecode Choices/Options

Value Label DefaultStatus InvariantName
0 Active 1 Active
1 Inactive 2 Inactive

statuscode

Property Value
Description Reason for the status of the Column Permission Profile
DisplayName Status Reason
IsValidForForm True
IsValidForRead True
LogicalName statuscode
RequiredLevel None
Type Status

statuscode Choices/Options

Value Label State
1 Active 0
2 Inactive 1

Read-only columns/attributes

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

mspp_createdbyName

Property Value
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName mspp_createdbyname
MaxLength 200
RequiredLevel None
Type String

mspp_createdbyYomiName

Property Value
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName mspp_createdbyyominame
MaxLength 200
RequiredLevel None
Type String

mspp_modifiedbyName

Property Value
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName mspp_modifiedbyname
MaxLength 200
RequiredLevel None
Type String

mspp_modifiedbyYomiName

Property Value
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName mspp_modifiedbyyominame
MaxLength 200
RequiredLevel None
Type String

mspp_websiteidName

Property Value
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName mspp_websiteidname
MaxLength 100
RequiredLevel None
Type String

One-To-Many Relationships

Listed by SchemaName.

mspp_columnpermission_columnpermissionprofile

Same as the mspp_columnpermission_columnpermissionprofile many-to-one relationship for the mspp_columnpermission table/entity.

Property Value
ReferencingEntity mspp_columnpermission
ReferencingAttribute mspp_columnpermissionprofileid
IsHierarchical False
IsCustomizable False
ReferencedEntityNavigationPropertyName mspp_columnpermission_columnpermissionprofile
AssociatedMenuConfiguration Behavior: UseCollectionName
Group: Details
Label:
Order: 10000
CascadeConfiguration Assign: NoCascade
Delete: NoCascade
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.

mspp_columnpermissionprofile_website

See the mspp_columnpermissionprofile_website one-to-many relationship for the mspp_website table/entity.

mspp_systemuser_mspp_columnpermissionprofile_createdby

Added by: System Solution Solution

See the mspp_systemuser_mspp_columnpermissionprofile_createdby one-to-many relationship for the systemuser table/entity.

mspp_systemuser_mspp_columnpermissionprofile_modifiedby

Added by: System Solution Solution

See the mspp_systemuser_mspp_columnpermissionprofile_modifiedby one-to-many relationship for the systemuser table/entity.

Many-To-Many Relationships

Relationship details provided where the mspp_columnpermissionprofile table is the first table in the relationship. Listed by SchemaName.

mspp_columnpermissionprofile_webrole

See the mspp_columnpermissionprofile_webrole many-to-many relationship for the mspp_webrole table/entity.

See also

Dataverse table/entity reference
Web API Reference
mspp_columnpermissionprofile EntityType