Schneider Electric support forum about installation, configuration, integration and troubleshooting of EcoStruxure Geo SCADA Expert (ClearSCADA, ViewX, WebX).
Send a co-worker an invite to the portal.Just enter their email address and we'll connect them to register. After joining, they will belong to the same company.
You have entered an invalid email address. Please re-enter the email address.
This co-worker has already been invited to the Exchange portal. Please invite another co-worker.
Please enter email address
Send InviteCancel
Invitation Sent
Your invitation was sent.Thanks for sharing Exchange with your co-worker.
Link copied. Please paste this link to share this article on your social media post.
Posted: 2019-11-0612:27 PM. Last Modified: 2023-05-0312:27 AM
[Imported] Stuck on sql code
>>Message imported from previous forum - Category:General Items<< User: ROVSCADAENGINEER, originally posted: 2019-02-20 22:40:26 Id:369 Ok so I am stuck on some SQL code as I am trying to write to the registry a name for the embedded list on the mimic so I can edit the filters on the list through click buttons. the code which is working on the query option is below:
SELECT RECORDTIME, SEVERITY, SOURCE, MESSAGE, USER, CATEGORY, FOREGROUND, SEQNO, COMMENTNO, ID FROM CDBEVENTJOURNAL WHERE SOURCE LIKE '%Overflow Float%' AND ( RECORDTIME BETWEEN { OPC 'H-10D' } AND { OPC 'H' } ) AND SEVERITY = 'Critical'
Yet the code that I put in the animation sql expression is similar to another working code on another embedded list yet does not work. can anyone see where I may be going wrong. scada keeps saying that ) is expected. yet I cannot figure it out.
'SELECT RecordId, SeverityDesc, RecordTime, Message, User, Category, Foreground, SeqNo, CommentNo,id FROM CDBEVENTJOURNAL '+ REGISTRY( 'OverflowFloatsList', 'WHERE source LIKE '%Overflow Float%' and ( RecordTime BETWEEN { OPC ''H-24H'' } AND { OPC ''H'' } )') and SEVERITY = 'Critical'
I am going to try the code in query pad and see if I get a more particular analysis.
Link copied. Please paste this link to share this article on your social media post.
Posted: 2019-11-0612:28 PM
>>Responses imported from previous forum
Reply From User: ROVSCADAENGINEER, posted: 2019-02-20 23:34:00 I got it working
'SELECT RECORDTIME, SEVERITY, SOURCE, MESSAGE, USER, CATEGORY, FOREGROUND, SEQNO, COMMENTNO, ID FROM CDBEVENTJOURNAL '+ REGISTRY( 'smsLists', ' WHERE SOURCE LIKE ''%Overflow Float%'' AND ( RECORDTIME BETWEEN { OPC ''H-10D'' } AND { OPC ''H'' } ) AND SEVERITY = ''Critical'')')
Reply From User: du5tin, posted: 2019-03-06 17:07:00 Yeah... escape characters are definitely needed for animations. :smiley: