Adding custom column to dependency assessment in BCM

[RP19]

Hi Everyone,

I am having "Group Members" dependency assessment which points to sys_user_members table.

I want to add columns like User Phone Number, User Name to that dependency assessment.

I am following below article to implement columns but data is not coming. It's blank.

https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB1645940

Only depends on column is having data. I have created reference field in sn_bia_dependency table and adding phone number, user name in list layout by doing dot walking but that is not working.

Can you please help to understand what is going wrong?

Also, how can I sort "depends on" field alphabetically as field type is Document ID.

Thank you in advance!

[Vishal Jaswal]

Hello @RP19 

Table: sn_bia_dependency
Configure > List Layout (View --> workspace or any other)
"Depends on" is a document id type field, hence no dot walking is available.

As you have already created a custom reference type field in table sn_bia_dependency, then you should be able to add it's dot walk fields like I have done for configuration item:

Share the screenshot of your list layout for table sn_bia_dependency 

[RP19]

Thanks @Vishal Jaswal  for your quick response.

I have shared screenshots of all 3 screens. Please kindly help.