Is it possible to sort lists by attributes which are BRELs?

Products

• CA IT Asset Manager
• CA Software Asset Manager (CA SAM)
• ASSET PORTFOLIO MGMT- SERVER
• SUPPORT AUTOMATION- SERVER
• CA Service Desk Manager - Unified Self Service
• CA Service Desk Manager
• CA Service Management - Asset Portfolio Management
• CA Service Management - Service Desk Manager

Issue/Introduction

Description:

If you add a field from an extension table to the columns in the list of Configuration Items (CIs) displayed by the list_nr.htmpl form, you can use the field in a search, but if you try to sort the list by this field, the resulting list is not correct and the following message is written to the stdlog:

06/13 15:35:01.88 hostname    domsrvr    692 ERROR    factory.c    6527 Unable to resolve dottedreference assoc_har_serx.phys_ mem in factory nr; phys_mem is BREL

In this example, assoc_har_serx is the extension table and phys_mem is one of its fields.

 

Environment

CA Service Management 17.4.x

Resolution

In the example, if you run the command, bop_sinfo -d nr, it shows relationships including:

  assoc_har_serx BREL <- har_serx.id {id = ?} 

har_serx is the logical name of the physical extension table named ci_hardware_server which has an attribute phys_mem.
BREL is a Backwards Relationship list; that is, it is a list of Objects with SRELs pointing to the Object.

Unfortunately BRELs are not supported in the sort list. Sorting a list by this type of field does not work.