# runNamedQuery doesn't work putting results in a dataset tag anymore after upgrading to 8.1.30 from 8.1.25

**URL:** <https://forum.inductiveautomation.com/t/runnamedquery-doesnt-work-putting-results-in-a-dataset-tag-anymore-after-upgrading-to-8-1-30-from-8-1-25/77632>\
**Category:** Ignition\
**Tags:** ignition81, perspective\
**Created:** [August 9, 2023, 2:01pm UTC](https://forum.inductiveautomation.com/t/runnamedquery-doesnt-work-putting-results-in-a-dataset-tag-anymore-after-upgrading-to-8-1-30-from-8-1-25/77632 "2023-08-09T14:01:50Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![BRYAN\_MOBLEY](https://avatars.discourse-cdn.com/v4/letter/b/db5fbb/32.png) [@BRYAN\_MOBLEY](https://forum.inductiveautomation.com/u/BRYAN_MOBLEY)\
**Post date:** [August 9, 2023, 2:01pm UTC](https://forum.inductiveautomation.com/t/runnamedquery-doesnt-work-putting-results-in-a-dataset-tag-anymore-after-upgrading-to-8-1-30-from-8-1-25/77632/1 "2023-08-09T14:01:50Z")

</div>

Just upgraded to 8.1.30 and now my Memory tag with Dataset as the datatype shows a Error\_TypeConversion. Is this due to my named query trying to save in PyDataset now after the 8.1.29 change? I need to know what to change as this broke a feature we are using on the plant floor.

Just a simple SELECT statement bringing in one row with 4 values.

result = system.db.runNamedQuery("Maintenance", "CL1\_Entry\_Query", args)  
system.tag.writeBlocking("[default]CL1/L2/L2 Entry Data", result)

---

<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:** [August 9, 2023, 2:09pm UTC](https://forum.inductiveautomation.com/t/runnamedquery-doesnt-work-putting-results-in-a-dataset-tag-anymore-after-upgrading-to-8-1-30-from-8-1-25/77632/2 "2023-08-09T14:09:13Z")

</div>

Yes, sounds like a regression. I'm not sure the change to NQs to return PyDatasets was a good idea.

---

<div class="post-metadata">

**Author:** ![BRYAN\_MOBLEY](https://avatars.discourse-cdn.com/v4/letter/b/db5fbb/32.png) [@BRYAN\_MOBLEY](https://forum.inductiveautomation.com/u/BRYAN_MOBLEY)\
**Post date:** [August 9, 2023, 2:41pm UTC](https://forum.inductiveautomation.com/t/runnamedquery-doesnt-work-putting-results-in-a-dataset-tag-anymore-after-upgrading-to-8-1-30-from-8-1-25/77632/3 "2023-08-09T14:41:46Z")

</div>

Ok so I changed it to this and now it works.

Reference: [system.dataset.toDataSet - Ignition User Manual 8.1 - Ignition Documentation](https://docs.inductiveautomation.com/display/DOC81/system.dataset.toDataSet)

result = system.db.runNamedQuery("Maintenance", "CL1\_Entry\_Query", args)  
normalDataSet = system.dataset.toDataSet(result)  
system.tag.writeBlocking("[default]CL1/L2/L2 Entry Data", normalDataSet)