Dropdown list in vision

Ignition
, ,
1

Hi Guys,

I'm trying to in the dropdown list display text "All Record". In below screenshot shows a list from the database correctly I'm trying to add "All Record" text in the first row but "All Record" is not available in database.

Any ideas on how to add "All Record" text in the dropdown list?

image

Thanks,
Priyanka

2

Maybe something like this:

SELECT '-1', 'All Record'
UNION
<existing query>
6 Likes
3

Found below error:

All queries combined using a UNION, INTERSECT or EXCEPT operator must have an equal number of expressions in their target lists.

4

Basically the first query must match the column count in your query.

Edit, do a quick Google, it will do a better job explaining than I can.

4 Likes
5

Hi Guys,

Resolved my problem using the following query but get output in order by my case "Exporting all formulas" This text always displays at the top.

SELECT 'Exporting all formulas' AS col1
UNION
SELECT Name AS col1 FROM Test

Any idea?

Thanks,
Priyanka

6

Resolved using following script:

headers = ['col1']
data = []
data.append(['Exporting all formulas'])
options = system.dataset.toDataSet(headers, data)
print options 
query = "Select Name from Test"
pyDataset = system.db.runPrepQuery(query)
normalDataset = system.dataset.toDataSet(pyDataset)
print normalDataset
appendDataset = system.dataset.appendDataset(options, normalDataset)
print appendDataset
event.source.data = appendDataset