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

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

book

Article ID: 59472

calendar_today

Updated On:

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.