Summary

This article documents the stored procedure used to remove custom properties from the column chooser

Synopsis

Since FNMS 2015 R2 SP4 custom properties are also shown in the column chooser. After removing the property, by using stored procedure "RemovePropertyFromWebUI", the webUI (custom) property still exists in the column chooser.

Discussion

Running the following stored procedure will remove all traces of the custom property from the database and will remove the property from the column chooser:

EXEC dbo.RemovePropertyFromWebUI

        @TargetTypeID = TargetTypeID,

        @Name = 'My-Unique-Name',

        @DeleteFromDB = 1

If the '@DeleteFromDB = 1' is not included, the property will still appear in the column chooser