Skip to main content
Planview Customer Success Center

Unable to update the filter further once saved (CP 2010)

SYMPTOMS
When creating a new UDF in Production and applying a Filter change, we are unable to update the filter further once saved. The error is “The field is in use through Report Designer.”
We didn't complete the SQL Filter requirements before receiving this error. The field is now in place though the dropdown filter does not have the final criteria. What is the database table / field that houses this information so we can update it manually or is there a way to research further?
 
REASON
Errors like this usually happen if you have imported a report from somewhere else and the UDFs did not match between the two systems


RESOLUTION
You can remove rows from the ReportUDFColumn table that have the specific field name in them. Every field is locked by Report Designer by design because it can be used in multiple places in Changepoint and changing that value can cause data corruption