In Rock v3, the "Unknown" Marital Status was removed. However, we’ve found that some Rock environments still have a new “Unknown” value—likely created manually or during a system migration.
To prevent confusion, we recommend that Rock Administrators remove any remaining “Unknown” Marital Status values. While we considered removing it automatically in a future update, doing so without permission would be risky and potentially disruptive.
If your system still contains this value, you can run the following SQL script. It will reset all individuals marked as "Unknown" back to NULL (no value), then delete the “Unknown” Defined Value:
DECLARE @MaritalStatusDefinedTypeId int = ( SELECT TOP 1 [Id] FROM [DefinedType] WHERE [Guid] = 'B4B92C3F-A935-40E1-A00B-BA484EAD613B' )
DECLARE @UnknownMaritalStatusId int = ( SELECT TOP 1 [Id] FROM [DefinedValue] WHERE [Value] = 'Unknown' AND [DefinedTypeId] = @MaritalStatusDefinedTypeId )
IF @UnknownMaritalStatusId IS NOT NULL
BEGIN
UPDATE [Person]
SET [MaritalStatusValueId] = NULL
WHERE [MaritalStatusValueId] = @UnknownMaritalStatusId
DELETE FROM [DefinedValue]
WHERE [Id] = @UnknownMaritalStatusId
END