# Converting Array Value from Query **URL:** \ **Category:** Ignition\ **Tags:** ignition81, perspective, scripting\ **Created:** [December 7, 2022, 2:48pm UTC](https://forum.inductiveautomation.com/t/converting-array-value-from-query/67336 "2022-12-07T14:48:31Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![Robert\_Hrynciw](https://avatars.discourse-cdn.com/v4/letter/r/3bc359/32.png) [@Robert\_Hrynciw](https://forum.inductiveautomation.com/u/Robert_Hrynciw)\ **Post date:** [December 7, 2022, 2:48pm UTC](https://forum.inductiveautomation.com/t/converting-array-value-from-query/67336/1 "2022-12-07T14:48:31Z")
Hello all, I am currently struggling with displaying data as an integer that is being pulled via a query. I have created a view where I use the following script to sum up the total value of that platform so I can display it in several textboxes, one for each of the platforms. I run this script from a dropdown filter set to current day (unless modified): > #Variables for table filter > date = self.props.value > shift = self.getSibling("Shift").props.value > dateStart = self.custom.filterDate > dateEnd = self.custom.filterEndTime ``` #Filter the table on startup if date != None and shift != "": #Fill compact totals returnedData = system.db.runNamedQuery("Totals/Compact", {"dateStart" :dateStart, "dateEnd" :dateEnd, "shift" :shift}) self.parent.getChild("Body Box").getChild("Units Box").getChild("Compact Units").props.text = returnedData #Fill FSOU totals returnedData1 = system.db.runNamedQuery("Totals/FSOU", {"dateStart" :dateStart, "dateEnd" :dateEnd, "shift" :shift}) self.parent.getChild("Body Box").getChild("Units Box").getChild("FSOU Units").props.text = returnedData1 #Fill horizon front totals returnedData2 = system.db.runNamedQuery("Totals/Horizon Front", {"dateStart" :dateStart, "dateEnd" :dateEnd, "shift" :shift}) self.parent.getChild("Body Box").getChild("Units Box").getChild("Horizon Front Units").props.text = returnedData2 #Fill horizon rear totals returnedData3 = system.db.runNamedQuery("Totals/Horizon Rear", {"dateStart" :dateStart, "dateEnd" :dateEnd, "shift" :shift}) self.parent.getChild("Body Box").getChild("Units Box").getChild("Horizon Rear Units").props.text = returnedData3 #Fill VMAX totals returnedData4 = system.db.runNamedQuery("Totals/VMAX", {"dateStart" :dateStart, "dateEnd" :dateEnd, "shift" :shift}) self.parent.getChild("Body Box").getChild("Units Box").getChild("VMAX Units").props.text = returnedData4 #Fill VMW classic totals returnedData5 = system.db.runNamedQuery("Totals/VMW Classic", {"dateStart" :dateStart, "dateEnd" :dateEnd, "shift" :shift}) self.parent.getChild("Body Box").getChild("Units Box").getChild("VMW Classic Units").props.text = returnedData5 #Fill VMW HE totals returnedData6 = system.db.runNamedQuery("Totals/VMW HE", {"dateStart" :dateStart, "dateEnd" :dateEnd, "shift" :shift}) self.parent.getChild("Body Box").getChild("Units Box").getChild("VMW HE Units").props.text = returnedData6 #Fill Total returnedData7 = system.db.runNamedQuery("Totals/Total Units", {"dateStart" :dateStart, "dateEnd" :dateEnd, "shift" :shift}) self.parent.getChild("Body Box").getChild("Units Box").getChild("Total Units").props.text = returnedData7 ``` This sets the textboxes to an array (as it is pulled from a query). For example: for today's date, I have [{"":2}] for the unit value for the "Compact" platform. Is there any way to get this to display the 2 without the additional array info? Thanks in advance. ---
**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:** [December 7, 2022, 2:57pm UTC](https://forum.inductiveautomation.com/t/converting-array-value-from-query/67336/2 "2022-12-07T14:57:08Z")
If your queries are returning a singular value that you want to display, then change the query type in the named query to `Scalar Query`. This will cause the query to return a single value and not a dataset/array. Side note, I have no idea what your database structure is, but I would consider using a _single query_ with table joins to get all your totals in one shot. Then you can assign each value to the corresponding label. ---
**Author:** ![Robert\_Hrynciw](https://avatars.discourse-cdn.com/v4/letter/r/3bc359/32.png) [@Robert\_Hrynciw](https://forum.inductiveautomation.com/u/Robert_Hrynciw)\ **Post date:** [December 7, 2022, 3:00pm UTC](https://forum.inductiveautomation.com/t/converting-array-value-from-query/67336/3 "2022-12-07T15:00:12Z")
You are my hero. Thank you very much, I've been wondering what Scalar Query did. I'm still newer to developing, so this was a huge help. I will look into using table joins. ---
**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:** [December 7, 2022, 3:05pm UTC](https://forum.inductiveautomation.com/t/converting-array-value-from-query/67336/4 "2022-12-07T15:05:29Z")
If you do a table join and get multiple totals in a single query, then you can't use scalar. Instead, you would do this ```python # Example data row | total1 | total2 | total3 ------------------------------ 0 | 22 | 44 | 66 ``` ```python results = system.dataset.runNamedQuery("someQuery",{}) pyData = system.dataset.toPyDataSet(results) for row in pyData: label1= row['total1'] label2= row['total2'] label3= row['total3'] ``` ---
**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:** [December 7, 2022, 3:15pm UTC](https://forum.inductiveautomation.com/t/converting-array-value-from-query/67336/5 "2022-12-07T15:15:31Z")
You wouldn't need a loop though. something like ```python label1, label2, label3 = pyData[0][1:] ``` should work ---
**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:** [December 7, 2022, 3:26pm UTC](https://forum.inductiveautomation.com/t/converting-array-value-from-query/67336/6 "2022-12-07T15:26:26Z")
> [@pascal.fragnoud](#): > > You wouldn't need a loop though. True, since the OP is newer to Ignition, I'm sure they will need to loop over a dataset at some point which is why I did it that way. Good point though for a one-liner option, but the first column is just an artifact of printing the dataset, so it would be this I believe ```python label1, label2, label3 = pyData[0] ``` ---
**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:** [December 7, 2022, 3:27pm UTC](https://forum.inductiveautomation.com/t/converting-array-value-from-query/67336/7 "2022-12-07T15:27:41Z")
You don't need the `[:]` then. ---
**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:** [December 7, 2022, 3:28pm UTC](https://forum.inductiveautomation.com/t/converting-array-value-from-query/67336/8 "2022-12-07T15:28:17Z")
Ah, yeah you're right. Python would unpack it automatically 🙂 EDIT: One thing to note about the one-liner method, if the query was ever changed where the column order is altered, then the label assignment would be incorrect. By explicitly indexing by column name, ie `label1 = pyData[0]['total1']`, the script would be more robust