# Sort descending Tag History binding by Timestamp

**URL:** <https://forum.inductiveautomation.com/t/sort-descending-tag-history-binding-by-timestamp/36131>\
**Category:** Ignition\
**Created:** [June 28, 2020, 9:11pm UTC](https://forum.inductiveautomation.com/t/sort-descending-tag-history-binding-by-timestamp/36131 "2020-06-28T21:11:50Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![nader.chinichian](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/nader.chinichian/32/9261_2.png) [@nader.chinichian](https://forum.inductiveautomation.com/u/nader.chinichian)\
**Post date:** [June 28, 2020, 9:11pm UTC](https://forum.inductiveautomation.com/t/sort-descending-tag-history-binding-by-timestamp/36131/1 "2020-06-28T21:11:50Z")

</div>

Hi,

I like to populate perspective tables with tag history data that I want to see the latest entry first.  
The best way is using script transform after history binding.  
I need some idea on how to use script transform to do that.  
The tag history binding return two format document and dataset. Which format is easier to manipulate on the fly by script transform?

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [June 28, 2020, 9:53pm UTC](https://forum.inductiveautomation.com/t/sort-descending-tag-history-binding-by-timestamp/36131/2 "2020-06-28T21:53:58Z")

</div>

Well, the [system.dataset.sort()](https://docs.inductiveautomation.com/display/DOC80/system.dataset.sort) function would make it a one-liner. Is that easy enough?

---

<div class="post-metadata">

**Author:** ![nader.chinichian](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/nader.chinichian/32/9261_2.png) [@nader.chinichian](https://forum.inductiveautomation.com/u/nader.chinichian)\
**Post date:** [June 29, 2020, 4:24am UTC](https://forum.inductiveautomation.com/t/sort-descending-tag-history-binding-by-timestamp/36131/3 "2020-06-29T04:24:23Z")

</div>

Hi Phil  
Thanks. But what about document format which is needed json(document format)  
What you think about json vs dataset? Which one has better performance?

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [June 29, 2020, 11:43am UTC](https://forum.inductiveautomation.com/t/sort-descending-tag-history-binding-by-timestamp/36131/4 "2020-06-29T11:43:52Z")

</div>

> [@nader.chinichian](#):
>
> Which one has better performance?

Sounds like someone needs to do some timing experiments....

---

<div class="post-metadata">

**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\
**Post date:** [June 29, 2020, 3:17pm UTC](https://forum.inductiveautomation.com/t/sort-descending-tag-history-binding-by-timestamp/36131/5 "2020-06-29T15:17:09Z")

</div>

The tag history APIs natively return datasets - choosing the document format is doing post-query transformation, so I would certainly expect dataset returns to be faster. What may be slower is actually _using_ those results in Perspective, since datasets have to be transformed a little bit to work across our property trees. Worth some testing, for sure.

---

<div class="post-metadata">

**Author:** ![nader.chinichian](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/nader.chinichian/32/9261_2.png) [@nader.chinichian](https://forum.inductiveautomation.com/u/nader.chinichian)\
**Post date:** [June 29, 2020, 5:18pm UTC](https://forum.inductiveautomation.com/t/sort-descending-tag-history-binding-by-timestamp/36131/6 "2020-06-29T17:18:42Z")

</div>

Thanks Paul,  
Could you please guide me how I can sort the return json (document format)?  
I also need some data manipulation on the results.