Using custom columns and hiding every column will leave the user with no way to make further adjustments

Problem

Using custom columns and hiding every column leaves the user with no way to make further adjustments - as all columns are hidden, there is nowhere to right-click to open the context menu to disable custom columns or open the column manager.

Solution

Work-around is to remove the custom column information from the SY_UserProfile table for the affected user and grid.

e.g.: The following script removes the custom column information for the Regions grid on the Inventory Maintenance form for the user Admin

^{DELETE FROM SY_UserProfile WHERE IDKey = 'CustomXML' AND Section = 'JiwaFinancials.Jiwa.JiwaInventoryUI.InventoryMaintenanceForm.grdRegions.Default' AND UserID = (SELECT StaffID FROM HR_Staff WHERE Username = 'Admin')}

The issue has been logged for correction on DEV-6834 post 7.02.00

Related articles