Cache not refeshed when Report Design changed

V5 Issue
1

Update Report in grid mode doesn’t clear column spec cache.

Example … if i have a Report used as a data source for a Custom Report Widget in grid mode (see # symbol before the name at the top) :

[#SettingTypeSelector:20,20]
>Setting Type|Screen
{REPORT SQL DETAILS:
	SELECT ButtonHeader, Name AS EntityScreenName, SortOrder
	FROM  EntityScreens
	WHERE (Name LIKE 'CFG%')
	ORDER BY SortOrder
	:F.ButtonHeader,F.EntityScreenName
}

So that works fine, but any changes to column names or order of columns will not take effect until SP is restarted.

A faster workaround is to change the report identifier at the top:
I appended the letter B in this example …

[#SettingTypeSelectorB:20,20]
>Screen Header|Screen Name
{REPORT SQL DETAILS:
SELECT ButtonHeader, Name AS EntityScreenName, SortOrder
FROM EntityScreens
WHERE (Name LIKE ‘CFG%’)
ORDER BY SortOrder
:F.ButtonHeader,F.EntityScreenName
}

but changing the report name/identifier also means you need to change any Setting Mappings in the Custom Report Widget to match the new name.

in this example, the 2 columns were mapped to Local Settings:

cfgSettingType=SettingTypeSelector.1
cfgSettingScreenName=SettingTypeSelector.2

so after updating the column names i would have to change the mappings to:

cfgSettingType=SettingTypeSelectorB.1
cfgSettingScreenName=SettingTypeSelectorB.2

==========

SP should update it’s internal report data when the design is updated.

2

Did you not try the refresh widget action?

3

Yes. In many cases my Custom Report Widgets are refreshed every time the user enters new filter criteria, and the list updates accordingly.

The problem is that the column header names sometimes remain “locked” to their previous values until a restart. A Refresh Cache action doesn’t fix it either.

It occurs within the Report Editor Preview also so it’s not related to automation or widgets.