# DQL - Sort and display data

**URL:** <https://community.dynatrace.com/t/dql-sort-and-display-data/49568>\
**Category:** DQL\
**Tags:** dql\
**Created:** [January 3, 2025, 6:18pm UTC](https://community.dynatrace.com/t/dql-sort-and-display-data/49568 "2025-01-03T18:18:32Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![olgatimbur](https://avatars.discourse-cdn.com/v4/letter/o/fbc32d/32.png) [@olgatimbur](https://community.dynatrace.com/u/olgatimbur)\
**Post date:** [January 3, 2025, 6:18pm UTC](https://community.dynatrace.com/t/dql-sort-and-display-data/49568/1 "2025-01-03T18:18:32Z")

</div>

Hello,&nbsp;  
I have a question if i can get some support and idea how I can achieve the required result  
I have a pipeline which is running 2 times a night and the logs are pushed to dynatrace  
I need to be able to display the unique failures from the logs during a week long result, but when i search i get double results  
The timestamp is also diffrent, because it may take more/less time every night and i can’t use it for the query

---

<div class="post-metadata">

**Author:** ![DavidRitter](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/davidritter/32/10328_2.png) [@DavidRitter](https://community.dynatrace.com/u/DavidRitter)\
**Post date:** [January 7, 2025, 6:24pm UTC](https://community.dynatrace.com/t/dql-sort-and-display-data/49568/2 "2025-01-07T18:24:16Z")

</div>

Hello!

If I’m understanding correctly you will want to parse the logs and then use the dedup command. Below is a link to the documentation on this command:

> **[DQL filter and search commands](https://docs.dynatrace.com/docs/platform/grail/dynatrace-query-language/commands/filtering-commands)**
>
> DQL filter and search commands

Hopefully it’s what you’re looking for!
