Hi, How can I filter something based on a related table.
For example, I need to join on a condition.
Parent.id=child.id = This is possible.
But what about extra clause and child.name like "%ABC%"
This is a major setback for us, because we have hundreds of records and currently its retrieving everything based on FK relationships.
I know there is a way to write a custom script. But this is very common, so I was hoping it could be in core DF itself.
Thank you in advance.