lookup field filtering in dataset for related entity
I have a lookup field for a related entity in my view which i am displaying in my custom dataset grid using PCF. I have a requirement to filter the dataset grid using the related entity lookup field. When i sue setFilter() method , the filter is getting applied to original entity and the related entity field.
Can you please advise if there is any way to filter dataset in PCF using related entity lookup field?(for ex:, i have account's owner in contact's subgrid and need to filter the contacts subgrid based on Account's owner-user input)