Purpose
Determines which applications the user has access to through the left-hand navigation panel on the user experience.
Application forms act as coarse gained entry points to a set of records through Childlist controls.
These records are typically created at the Workspace level for back-end users, or at the portal level for portal users.
The Childlists may also display any set of records from anywhere within the scope of visibility of the user.
Definition
CREATE TABLE [dbo].[UserApps](
[UserGUID] [UNIQUEIDENTIFIER] NOT NULL,
[AppGUID] [UNIQUEIDENTIFIER] NOT NULL,
CONSTRAINT [PK_UserApps] PRIMARY KEY CLUSTERED
(
[UserGUID] ASC,
[AppGUID] 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
AppGUID is the InstanceGUID of an Application Form Definition that the user has access to.
Key Functionality
Has an optional trigger to transfer changes to other data storage through InstanceChanges.