SQL Query Return all values equal to specific value

Ignition
,
1

I have the following database:
image

I have a button that I has the following script:

checkReports = system.db.runScalarQuery("SELECT Client FROM Tracker WHERE SendReminder IN ('X')")
self.getSibling("TextField").props.text = checkReports

The problem is, my SQL query is only returning the first client “A” in the textbox, and not the rest of the clients. How can I return the name of each client that has an X in their “SendReminder” column? So in this case, it would return “A, B, E”

Thank you

2

Use system.db.runQuery, not system.db.runScalarQuery.

2 Likes
3

runScalerQuery returns only one row.
Named queries configured as scaler will also only return one row.

4

Not just one row, first row and first column, i.e. a scalar value.

1 Like