I have a chart with a sql binding that relies on three things:
Line, Startup Time, End Time
I have a dropdown menu for line, which in turn tells my duration dropdown (where I get my startup and end times) where to look in the start/stop table. The question that I have is that every time I change the line I’m looking at, it pulls up new start and end times from the database, and the graph queries the database twice.
“I’m a graph. I show info about a line between a certain time. Oh look, a different line, let’s go check out the database. Oh, a different timeframe, let’s go check out the database.”
Is there any way to make that graph query the whole thing at once? Also, I need to be able to change start and stop times without changing the line (look at yesterday).