How to Verify Out of Office UI Matches on the Database Backend
kbt134112
PRODUCTK2 blackpearl 4.7
BASED ONK2 blackpearl 4.7
This article was created in response to a support issue logged with K2. The content may include typographical errors and may be revised at any time without notice. This article is not considered official documentation for K2 software and is provided "as is" with no warranties.
LEGACY/ARCHIVED CONTENT
This article has been archived, and/or refers to legacy products, components or features. The content in this article is offered "as is" and will no longer be updated. Archived content is provided for reference purposes only. This content does not infer that the product, component or feature is supported, or that the product, component or feature will continue to function as described herein.
Issue
For out of office issues, a good first troubleshooting step is to verify that the configuration that is set up using the K2 management or worklist controls, is properly stored and reflected in the database. The following query pulls information from the tables that house the out of office configuration and presents it in a reader friendly manner for quick verification.Symptoms
N/ATroubleshooting Steps
Run the following query against the K2 database:
USE K2 Select 'OOF Setup FOR: [' + [A1].ActionerName + '] TO: [' + [A2].ActionerName + ']' as OOF, '[' + [A1].ActionerName + '] Status is: ' + CASE WHEN [A1].Status = 1 THEN '[OUT of Office]' ELSE '[IN Office]' END as Status From [Server].[Actioner] [A1] Join [Server].[ActionerShare] [AS] On [AS].ActionerID = [A1].[ID] Join [Server].[ActionerShareWorktype] [ASWT] On [ASWT].ActionerShareID = [AS].[ID] Join [Server].[Worktype] [WT] On [WT].[ID] = [ASWT].WorktypeID Join [Server].[WorktypeShare] [WTS] On [WTS].WorktypeID = [WT].[ID] Join [Server].[Actioner] [A2] On [A2].[ID] = [WTS].ActionerID order by OOF
This returns ouput in the following format for quick comparison/reading of the configured out of office settings:
OOF Status
OOF Setup FOR: [K2:DENALLIXAdministrator] TO: [K2:DENALLIXBOB] [K2:DENALLIXAdministrator] Status is: [IN Office]
OOF Setup FOR: [K2:DENALLIXJoe] TO: [K2:DENALLIXBOB] [K2:DENALLIXJoe] Status is: [OUT of Office]
OOF Setup FOR: [K2:DENALLIXJONNO] TO: [K2:DENALLIXAdministrator] [K2:DENALLIXJONNO] Status is: [OUT of Office]
OOF Setup FOR: [K2:DENALLIXJONNO] TO: [K2:DENALLIXCODI] [K2:DENALLIXJONNO] Status is: [OUT of Office]
