MOR-PROC-xxx Version 2 Last Review Date: August, 2024
Database Queries
1. Introduction
This doc will explain how to interact with the database outside of the solution for debuggin purposes.
2.
2.1.
2.2. Database 'Views'
Database Views may require a user context to generate data successfully. This context is provided within the solution, but when attempting to use a View in SSMS, this context is not present by default, necessitating the need to add a context above the query.
The example below demontrates the context variables that may be required. In some cases, only the 'UserId' context will be required.
EXEC sp_set_session_context @key=N'Secured', @value=1;
EXEC sp_set_session_context @key=N'AuditEnabled', @value=1;
EXEC sp_set_session_context @key=N'UserId', @value=1;
EXEC sp_set_session_context @key=N'UserTenantId', @value=1;
EXEC sp_set_session_context @key=N'ConsumerKey', @value=NULL;
SELECT TOP (1000) [Comment_ID]
,[User_ID]
,[CommentType]
,[CommentTypeName]
,[CreatedAt]
,[MentionerTimeZone]
,[MentionerDisplayName]
,[MentionerParentType]
,[MentionerParentName]
,[MentionerParent_ID]
,[MentionerRoleNames]
,[CommentText]
,[TaggedUserIds]
,[TaggedUserDisplayNames]
,[EntityType]
,[EntityId]
,[EntityNumber]
,[EntityDescription]
,[AcknowledgedByUserIds]
,[AcknowledgedByUserDisplayNames]
,[NumberOfReplies]
,[TaggedUserCount]
,[AcknowledgementCount]
,[WorkOrder_ID]
,[Asset_ID]
,[Invoice_ID]
,[WorkRequest_ID]
,[UserProfile_ID]
,[Quote_ID]
,[Provider_ID]
,[Contract_ID]
,[Site_ID]
,[IsArchived]
,[AcknowledgementPercent]
FROM [dbo].[vUserTaggingActivityView]
WHERE USER_ID = 4