> For the complete documentation index, see [llms.txt](https://docs.withorbital.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.withorbital.com/orbital-2.0/records/filtering-in-records.md).

# Filtering in Records

Records supports filtering related entities. For example, on a Company object you can filter by properties of attached Contacts, Deals, or Locations.

For Example:

* Positive filter on related entity = at least one match (e.g. Company where at least one Contact has a phone number)
* Filter out voids = Remove the records where attribute is empty (e.g. Company where website is not empty)
* Filter in combination = Use grouping with 'AND', 'OR' to filter on multiple conditions

<figure><img src="https://3556389590-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FRgu04knFALZ4wMaHQxSu%2Fuploads%2FZsWGBOQYkpmo47oGddbB%2Fimage.png?alt=media&amp;token=cc5d45d6-3164-4135-a7e0-5bf89a5f08e1" alt=""><figcaption></figcaption></figure>