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.
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.
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.
