# Popup View, parameter, stored procedure

**URL:** <https://forum.inductiveautomation.com/t/popup-view-parameter-stored-procedure/64354>\
**Category:** Ignition\
**Tags:** ignition81, perspective\
**Created:** [September 22, 2022, 1:02am UTC](https://forum.inductiveautomation.com/t/popup-view-parameter-stored-procedure/64354 "2022-09-22T01:02:39Z")\
**Posts on this page:** 1\
**Showing post:** 5

<div class="post-metadata">

**Author:** ![mdemaris](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/mdemaris/32/54639_2.png) [@mdemaris](https://forum.inductiveautomation.com/u/mdemaris)\
**Post date:** [September 23, 2022, 1:11am UTC](https://forum.inductiveautomation.com/t/popup-view-parameter-stored-procedure/64354/5 "2022-09-23T01:11:32Z")

</div>

Here’s what I have now:

```auto
	params1 = {"itemId":event.value["ItemID"]}
	ds = system.db.runNamedQuery(getOnHandQty, params1)
	data = [ds.getValueAt(i,0 for i in range(ds.getRowCount())]
	params2 = {'data':data}
	
	system.perspective.openPopup("itemSignoutId",'itemSignout', params=params2, showCloseIcon = True, resizable = True)

```

I grabbed much of this off a thread I found, but I didn’t mark the thread…  
This code should send a data set, as a JSON dictionary or object, right?  
So how do I find the individual data within it on the popup view and feed those to the corresponding components?

---

_[View the full topic](https://forum.inductiveautomation.com/t/popup-view-parameter-stored-procedure/64354)._