Column name in Custom report

[scsharath2]

Hi,

how can we update the Column name  which is displayed in Custom view created using Stored procedure?

Regards,
sharath 

[jevans]

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:

https://community.flexera.com/t5/FlexNet-Manager-Knowledge-Base/Retrieve-the-SQL-query-for-a-saved-view-or-custom-report/ta-p/240692

https://docs.flexera.com/FlexNetManagerSuite2022R2/EN/Schema/index.html#SysRef/schema/ComplianceSchema/Compliance.Logic.CoreTables/reference/ComplianceSavedSearch.html

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.

[scsharath2]

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