I have a Dataset tag I call “RouteSourceNames”, it has columns “RouteNum”, “RouteName”, and “Route2” (boolean). I have populated this dataset with 21 rows by importing from excel.
I put a Dropdown List on my display, I can link Data to this tag no problem, it works fine, functions as expected.
Now my dilemma: I want to only show a subset of the dataset - I only want to show the rows where “Route2” is True.
So instead of binding to a Tag, I attempt to bind to a SQL Query, where i enter
SELECT RouteNum, RouteName
FROM {RouteSourceNames}
WHERE Route2=True
I get error
Exception: Error running query:
SQLQuery(query=SELECT RouteNum, RouteName
FROM Dataset [21R ⅹ 5C]
WHERE Route2=True, database=Ignition_SQL_App001)@0ms
On: ROUTE2.Root Container.cboSource.data
caused by GatewayException: Invalid object name ‘Dataset’.
caused by SQLServerException: Invalid object name ‘Dataset’.
Ignition v7.9.8 (b2018060714)
Java: Oracle Corporation 1.8.0_161
I think I am missing something in the syntax to refer to the dataset tag. The only examples I can find work with a SQL table, i’d prefer to avoid creating a SQL table if possible.