Tags: %TAGME{ tpaction="" web="Main" tag="" }% view all tags

Useful queries for Solar database

SELECT `IID`, `QID`, `Response`, `TimeStamp` FROM `Answers` WHERE `IID` like "A%" AND `QID` IN ("qWattsMin1", "qVoltsMin1") order by `TimeStamp`;


SELECT `IID`, `QID`, `Response`, `TimeStamp` FROM `Answers` WHERE `IID` like "A%" AND `QID` IN ("qWattsMin1", "qVoltsMin1") AND `TimeStamp` > "2016-7-31" AND `TimeStamp` < "2016-9-01" order by `TimeStamp`;

SELECT `IID`, `QID`, `Response`, `VoiceIndex`, `TimeStamp` FROM `Answers` WHERE `IID` like "A%" AND `QID` not like "qReg&" order by `TimeStamp`;

-- Jim Skon - 2016-09-05

Comments

Edit | Attach | Watch | Print version | History: r2 < r1 | Backlinks | Raw View | Raw edit | More topic actions
Topic revision: r2 - 2016-09-06 - JimSkon
 
This site is powered by the TWiki collaboration platform Powered by PerlCopyright © 2008-2020 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Ideas, requests, problems regarding TWiki? Send feedback