Table – UserApps

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.

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