Q207942: Custom view restrict results

This article will provide a fix when the custom view restrict results.

For example, application has a value in the classification field but when Version field is added to a custom view the value in the classification field for this app is not populated in the view.

Please run the script below against the RayManagesoft DB:

EXEC ComplianceCustomViewColumnRegister @ComplianceSearchTypeColumnID = 252, @ColumnName = 'SoftwareTitle.ApplicationVersion', @ColumnNameResourceName = 'ComplianceSearchTypeColumn.ApplicationVersion', @FromTable = 'LEFT OUTER JOIN SoftwareTitleVersion ON SoftwareTitle.SoftwareTitleVersionID = SoftwareTitleVersion.SoftwareTitleVersionID', @SelectName = 'SoftwareTitleVersion.VersionName', @WhereClause = 'SoftwareTitleVersion.VersionName', @FilterGroupType = 1, @DefaultFilterType = 1, @ComplianceSearchTypeID = 6

EXEC ComplianceCustomViewColumnRegister @ComplianceSearchTypeColumnID = 253, @ColumnName = 'SoftwareTitle.Publisher', @ColumnNameResourceName = 'ComplianceSearchTypeColumn.Publisher', @FromTable = 'INNER JOIN SoftwareTitleProduct ON SoftwareTitle.SoftwareTitleProductID = SoftwareTitleProduct.SoftwareTitleProductID LEFT OUTER JOIN SoftwareTitlePublisher ON SoftwareTitleProduct.SoftwareTitlePublisherID = SoftwareTitlePublisher.SoftwareTitlePublisherID', @SelectName = 'SoftwareTitlePublisher.PublisherName', @WhereClause = 'SoftwareTitlePublisher.PublisherName', @FilterGroupType = 1, @DefaultFilterType = 1, @ComplianceSearchTypeID = 6

UPDATE dbo.ComplianceSavedSearch
SET SearchSQL = NULL
WHERE SearchXML IS NOT NULL
GO