Mouse Click query using a dropdown

Ignition
1

Script I am trying to use when a mouse is clicked. It gives me a mismatched syntaxerror. Any ideas?

SELECT * FROM MobileWorkOrder
WHERE Equipment = ‘{event.source.parent.getComponent(‘Dropdown’).selectedLabel}’

2

Try a printing the query statement to the console. For example, print query. This will help us understand the behavior of the dropdown and mouse click event.

3

This is what it says

File “”, line 1
SELECT * FROM MobileWorkOrder
^
SyntaxError: mismatched input ‘MobileWorkOrder’ expecting NEWLINE

4

disregard last one

File "", line 1
SELECT * FROM MobileWorkOrder
^
SyntaxError: mismatched input 'MobileWorkOrder' expecting NEWLINE

5

it would add the

6

You’re trying to use SQL where python (jython) is expected. You need to construct your SQL in a string and submit it with one of the system.db.* script functions.

7

I didn’t realize that until I went about it a different way. It works now. How do yo know when you need to use python and when you need to use sql. I am new to the scripting side of things.

8

If it’s scripting, it’s python. If it’s a query, it’s SQL.

9

ok, thanks for the help