Table – UserPortals

Purpose

Determines which portal the user has access to when they enter the workspace.

Definition

CREATE TABLE [dbo].[UserPortals](
	[UserGUID] [UNIQUEIDENTIFIER] NOT NULL,
	[PortalFormGUID] [UNIQUEIDENTIFIER] NOT NULL,
	[InstanceGUID] [UNIQUEIDENTIFIER] NOT NULL,
 CONSTRAINT [PK_UserPortals_1] PRIMARY KEY CLUSTERED 
(
	[UserGUID] ASC,
	[PortalFormGUID] ASC
)WITH (STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]

Column Definitions

UserGUID is the InstanceGUID of the user’s Instance record

PortalFormGUID is the InstanceGUID of a Portal Form Definition that the user will use as their home page when they enter the workspace.

InstanceGUID is the InstanceGUID of a record that defines the highest point in the hierarchy that the user can see through their portal.

Key Functionality

Has an optional trigger to transfer changes to other data storage through InstanceChanges.

Updated on November 24, 2022

Was this article helpful?

Related Articles

Need Support?
Can’t find the answer you’re looking for? Don’t worry we’re here to help!
Contact Support

Leave a Comment