Publishing State (mspp_publishingstate) 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_publishingstates
See Create
CreateRequest or
Create
CreateMultiple CreateMultiple CreateMultipleRequest
Delete DELETE /mspp_publishingstates(mspp_publishingstateid)
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_publishingstates(mspp_publishingstateid)
See Retrieve
RetrieveRequest or
Retrieve
RetrieveEntityChanges RetrieveEntityChangesRequest
RetrieveMultiple GET /mspp_publishingstates
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_publishingstates(mspp_publishingstateid)
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_publishingstates
DisplayCollectionName Publishing States
DisplayName Publishing State
EntitySetName mspp_publishingstates
IsBPFEntity False
LogicalCollectionName mspp_publishingstates
LogicalName mspp_publishingstate
OwnershipType OrganizationOwned
PrimaryIdAttribute mspp_publishingstateid
PrimaryNameAttribute mspp_name
SchemaName mspp_publishingstate

Writable columns/attributes

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

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_displayorder

Property Value
Description
DisplayName Display Order
Format None
IsValidForForm True
IsValidForRead True
LogicalName mspp_displayorder
MaxValue 2147483647
MinValue -2147483648
RequiredLevel ApplicationRequired
Type Integer

mspp_isdefault

Property Value
Description
DisplayName Is Default
IsValidForForm True
IsValidForRead True
LogicalName mspp_isdefault
RequiredLevel ApplicationRequired
Type Boolean

mspp_isdefault Choices/Options

Value Label Description
1 Yes
0 No

DefaultValue: 0

mspp_isvisible

Property Value
Description
DisplayName Select whether the publishing state is visible.
IsValidForForm True
IsValidForRead True
LogicalName mspp_isvisible
RequiredLevel ApplicationRequired
Type Boolean

mspp_isvisible Choices/Options

Value Label Description
1 Yes
0 No

DefaultValue: 0

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_name

Property Value
Description The name of the custom entity.
DisplayName Name
FormatName Text
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName mspp_name
MaxLength 100
RequiredLevel ApplicationRequired
Type String

mspp_publishingstateId

Property Value
Description Unique identifier for entity instances
DisplayName Publishing State
IsValidForForm False
IsValidForRead True
IsValidForUpdate False
LogicalName mspp_publishingstateid
RequiredLevel SystemRequired
Type Uniqueidentifier

mspp_websiteid

Property Value
Description Unique identifier for Website associated with Publishing State.
DisplayName Website
IsValidForForm True
IsValidForRead True
LogicalName mspp_websiteid
RequiredLevel ApplicationRequired
Targets mspp_website
Type Lookup

statecode

Property Value
Description Status of the Publishing State
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 Publishing State
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_frompublishingstate_statetransition

Same as the mspp_frompublishingstate_statetransition many-to-one relationship for the mspp_publishingstatetransitionrule table/entity.

Property Value
ReferencingEntity mspp_publishingstatetransitionrule
ReferencingAttribute mspp_fromstate_publishingstateid
IsHierarchical False
IsCustomizable False
ReferencedEntityNavigationPropertyName mspp_frompublishingstate_statetransition
AssociatedMenuConfiguration Behavior: UseCollectionName
Group: Details
Label:
Order: 10000
CascadeConfiguration Assign: NoCascade
Delete: NoCascade
Merge: NoCascade
Reparent: NoCascade
Share: NoCascade
Unshare: NoCascade

mspp_mspp_publishingstate_mspp_websitelanguage_PublishingState

Same as the mspp_mspp_publishingstate_mspp_websitelanguage_PublishingState many-to-one relationship for the mspp_websitelanguage table/entity.

Property Value
ReferencingEntity mspp_websitelanguage
ReferencingAttribute mspp_publishingstate
IsHierarchical False
IsCustomizable False
ReferencedEntityNavigationPropertyName mspp_mspp_publishingstate_mspp_websitelanguage_PublishingState
AssociatedMenuConfiguration Behavior: UseCollectionName
Group: Details
Label:
Order: 10000
CascadeConfiguration Assign: NoCascade
Delete: NoCascade
Merge: NoCascade
Reparent: NoCascade
Share: NoCascade
Unshare: NoCascade

mspp_publishingstate_webfile

Same as the mspp_publishingstate_webfile many-to-one relationship for the mspp_webfile table/entity.

Property Value
ReferencingEntity mspp_webfile
ReferencingAttribute mspp_publishingstateid
IsHierarchical False
IsCustomizable False
ReferencedEntityNavigationPropertyName mspp_publishingstate_webfile
AssociatedMenuConfiguration Behavior: DoNotDisplay
Group: Details
Label:
Order: 10000
CascadeConfiguration Assign: NoCascade
Delete: NoCascade
Merge: NoCascade
Reparent: NoCascade
Share: NoCascade
Unshare: NoCascade

Same as the mspp_publishingstate_weblink many-to-one relationship for the mspp_weblink table/entity.

Property Value
ReferencingEntity mspp_weblink
ReferencingAttribute mspp_publishingstateid
IsHierarchical False
IsCustomizable False
ReferencedEntityNavigationPropertyName mspp_publishingstate_weblink
AssociatedMenuConfiguration Behavior: UseCollectionName
Group: Details
Label:
Order: 10000
CascadeConfiguration Assign: NoCascade
Delete: NoCascade
Merge: NoCascade
Reparent: NoCascade
Share: NoCascade
Unshare: NoCascade

mspp_publishingstate_weblinkset

Same as the mspp_publishingstate_weblinkset many-to-one relationship for the mspp_weblinkset table/entity.

Property Value
ReferencingEntity mspp_weblinkset
ReferencingAttribute mspp_publishingstateid
IsHierarchical False
IsCustomizable False
ReferencedEntityNavigationPropertyName mspp_publishingstate_weblinkset
AssociatedMenuConfiguration Behavior: UseCollectionName
Group: Details
Label:
Order: 10000
CascadeConfiguration Assign: NoCascade
Delete: NoCascade
Merge: NoCascade
Reparent: NoCascade
Share: NoCascade
Unshare: NoCascade

mspp_publishingstate_webpage

Same as the mspp_publishingstate_webpage many-to-one relationship for the mspp_webpage table/entity.

Property Value
ReferencingEntity mspp_webpage
ReferencingAttribute mspp_publishingstateid
IsHierarchical False
IsCustomizable False
ReferencedEntityNavigationPropertyName mspp_publishingstate_webpage
AssociatedMenuConfiguration Behavior: UseCollectionName
Group: Details
Label:
Order: 10000
CascadeConfiguration Assign: NoCascade
Delete: NoCascade
Merge: NoCascade
Reparent: NoCascade
Share: NoCascade
Unshare: NoCascade

mspp_topublishingstate_statetransition

Same as the mspp_topublishingstate_statetransition many-to-one relationship for the mspp_publishingstatetransitionrule table/entity.

Property Value
ReferencingEntity mspp_publishingstatetransitionrule
ReferencingAttribute mspp_tostate_publishingstateid
IsHierarchical False
IsCustomizable False
ReferencedEntityNavigationPropertyName mspp_topublishingstate_statetransition
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_systemuser_mspp_publishingstate_createdby

Added by: System Solution Solution

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

mspp_systemuser_mspp_publishingstate_modifiedby

Added by: System Solution Solution

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

mspp_website_publishingstate

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

Many-To-Many Relationships

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

mspp_accesscontrolrule_publishingstate

See the mspp_accesscontrolrule_publishingstate many-to-many relationship for the mspp_webpageaccesscontrolrule table/entity.

See also

Dataverse table/entity reference
Web API Reference
mspp_publishingstate EntityType