Showing related list based on condition

Community Alums · ‎07-30-2019

Hi Community,

I have a requirement and i am unable to configure this.

I need to show related list only if a Manufacturer(column-datatype choice) has value "DELL", then show only Dell Records in 'CMDB DELL' related list. Otherwise, no need to show any other related list records.

Second requirement is when a Manufacturer is (column-datatype choice) has value "IBM", then show all the records except DELL records in 'CMDB IBM' related list.

For this i have made two relationship one for CMDB DELL and CMDB IBM both on same tables..I am not sure how to add the condition. Could you please help me out here..

Thanks in advance.

Dubz · ‎07-30-2019

You configure the relationship query in the same way as you would a before query business rule. Out of the box, the manufacturer field is a reference field to the core_company table so you'll need to use a sys_id, if you've made a custom field then you can just use the values for the choice in there.

Once you've added the related list, right click on one of the columns on it and go configure > list control and tick the Omit if empty box and it will only show if there is data.

View solution in original post

Harry Campbell2 · ‎07-30-2019

You could create a 'Dell' view, and include that related list on that view only - Then use view rules to force into that view if Dell is the manufacturer.

Uncle Rob · ‎07-30-2019

No way in hell I'd build such a complicated and exotic interface around my relationship to other vendors.

Why not just make a UI List Action that opens a new tab with a filtered list?

"Show me Dell stuff"
"Show me IBM stuff"

Community Alums · ‎07-30-2019

Hi Robert,

Thanks for showing interest answering my post.

The requirement is clear, they want it in two different 'tabs' like i have explain in my post.

Regards,

Rahul RJ · ‎07-30-2019

Hi Rafmine,

You can see document link to show related list value depend on the field value.

https://docs.servicenow.com/bundle/madrid-platform-user-interface/page/administer/form-administratio...

Thanks,

RJ