Find the security keyword on a given Document Type

[Denis_Hands]

We recently migrated a form and Document Type made many moons ago (before us) into our LIVE environment, we have created Unity Form submissions into the Document Type successfully however no one can see any of them without using the Manager account.

Is there an easy way to tell which Keyword assigned to the form or Document Type is the security keyword that is locking down the Document Type?

It is very long form and we don't want to necessarily unbuild things to rectify this.

[George_Sialmas]

@Denis Hands Do you know if the Unity Form template is locked based on the Security Option of that template? You can find the Security option in the template properties.

[George_Sialmas]

@Denis Hands I don't know how many User Groups/Users your OnBase environment has, however the below sql query returns a list of User Groups/User Accounts in which a security keyword is configured. From there you can simply get the Keyword Type Name and in OnBase Config | Keyword | Keyword Types | <select Keyword Type> | select Document Types - from here you can see which Document Types a security keyword is assigned to.

SELECT
'User Group' AS 'level', ug.usergroupname AS 'name', ktt.keytype AS 'keytypename',
IIF(ugsk.seckeywordflag & 1 = 0, 'EQUAL TO', 'NOT EQUAL TO') AS 'evaluator',
ugsk.keyvaluechar AS 'value'
FROM hsi.usergroupseckeys ugsk
INNER JOIN hsi.usergroup ug ON ugsk.usergroupnum = ug.usergroupnum
INNER JOIN hsi.keytypetable ktt ON ugsk.keytypenum = ktt.keytypenum
UNION ALL
SELECT
'User Account', ua.username, ktt.keytype,
IIF(uask.seckeywordflag & 1 = 0, 'EQUAL TO', 'NOT EQUAL TO'),
uask.keyvaluechar
FROM hsi.useraccountseckeys uask
INNER JOIN hsi.useraccount ua ON uask.usernum = ua.usernum
INNER JOIN hsi.keytypetable ktt ON uask.keytypenum = ktt.keytypenum

Good luck,

GS