>>Responses imported from previous forum
Reply From User: sbeadle, posted: 2019-03-01 13:56:25
Hi, you're welcome!
Bulk configuration/import - see "Spreadsheet-based Configuration Import Tool" at http://resourcecenter.controlmicrosystems.com/pages/viewpage.action?pageId=40535951
Mapping - read the release notes for ClearSCADA 2017 at: https://schneider-electric.box.com/shared/static/bct2w7pxt6koqfl0tcoxp0fzwzgn55j3.pdf
Best regards.
Reply From User: ape, posted: 2019-03-01 14:21:50
Thank you for this informations.
For cartographie, i can't to display a real value in tooltip? it's possible?
have you ever used dream report for CS 2017R3?
Reply From User: sbeadle, posted: 2019-03-01 14:57:34
Yes, you can use the SQL in the User Query to display values (in colours) in the tooltips. The 2017 version release notes describe how.
Dream Reports can access the ClearSCADA historian - details are in their documentation.
Reply From User: ape, posted: 2019-03-02 06:35:19
Do you know why this query doesn 't work? i would like display synthes of active alarme count/acquit alarm count/alarm clean count on one display on tooltip
SELECT FULLNAME, FULLNAME || '
Alarmes : ' || AlarmSetCount(Value)
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, AlarmClearedCount
FROM CGROUP
WHERE
FULLNAME LIKE '%EU%' AND GISLOCATIONSOURCE = 1
ORDER BY AlarmSetCount, AlarmAcceptedCount, AlarmClearedCount
Reply From User: BevanWeiss, posted: 2019-03-03 21:30:37
What is AlarmSetCount(Value) supposed to be?
Do you instead just mean AlarmSetCount? (i.e. the property on the CGroup object type)
You should include the error message in these situations. In fact, I suspect that the error message would have told you exactly what the problem was.
Reply From User: ape, posted: 2019-03-04 05:44:28
indeed, the error message informs me that the request can not concatenate values of type string or integer. I have the following query on which I can not insert numerical values
SELECT FULLNAME, FULLNAME || '
Active:' || 'Acquitted:' || 'Disappeared:' as "TOOLTIP",
GISLOCATION- LATITUDE, GISLOCATION- LONGITUDE, WHEN CASE 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, AlarmClearedCount
FROM CGROUP
WHERE
FULLNAME LIKE '% EU%' AND GISLOCATIONSOURCE = 1
ORDER BY AlarmSetCount, AlarmAcceptedCount, AlarmClearedCount
Reply From User: sbeadle, posted: 2019-03-04 08:50:26
look at FORMATVALUE in the SQL help
Reply From User: ape, posted: 2019-03-04 09:20:16
Thank you very much it's ok !!!!
Reply From User: ape, posted: 2019-03-04 09:28:14
But i dont't understand this example query in the note.
i would like display on map synthese "Niveaux" of a group "EP" with 2 sites but it doesn't work. i dont find my error...
SELECT g.Id as "Id", g.FullName as "FullName",g.FullName || '
|| FormatValue (r.Niveaux '0.00') as"Tooltip",
g.GISLOCATION-LATITUDE as "GISLOCATION-LATITUDE", g.GISLOCATION-
LONGITUDE as "GISLOCATION-LONGITUDE",
case
when Niveaux 50 then (255 + cast( (100-Niveaux)/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.Id
WHERE g.FULLNAME LIKE 'EP.%'
Reply From User: sbeadle, posted: 2019-03-04 09:30:19
I think formatting messed that post up. Try the code format.
Reply From User: ape, posted: 2019-03-04 09:31:35
voir le code plus bas ......
Reply From User: ape, posted: 2019-03-04 11:04:01
i try to simplify the query but display doesn't work (identifier unknow).
This group for measure is local/EP/Site/variables/mesures/niveau
SELECT FULLNAME, FULLNAME ||'
' || FormatValue (Niveau.Currentvalue using '0.00') as "TOOLTIP",
GISLOCATION-LATITUDE, GISLOCATION-LONGITUDE,
FROM CGROUP
WHERE
FULLNAME LIKE '%EU%' AND GISLOCATIONSOURCE = 1
Reply From User: ape, posted: 2019-03-04 09:32:15
view code lower......
Reply From User: sbeadle, posted: 2019-03-04 10:17:16
Try testing your query in querypad (search in the help).
'
' || FormatValue (r.Niveau USING '0.00')
Quotes around
Add USING
What is r.Niveau - no field with this name exists
The JOIN links a point within the group
Reply From User: ape, posted: 2019-03-04 09:41:42
Sorry, i don't have seen that we can get a preview for the message..
Reply From User: ape, posted: 2019-03-04 10:03:50
SELECT g.Id as "Id", g.FullName as "FullName",g.FullName ||
|| FormatValue (r.Niveau '0.00') as"Tooltip",
g.GISLOCATION-LATITUDE as "GISLOCATION-LATITUDE", g.GISLOCATION-
LONGITUDE as "GISLOCATION-LONGITUDE",case
when r.Niveau 50 then (255 + cast( (100-r.Niveau)/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.Id
WHERE g.FULLNAME LIKE 'EU.%'
Reply From User: sbeadle, posted: 2019-03-04 13:52:31
Your query is from the table CGroup (an object folder), but you are selecting a field (currentvalue) valid only on points, and with a table alias (Niveau) which does not exist. Is your point called Niveau and the top level group is EU?
Maybe try
`SELECT FULLNAME, FULLNAME ||'
' || FormatValue (p.Currentvalue using '0.00') as "TOOLTIP",
GISLOCATION-LATITUDE, GISLOCATION-LONGITUDE,
FROM CDBPoint p
WHERE
FULLNAME LIKE 'EU.%.Niveau' AND GISLOCATIONSOURCE = 1`
Reply From User: ape, posted: 2019-03-04 14:06:19
Ok i understand a little more...
What is "p." front of field currentvalue?
What is " p after CDBPoint?
I try this query but she doesn't work (unexpected identifier)
thank you for your patience ; i'm beginner and great opportunity comes with this software
Reply From User: ape, posted: 2019-03-05 16:02:19
It's OK!!!! so i can't to display 2 values on one tootlip..it's possible for
Reply From User: ape, posted: 2019-03-05 16:07:03
`SELECT FULLNAME, FULLNAME||'
' || Formatvalue (CurrentValueFormatted using '0.00') AS "TOOLTIP",
GISLOCATION-LATITUDE, GISLOCATION-LONGITUDE
FROM CDBPoint
Where fullname LIKE '%.Niveau%'`
Reply From User: sbeadle, posted: 2019-03-06 13:13:52
p is a table alias: https://www.sqlteaching.com/#!table_alias
