# Grabbing record out of each of series that matches a date?

**URL:** <https://forum.inductiveautomation.com/t/grabbing-record-out-of-each-of-series-that-matches-a-date/92291>\
**Category:** 3rd Party Modules\
**Tags:** ignition81\
**Created:** [June 24, 2024, 6:53pm UTC](https://forum.inductiveautomation.com/t/grabbing-record-out-of-each-of-series-that-matches-a-date/92291 "2024-06-24T18:53:16Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![bkarabinchak.psi](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/bkarabinchak.psi/32/83567_2.png) [@bkarabinchak.psi](https://forum.inductiveautomation.com/u/bkarabinchak.psi)\
**Post date:** [June 24, 2024, 6:53pm UTC](https://forum.inductiveautomation.com/t/grabbing-record-out-of-each-of-series-that-matches-a-date/92291/1 "2024-06-24T18:53:16Z")

</div>

Trying to use integration toolkit expressions for the first time in a for fun project to sharpen up my skills after a bit of an absence.

I have a TimeSeries chart with a variable number of Series with data that will look like  
 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/f/b/fb33343040c4ab28f59724512a67777825bb701b.png)

Left hand are midnighted dated times, right hand side a column with a column name related to a stock. Right now I just want to try to get a single record by matching it to a datetime custom property. When double clicking on a TimeSeriesChart I put the X-Trace value into a custom property  
 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/e/6/e6353da795794ecaff689c8229be7f577ac730c6.png)

Right now I am trying to grab the record from this table via

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/c/4/c4f8233c9398cf83bd997b1641b919337e04ba66.png)

But I am getting nothing. Not sure why. What am I doing wrong?

---

<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 24, 2024, 7:16pm UTC](https://forum.inductiveautomation.com/t/grabbing-record-out-of-each-of-series-that-matches-a-date/92291/2 "2024-06-24T19:16:40Z")

</div>

Make sure your milliseconds are also zero.

Or use `>=` instead of `=` and then select from the first row of that subexpression.

---

<div class="post-metadata">

**Author:** ![bkarabinchak.psi](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/bkarabinchak.psi/32/83567_2.png) [@bkarabinchak.psi](https://forum.inductiveautomation.com/u/bkarabinchak.psi)\
**Post date:** [June 24, 2024, 7:50pm UTC](https://forum.inductiveautomation.com/t/grabbing-record-out-of-each-of-series-that-matches-a-date/92291/3 "2024-06-24T19:50:29Z")

</div>

Is the best way to get the first row still using `view()` or is there a new expression keyword I can use? Tried searching and found this old topic from before the new expression keywords [Way to get a whole row of a dataset via an expression? - #9 by pturmel](https://forum.inductiveautomation.com/t/way-to-get-a-whole-row-of-a-dataset-via-an-expression/51577/9)

---

<div class="post-metadata">

**Author:** ![Matthew.gaitan](https://avatars.discourse-cdn.com/v4/letter/m/59ef9b/32.png) [@Matthew.gaitan](https://forum.inductiveautomation.com/u/Matthew.gaitan)\
**Post date:** [June 24, 2024, 7:52pm UTC](https://forum.inductiveautomation.com/t/grabbing-record-out-of-each-of-series-that-matches-a-date/92291/4 "2024-06-24T19:52:45Z")

</div>

I would try using `where([your expression], idx()=0)`

---

<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 24, 2024, 8:01pm UTC](https://forum.inductiveautomation.com/t/grabbing-record-out-of-each-of-series-that-matches-a-date/92291/5 "2024-06-24T20:01:02Z")

</div>

Just supply row index zero inside the brackets. If you want the whole row, wrap with another `where(..., idx()=0)`.