Hi,
how can we update the Column name which is displayed in Custom view created using Stored procedure?
Regards,
sharath
‎Apr 10, 2023 05:27 AM
Good afternoon Sharath, I hope you're keeping well?
I'd refer to the ComplianceSavedSearch table.
This is discussed in detail here, or in the schema guide:
I believe you'd want to amend either searchGridLayout or searchMapping, but would encourage you to take a backup of your FNMSCompliance database before making any changes to saved Reports.
‎Apr 11, 2023 08:19 AM
Thank you, the stored procedure behind the view doesn't give information about how to rename the column name in custom report. Good news is, i was able to figure it out.
At the end of stored procedure, need to execute the stored procedure: ComplianceTranslationPutByResourceStringCultureTypeResourceValue
which will help to rename the Column name
EXEC dbo.ComplianceTranslationPutByResourceStringCultureTypeResourceValue N'View.ColumnName', N'en-US', N'New_Name'
EXEC ComplianceCustomViewColumnRegister
@TenantID=1,
@ColumnName = 'ViewName.View.ColumnName',
@ColumnNameResourceName = 'ViewName.View.ColumnName',
@SelectName = 'ViewName.View.ColumnName',
@WhereClause = 'ViewName.View.ColumnName',
@FilterGroupType = 1,
@DefaultFilterType = 1,
@ComplianceSearchType = 'Report Name',
@SelectByDefault = 1
‎Apr 12, 2023 12:43 AM