Subscribing is a smart move!
You can subscribe to this forum after you log in or create your free account.
Geo SCADA Knowledge Base
Access vast amounts of technical know-how and pro tips from our community of Geo SCADA experts.
Originally published on Geo SCADA Knowledge Base by sbeadle1 | June 09, 2021 11:52 PM
SELECT FULLNAME, FULLNAME || '
Highest_Severity:_' || AlarmSeverityDesc as "TOOLTIP", GISLOCATION->LATITUDE, GISLOCATION->LONGITUDE,CASE WHEN AlarmSetCount > 0 THEN 255 WHEN AlarmAcceptedCount > 0 THEN 255 WHEN AlarmClearedCount > 0 THEN 150*256 ELSE 0 END AS "Foreground", Background,CASE WHEN AlarmSetCount > 0 THEN 1 ELSE 0 END AS "Blink",AlarmSetCount, AlarmAcceptedCount, AlarmClearedCountFROM CGROUPORDER BY AlarmSetCount, AlarmAcceptedCount, AlarmClearedCount
SELECT g.Id as "Id", g.FullName as "FullName",g.FullName || '
Value: ' || FormatValue (r.Walk Using '0.00') as "Tooltip",g.GISLOCATION->LATITUDE as "GISLOCATION->LATITUDE", g.GISLOCATION->LONGITUDE as "GISLOCATION->LONGITUDE",casewhen r.Walk < 50 then (cast(r.Walk/100*2*255 as INT) + 255*256)when r.Walk > 50 then (255 + cast( (100-r.Walk)/100*2*255 as INT)*256)end as "Foreground",255+256*255+256*256*255 as "Background", 0 as "Blink"FROM CGROUP AS g left join CRandom as r on r.ParentGroupId = g.IdWHERE g.FULLNAME LIKE 'Sites.%'
WHERE (GEOPOSITION WITHIN REGION '5.05811437435571,-95.017822265625' TO '-5.05811437435572,-60.982177734375' )
SELECT * FROM ( SELECT TOP (5000) A.FULLNAME, B.LATITUDE AS "GISLOCATION->LATITUDE", B.LONGITUDE AS "GISLOCATION->LONGITUDE" FROM ODBC_GROUP AS A JOIN ODBC_TEST AS B ON A.ID = B.ID WHERE (A.GISLOCATIONSOURCE = True) ))
Create your free account or log in to subscribe to the forum - and gain access to more than 10,000+ support articles along with insights from experts and peers.