I've a custom lightning page for a custom object where I'd like to show all the related contacts from an account that have a specific role. Example: Object Custom, Account name set -> List all the contacts having the role set as Sales Representative, even those not being set as main/direct to the account but having the role set for the selected account. Account > Coca Cola Contact John Doe (Main account Food Gro Distributor, Related account Coca Cola => Role Sales Rep.)
How can I do this? I've managed to show the contact related to the account but I can't find a way to filter by the role.