Connection between sql- database and java script, HELP! I am lost. Hi,
I have a problem binding a property of a thing to an sql-dataquery. Sorry for the "unadvanced explanation" in forehand.
What I would like to do:
In General: I have a dataset in an sql database. My things have a property called LineID. I want to get a dataset for the specific LineID, e.g. 5.
What I did:
In the composer, in a Template I wrote a sql code called BottelneckCurrentOrderARRS:
SELECT [LineID] ,[mcName] ,[BCR] ,[CycleTime] ,[ShiftOEE] FROM OEE_CurrentOrder //This connection is established and works fine where LineID= [[LineID]] order by CycleTime desc
This code should invoke data, from a specific Line. Lets say the lineID is 5. The database contains data about several Lines but in this case I am only interested in the attributes of Line5.
Question 1: Can I write a comparison like i wrote ( where LineID= [[LineID]])) ?
In the thing template of the line, the property LineID is stored under Properties->Thingshape.->LineID
&nb
