Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Incident Reports » Incident Reports Reported for Version 2.18 » View Incident Report |
Serious |
Reported By: Brian Clingan Reported On: 3/10/2015 For: Version 2.18 Build 3 |
SELECT "ldto"."Wsn" , "ldto"."Lsn" ,"iq"."Id" ,(SELECT COALESCE("Locked", 0) FROM "DataLock" AS "dl" WHERE "dl"."Id" = "ldto"."Lsn" AND ("dl"."Wsn" = "ldto"."Wsn" OR "dl"."Wsn" = -1)) AS "Locked" ,"ldto"."Units" ,"ldto"."NumPts" ,"ldto"."Start" ,"ldto"."Stop" ,"ldto"."Step" ,"ldto"."NullVal" ,"ldto"."MinVal" ,"ldto"."MaxVal" ,"ldto"."Flags" ,COALESCE("ldto"."LasId", 0) AS "LasId" ,"ldto"."Mean" ,"ldto"."StdDev" FROM (SELECT "ldti"."Wsn" ,"alci"."Id" ,MIN("alci"."Seq") AS "MinSeq" FROM "LogData" AS "ldti" INNER JOIN "AliasLogCurve" AS "alci" ON "ldti"."Lsn" = "alci"."Alias" AND "alci"."Id" IN (323) GROUP BY "ldti"."Wsn", "alci"."Id") AS iq INNER JOIN "AliasLogCurve" AS "alco" ON "iq"."Id" = "alco"."Id" AND "iq"."MinSeq" = "alco"."Seq" INNER JOIN "LogData" AS "ldto" ON "alco"."Alias" = "ldto"."Lsn" AND "iq"."Wsn" = "ldto"."Wsn" ORDER BY "Wsn"
This web page was last updated on Tuesday, April 23, 2024 at 08:39 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |