# Verify if a liste of value is on a dataset column

**URL:** <https://forum.inductiveautomation.com/t/verify-if-a-liste-of-value-is-on-a-dataset-column/65511>\
**Category:** Ignition\
**Created:** [October 21, 2022, 8:33am UTC](https://forum.inductiveautomation.com/t/verify-if-a-liste-of-value-is-on-a-dataset-column/65511 "2022-10-21T08:33:35Z")\
**Posts on this page:** 9\
**Page:** 1

<div class="post-metadata">

**Author:** ![sebastien\_ng](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/sebastien_ng/32/55297_2.png) [@sebastien\_ng](https://forum.inductiveautomation.com/u/sebastien_ng)\
**Post date:** [October 21, 2022, 8:33am UTC](https://forum.inductiveautomation.com/t/verify-if-a-liste-of-value-is-on-a-dataset-column/65511/1 "2022-10-21T08:33:35Z")

</div>

Hello, I have a dataset with a column colled id\_Zone.  
On my parameters I have listZone that have a listZone = 1,3

If my listZone is on dataset (column id\_Zone), checkbox is True

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/6/e/6e012154975ad35a16a9fcb524f0e5874b290bf8.png)

![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/5/d/5d6a086eea1d7fb0267b035b48e495f318bc2bba.png)

---

<div class="post-metadata">

**Author:** ![deon.korb](https://avatars.discourse-cdn.com/v4/letter/d/8c91f0/32.png) [@deon.korb](https://forum.inductiveautomation.com/u/deon.korb)\
**Post date:** [October 21, 2022, 9:01am UTC](https://forum.inductiveautomation.com/t/verify-if-a-liste-of-value-is-on-a-dataset-column/65511/3 "2022-10-21T09:01:04Z")

</div>

I would recommend using an expression structure binding, using both `view.params.listZone` and `view.params.listZoneBuilding`. You can then use a script transform to check if one is in the other.

[Expression Structure Bindings in Perspective - Ignition User Manual 8.1 - Ignition Documentation (inductiveautomation.com)](https://docs.inductiveautomation.com/display/DOC81/Expression+Structure+Bindings+in+Perspective)

[Script Transform - Ignition User Manual 8.1 - Ignition Documentation (inductiveautomation.com)](https://docs.inductiveautomation.com/display/DOC81/Script+Transform)

---

<div class="post-metadata">

**Author:** ![justinedwards.jle](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/justinedwards.jle/32/37854_2.png) [@justinedwards.jle](https://forum.inductiveautomation.com/u/justinedwards.jle)\
**Post date:** [October 21, 2022, 9:02am UTC](https://forum.inductiveautomation.com/t/verify-if-a-liste-of-value-is-on-a-dataset-column/65511/4 "2022-10-21T09:02:36Z")

</div>

Your expression is on a boolean checkbox?  
You're attempting to evaluate if an integer called list zone exists in the id\_zone column?

---

<div class="post-metadata">

**Author:** ![vasanth.p](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/vasanth.p/32/38099_2.png) [@vasanth.p](https://forum.inductiveautomation.com/u/vasanth.p)\
**Post date:** [October 21, 2022, 9:09am UTC](https://forum.inductiveautomation.com/t/verify-if-a-liste-of-value-is-on-a-dataset-column/65511/5 "2022-10-21T09:09:44Z")

</div>

convert the dataset column id\_Zone into a list by,

[TIP - Converting a dataset column into a list - Ignition - Inductive Automation Forum](https://forum.inductiveautomation.com/t/tip-converting-a-dataset-column-into-a-list/38388)

compare if it is present in the listZone by,

any(map(lambda value: value in id\_Zone, listZone ))

---

<div class="post-metadata">

**Author:** ![sebastien\_ng](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/sebastien_ng/32/55297_2.png) [@sebastien\_ng](https://forum.inductiveautomation.com/u/sebastien_ng)\
**Post date:** [October 21, 2022, 10:10am UTC](https://forum.inductiveautomation.com/t/verify-if-a-liste-of-value-is-on-a-dataset-column/65511/7 "2022-10-21T10:10:36Z")

</div>

Thank you. here is the solution I have.  
 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/6/9/69ca8bdfb3083e2a3e8113d1f130bb0f820efbc7.png)

---

<div class="post-metadata">

**Author:** ![pascal.fragnoud](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pascal.fragnoud/32/24728_2.png) [@pascal.fragnoud](https://forum.inductiveautomation.com/u/pascal.fragnoud)\
**Post date:** [October 21, 2022, 11:48am UTC](https://forum.inductiveautomation.com/t/verify-if-a-liste-of-value-is-on-a-dataset-column/65511/8 "2022-10-21T11:48:46Z")

</div>

Don't post screenshots of code, post the code directly, surrounded in triple backticks:

> ```python  
> code  
> ```

Here's how to rewrite your script more pythonically using @vasanth.p 's method:

```python
listZoneBuilding = value['listBuildingZone']
listZone = value['listZone']
zoneIds = listZoneBuilding.getColumnAsList(x) # replace x with the column's index.
return any(map(lambda zone_id: zone_id in zoneIds, listZone))

```

---

<div class="post-metadata">

**Author:** ![lrose](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/lrose/32/62724_2.png) [@lrose](https://forum.inductiveautomation.com/u/lrose)\
**Post date:** [October 21, 2022, 11:54am UTC](https://forum.inductiveautomation.com/t/verify-if-a-liste-of-value-is-on-a-dataset-column/65511/9 "2022-10-21T11:54:09Z")

</div>

As @pascal.fragnoud has shown there is a better way to write the transform. Also, there is a generic way to get the index from the column name.

```python
listZoneBuilding = value['listBuildingZone']
listZone = value['listZone']

zoneIds = listZoneBuilding.getColumnAsList(listZoneBuilding.getColumnIndex('id_zone'))
return any(map(lambda zone_id: zone_id in zoneIds, listZone))
```

---

<div class="post-metadata">

**Author:** ![pascal.fragnoud](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pascal.fragnoud/32/24728_2.png) [@pascal.fragnoud](https://forum.inductiveautomation.com/u/pascal.fragnoud)\
**Post date:** [October 21, 2022, 11:58am UTC](https://forum.inductiveautomation.com/t/verify-if-a-liste-of-value-is-on-a-dataset-column/65511/10 "2022-10-21T11:58:47Z")

</div>

> [@lrose](#):
>
> `return listZone in listZoneBuilding.getColumnAsList(listZoneBuilding.getColumnIndex('id_zone'))`

I think `listZone` is supposed to be a list of ids, zone so you can't check it like that. That's why @vasanth.p suggested using `map`.

---

<div class="post-metadata">

**Author:** ![lrose](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/lrose/32/62724_2.png) [@lrose](https://forum.inductiveautomation.com/u/lrose)\
**Post date:** [October 21, 2022, 12:02pm UTC](https://forum.inductiveautomation.com/t/verify-if-a-liste-of-value-is-on-a-dataset-column/65511/11 "2022-10-21T12:02:37Z")

</div>

Huh, some how I missed that.