ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Query Filters for Config Information

book

Article ID: 238910

calendar_today

Updated On:

Products

CA Service Management - Asset Portfolio Management

Issue/Introduction

How we query database for the following?

1. Filter Name, Object, Asset Family

2. Filter Name, Last Name, First Name

3. Filter Name, Criteria (Field Name, Operator, Connector, Value)

 

Environment

Release : 17.3

Component : ITAM - Other

Resolution

--1. Filter Name, Object, Asset Family
al_filter_def ->  filter_id (PK), filter name, class name (object) -- Filter definition
al_filter_subtype_def -> subtype_id (PK), filter_id -- gives the subtype_id of the filter
al_filter_subtype_attrib_def -> subtype_attribute_id (PK), subtype_id, attribute_value (Asset family id) -- lists the asset families associated with the subtype_id
ca_resource_family -> ID (Asset Family Id, PK), Name (Asset Family name) -- Asset Family core table


--2. Filter Name, Last Name, First Name
al_filter_def ->  filter_id (PK), filter name
al_link_filter_user -> filter_id , contact_id (contact_uuid from ca_contact) -- links filter and the assigned user
ca_contact -> contact_uuid (PK) , Last_name, First_name -- Contacts/Users core table

 

--3. Filter Name, Criteria (Field Name, Operator, Connector, Value)
al_filter_def ->  filter_id (PK), filter name
al_link_filter_criteria -> filter_id , criteria_id -- links filter with its criteria
al_criteria_def -> criteria_id (PK), class_name, operator_id, connector_id, value -- Criteria table
arg_sl_operator -> ID (PK), value -- operators table
arg_sl_connector -> ID (PK), value -- connectors table