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.
CA Service Management 17.4.x
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.