# Issue with Top 10 Filter Removal in Query after joining

**URL:** <https://community.omni.co/t/issue-with-top-10-filter-removal-in-query-after-joining/282>\
**Category:** Modeling\
**Tags:** modeling\
**Created:** [March 24, 2025, 7:17am UTC](https://community.omni.co/t/issue-with-top-10-filter-removal-in-query-after-joining/282 "2025-03-24T07:17:36Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Amihai](https://avatars.discourse-cdn.com/v4/letter/a/b38774/32.png) [@Amihai](https://community.omni.co/u/Amihai)\
**Post date:** [March 24, 2025, 7:17am UTC](https://community.omni.co/t/issue-with-top-10-filter-removal-in-query-after-joining/282/1 "2025-03-24T07:17:36Z")

</div>

I created my top 10 list using aggregation, saved it as a view, and joined it with my main topic. However, the top 10 filter was removed from my query, resulting in the full list. How can I fix this?

---

<div class="post-metadata">

**Author:** ![liam](https://yyz2.discourse-cdn.com/flex004/user_avatar/community.omni.co/liam/32/178_2.png) [@liam](https://community.omni.co/u/liam)\
**Post date:** [March 24, 2025, 8:06am UTC](https://community.omni.co/t/issue-with-top-10-filter-removal-in-query-after-joining/282/2 "2025-03-24T08:06:58Z")

</div>

Hi Amihai  
We intentionally don’t include the limit in the query view, because most use-cases want a full view of the data. However there is a [limit](https://docs.omni.co/docs/modeling/query-views#limit) parameter you can add to the definition.  
For use-cases like this, we find that [filter by query](https://docs.omni.co/docs/querying-and-sql/querying#filtering-by-another-query) can be a better option because it doesn’t require any new model objects