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

**URL:** https://community.forestadmin.com/t/enable-advanced-filter-by-fields-other-than-foreign-key-for-the-records-of-a-collection-that-belongs-to-another-collection/4296
**Category:** Feature suggestions
**Tags:** howtos
**Created:** [March 3, 2022, 11:45am UTC](https://community.forestadmin.com/t/enable-advanced-filter-by-fields-other-than-foreign-key-for-the-records-of-a-collection-that-belongs-to-another-collection/4296 "2022-03-03T11:45:30Z")
**Posts on this page:** 1
**Page:** 1

<div class="post-metadata">

### Author: ![Saurav\_Suman](https://dub1.discourse-cdn.com/flex013/user_avatar/community.forestadmin.com/saurav_suman/32/3709_2.png) [@Saurav\_Suman](https://community.forestadmin.com/u/Saurav_Suman)
#### Post date: [March 3, 2022, 11:45am UTC](https://community.forestadmin.com/t/enable-advanced-filter-by-fields-other-than-foreign-key-for-the-records-of-a-collection-that-belongs-to-another-collection/4296/1 "2022-03-03T11:45:30Z")

</div>

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