# Deduplicate query option in data filter

**URL:** <https://community.appfarm.io/t/deduplicate-query-option-in-data-filter/1468>\
**Category:** Feature requests\
**Created:** [October 24, 2024, 8:25am UTC](https://community.appfarm.io/t/deduplicate-query-option-in-data-filter/1468 "2024-10-24T08:25:14Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Sondre](https://dub1.discourse-cdn.com/flex013/user_avatar/community.appfarm.io/sondre/32/105_2.png) [@Sondre](https://community.appfarm.io/u/Sondre)\
**Post date:** [October 24, 2024, 8:25am UTC](https://community.appfarm.io/t/deduplicate-query-option-in-data-filter/1468/1 "2024-10-24T08:25:14Z")

</div>

Hi,

I think a deduplicate or “make distinct” option on Appfarm data filters would be very useful.

Say you want to log changed objects over time, but usually only need the last objects “per case”.  
You then run a Distinct query on app load and query for more details if history is needed.

The image below should give me a list of the most recent objects that has a distinct combination of Meny PM.\_id AND Kildesystem.\_id

 ![image](https://europe1.discourse-cdn.com/flex013/uploads/appfarm/original/2X/3/323491908c57c3776e18b6e569fde7e74a5eb40e.png)

Maybe add a limit as well? “I want the 3 latest changes made by users on this customer” for instance.

Hope this makes sense!

Sondre

---

<div class="post-metadata">

**Author:** ![Shahitha](https://dub1.discourse-cdn.com/flex013/user_avatar/community.appfarm.io/shahitha/32/66_2.png) [@Shahitha](https://community.appfarm.io/u/Shahitha)\
**Post date:** [October 25, 2024, 8:19am UTC](https://community.appfarm.io/t/deduplicate-query-option-in-data-filter/1468/2 "2024-10-25T08:19:18Z")

</div>

Hi Sondre,

It made sense and I’ve passed this on to our Devs team as a feature request!

Have great day!