Set values for all fields (Query)

When using ACLs, you need to set the fields as 'Editable when locked'. This is a setting on the advanced tab. You can do this field-by-field, but we also have a query to do it for a given template:

You will need the template ID and your DB Name. When in doubt, please contact our support.

UPDATE [YOURDB].[dbo].[ScTemplatePart] SET EditableWhenLocked=1 where TemplateTabId IN (SELECT Id FROM [YOURDB].[dbo].[ScTemplateTab] where TemplateId=8)