Where is the information on Manage Filters saved?

book

Article ID: 16751

calendar_today

Updated On:

Products

CLARITY PPM FOR ITG CLARITY PPM FEDERAL Clarity PPM SaaS 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>

TEC1626083.jpg

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.

 

Attachments

1558689708940000016751_sktwi1f5rjvs16g1g.jpeg get_app