# Select Query run Entire Dropdown list

**URL:** <https://forum.inductiveautomation.com/t/select-query-run-entire-dropdown-list/7352>\
**Category:** General Discussion\
**Created:** [October 2, 2013, 3:14pm UTC](https://forum.inductiveautomation.com/t/select-query-run-entire-dropdown-list/7352 "2013-10-02T15:14:00Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![ilikebeer](https://avatars.discourse-cdn.com/v4/letter/i/eb8c5e/32.png) [@ilikebeer](https://forum.inductiveautomation.com/u/ilikebeer)\
**Post date:** [October 2, 2013, 3:14pm UTC](https://forum.inductiveautomation.com/t/select-query-run-entire-dropdown-list/7352/1 "2013-10-02T15:14:00Z")

</div>

Have a query developed by the original programmer which woks just fine. Is there a way to get this query to go through the entire dropdown list? I tried different ways of replacing the “selectedLabel” portio with “data” believing this might use the entire data set, but i get swamped with errors.  
Here is the current query:

`SELECT A.Status AS 'Fault Code', C.faultdef AS 'Fault Description',
A.t_stamp AS 'Start Time', B.t_stamp 'End Time', TIMESTAMPDIFF(Second,A.t_stamp,B.t_stamp) AS 'Seconds'
FROM {Root Container.Dropdown.selectedLabel}_Status A
INNER JOIN {Root Container.Dropdown.selectedLabel}_Status B ON B.{Root Container.Dropdown.selectedLabel}_status_ndx =
 (A.{Root Container.Dropdown.selectedLabel}_status_ndx + 1)
INNER JOIN Fault_Definitions C ON C.faultcode = A.Status
WHERE (C.machinecode = {Root Container.Dropdown.selectedValue}) AND A.Status > 0
AND A.t_stamp >= '{Root Container.CalendarStart.formattedDate}' AND A.t_stamp <= '{Root Container.CalendarEnd.formattedDate}'
ORDER BY A.{Root Container.Dropdown.selectedLabel}_status_ndx ASC;`  
Thanks ahead of time for any assistance

---

<div class="post-metadata">

**Author:** ![nmudge](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/nmudge/32/3394_2.png) [@nmudge](https://forum.inductiveautomation.com/u/nmudge)\
**Post date:** [October 2, 2013, 4:01pm UTC](https://forum.inductiveautomation.com/t/select-query-run-entire-dropdown-list/7352/2 "2013-10-02T16:01:05Z")

</div>

There are various ways this could be done. A quick way would be to replace the Dropdown expressions with hardcoded table names and values and use multiple queries and combine them with UNIONs.

A more general solution could be implemented by generating the query with some scripting. For example a script could generate a query using the table names and values that exist in the Dropdown data property.

Here’s the query converted to using hardcoded table names and values and combined using UNIONs:

```auto
(SELECT A.Status AS 'Fault Code', C.faultdef AS 'Fault Description',
A.t_stamp AS 'Start Time', B.t_stamp 'End Time', TIMESTAMPDIFF(Second,A.t_stamp,B.t_stamp) AS 'Seconds'
FROM Table1_Status A
INNER JOIN Table1_Status B ON B.Table1_status_ndx =
(A.Table1_status_ndx + 1)
INNER JOIN Fault_Definitions C ON C.faultcode = A.Status
WHERE (C.machinecode = 1) AND A.Status > 0
AND A.t_stamp >= '{Root Container.CalendarStart.formattedDate}' AND A.t_stamp <= '{Root Container.CalendarEnd.formattedDate}'
ORDER BY A.Table1_status_ndx ASC)
UNION
(SELECT A.Status AS 'Fault Code', C.faultdef AS 'Fault Description',
A.t_stamp AS 'Start Time', B.t_stamp 'End Time', TIMESTAMPDIFF(Second,A.t_stamp,B.t_stamp) AS 'Seconds'
FROM Table2_Status A
INNER JOIN Table2_Status B ON B.Table2_status_ndx =
(A.Table2_status_ndx + 1)
INNER JOIN Fault_Definitions C ON C.faultcode = A.Status
WHERE (C.machinecode = 2) AND A.Status > 0
AND A.t_stamp >= '{Root Container.CalendarStart.formattedDate}' AND A.t_stamp <= '{Root Container.CalendarEnd.formattedDate}'
ORDER BY A.Table2_status_ndx ASC)
UNION
(SELECT A.Status AS 'Fault Code', C.faultdef AS 'Fault Description',
A.t_stamp AS 'Start Time', B.t_stamp 'End Time', TIMESTAMPDIFF(Second,A.t_stamp,B.t_stamp) AS 'Seconds'
FROM Table3_Status A
INNER JOIN Table3_Status B ON B.Table3_status_ndx =
(A.Table3_status_ndx + 1)
INNER JOIN Fault_Definitions C ON C.faultcode = A.Status
WHERE (C.machinecode = 3) AND A.Status > 0
AND A.t_stamp >= '{Root Container.CalendarStart.formattedDate}' AND A.t_stamp <= '{Root Container.CalendarEnd.formattedDate}'
ORDER BY A.Table3_status_ndx ASC)
UNION ...
```

I haven’t tried out this solution so I’m not sure if there is any problem with it.

---

<div class="post-metadata">

**Author:** ![ilikebeer](https://avatars.discourse-cdn.com/v4/letter/i/eb8c5e/32.png) [@ilikebeer](https://forum.inductiveautomation.com/u/ilikebeer)\
**Post date:** [October 2, 2013, 5:16pm UTC](https://forum.inductiveautomation.com/t/select-query-run-entire-dropdown-list/7352/3 "2013-10-02T17:16:49Z")

</div>

![:prayer:](https://us1.discourse-cdn.com/inductiveautomation/original/1X/e5a7e3b63facc151ea73e3b45db7bdb3d4bdc316.gif ":prayer:") EXCELLENT! Once I paid attention to the syntax changes all was EXCELLENT!

U-Rule! Thanks!