Where is the information on Manage Filters saved?

Article Id: 16751
Status: Published
Updated On: 21-02-2019 08:33
Legacy Id: TEC1626083
Products:
CLARITY PPM FOR ITG , CLARITY PPM FEDERAL , CA Project & Portfolio Management SAAS , STARTER PACK-CLARITY PPM
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.

 

insert_drive_file 1558689708940000016751_sktwi1f5rjvs16g1g.jpeg
arrow_downward Download