# Need assistance on scripting

**URL:** <https://forum.inductiveautomation.com/t/need-assistance-on-scripting/60723>\
**Category:** Ignition\
**Created:** [June 14, 2022, 12:37am UTC](https://forum.inductiveautomation.com/t/need-assistance-on-scripting/60723 "2022-06-14T00:37:29Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![gunpathe](https://avatars.discourse-cdn.com/v4/letter/g/8e7dd6/32.png) [@gunpathe](https://forum.inductiveautomation.com/u/gunpathe)\
**Post date:** [June 14, 2022, 12:37am UTC](https://forum.inductiveautomation.com/t/need-assistance-on-scripting/60723/1 "2022-06-14T00:37:29Z")

</div>

Hi,  
I need assistance regarding scripting.

I have a named query which fetches records and I want that particular column to be stored in list.

What I have done was …  
Not helping mate,  
Instead of showing the data, it showing someothere inbuilt functions data

```auto
ds = system.db.runNamedQuery("Defects/Lookups/SelectHostandIP")
pds = system.dataset.toPyDataSet(ds)
LocalHostName = system.net.getHostName()
print("Printing Available HostName List")  
for HostName in pds:
    lists = HostName[0]
    print(lists)

```

I’m getting the result like this,  
AAAA  
BBBB  
CCCC  
DDDD

THE DESIRED output,  
[AAAA,BBBB,CCCC,DDDD]

---

<div class="post-metadata">

**Author:** ![schenk](https://avatars.discourse-cdn.com/v4/letter/s/6bbea6/32.png) [@schenk](https://forum.inductiveautomation.com/u/schenk)\
**Post date:** [June 14, 2022, 1:49am UTC](https://forum.inductiveautomation.com/t/need-assistance-on-scripting/60723/2 "2022-06-14T01:49:12Z")

</div>

Try this:

```auto
results = system.db.runNamedQuery(...)
colList = results.getColumnAsList(columnNumber)

```

FYI, you can always use something like the following to get a list of available methods/attributes on an object

```auto
for item in dir(results):
	print item

```

---

<div class="post-metadata">

**Author:** ![schenk](https://avatars.discourse-cdn.com/v4/letter/s/6bbea6/32.png) [@schenk](https://forum.inductiveautomation.com/u/schenk)\
**Post date:** [June 14, 2022, 2:27am UTC](https://forum.inductiveautomation.com/t/need-assistance-on-scripting/60723/4 "2022-06-14T02:27:39Z")

</div>

Can you show the actual script you’re running? When you post, use the `</>` button to format it properly.

---

<div class="post-metadata">

**Author:** ![gunpathe](https://avatars.discourse-cdn.com/v4/letter/g/8e7dd6/32.png) [@gunpathe](https://forum.inductiveautomation.com/u/gunpathe)\
**Post date:** [June 14, 2022, 2:32am UTC](https://forum.inductiveautomation.com/t/need-assistance-on-scripting/60723/5 "2022-06-14T02:32:39Z")

</div>

Please take a look at the post it self.

---

<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 14, 2022, 2:35am UTC](https://forum.inductiveautomation.com/t/need-assistance-on-scripting/60723/6 "2022-06-14T02:35:00Z")

</div>

Each `print` makes a new line. Instead of printing inside the loop, add the value to a list that you initialize before the loop. Then print it after the loop ends.

---

<div class="post-metadata">

**Author:** ![schenk](https://avatars.discourse-cdn.com/v4/letter/s/6bbea6/32.png) [@schenk](https://forum.inductiveautomation.com/u/schenk)\
**Post date:** [June 14, 2022, 2:40am UTC](https://forum.inductiveautomation.com/t/need-assistance-on-scripting/60723/7 "2022-06-14T02:40:51Z")

</div>

You don’t need to convert to pyDataSet if you use `.getColumnAsList(columnNumber)` directly on the named queries results

---

<div class="post-metadata">

**Author:** ![gunpathe](https://avatars.discourse-cdn.com/v4/letter/g/8e7dd6/32.png) [@gunpathe](https://forum.inductiveautomation.com/u/gunpathe)\
**Post date:** [June 14, 2022, 2:49am UTC](https://forum.inductiveautomation.com/t/need-assistance-on-scripting/60723/8 "2022-06-14T02:49:35Z")

</div>

Thanks,  
Now i learned How to use this