Where is the information on Manage Filters saved?

Products

• CLARITY PPM FOR ITG
• CLARITY PPM FEDERAL
• Clarity PPM SaaS - Application
• Clarity PPM On Premise

Issue/Introduction

When saving a filter it is listed under the filter section. It can also be made as the default filter on the Manager Filters popup, but where are these filters stored in the database?

<Please see attached file for image>

Environment

Release: 451-101-15.2-Clarity-Creator User License
Component:

Resolution

The filter information is saved on the cmn_attribute_value_sets and cmn_attribute_values table.

• The cmn_attribute_value_sets table saves the information such as filter name and target object. 
• The cmn_attribute_values table saves the information such as attribute name and value.

The ATTRIBUTE_SET_ID on cmn_attribute_values table is related to ID on cmn_attribute_value_sets table.