# Dataset value fetch based on column value

**URL:** <https://forum.inductiveautomation.com/t/dataset-value-fetch-based-on-column-value/55931>\
**Category:** Ignition\
**Tags:** ignition80, ignition81, perspective, scripting\
**Created:** [February 9, 2022, 6:25pm UTC](https://forum.inductiveautomation.com/t/dataset-value-fetch-based-on-column-value/55931 "2022-02-09T18:25:31Z")\
**Posts on this page:** 1\
**Showing post:** 6

<div class="post-metadata">

**Author:** ![dkhayes117](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/dkhayes117/32/68344_2.png) [@dkhayes117](https://forum.inductiveautomation.com/u/dkhayes117)\
**Post date:** [February 9, 2022, 6:51pm UTC](https://forum.inductiveautomation.com/t/dataset-value-fetch-based-on-column-value/55931/6 "2022-02-09T18:51:56Z")

</div>

@pturmel has a `Simulation Aids` Module that is free and includes an expression function that can search a dataset like a query called `view()`

> [@Filter in table](https://forum.inductiveautomation.com/t/filter-in-table/53282/2):
>
> The tag historian doesn’t offer that feature built-in. You will need to move the binding to a custom property and perform the filtering action yourself. You can do this with a script, but for convenience I recommend the [view()](https://www.automation-pros.com/simaids/doc/expression.view.html) expression function from my free [Simulation Aids](https://inductiveautomation.com/moduleshowcase/module/automation-professionals-llc-simulation-aids) module. You would bind the original table’s data property with an expression like this: view("Select \* Where someColumn==someConstant", {Root Container.path.to.custom.prop})

---

_[View the full topic](https://forum.inductiveautomation.com/t/dataset-value-fetch-based-on-column-value/55931)._