Enable Advanced Filter by fields other than foreign key for the records of a collection that belongs to another collection

Feature suggestions
1

What is the feature?

Lets assume we have 3 collections A, B and C where A is related to B and B is related to C with hasMany relationships. Can we filter records of A with columns present in collection C ?

Note :- Currently using filter feature we can search records of A based on B but not C as foreign key of B (primary key of C) is not available in subfield of A.

What problem does this solve for you?

This would make filtering of records from a child collection easier even with non-key fields

Who else would be using this feature?

This feature will be very frequently used by all the customer.