Welcome to the new Schneider Electric Community

It's your place to connect with experts and peers, get continuous support, and share knowledge.

  • Explore the new navigation for even easier access to your community.
  • Bookmark and use our new, easy-to-remember address (community.se.com).
  • Get ready for more content and an improved experience.

Contact SchneiderCommunity.Support@se.com if you have any questions.

Close
Invite a Co-worker
Send a co-worker an invite to the Exchange portal.Just enter their email address and we’ll connect them to register. After joining, they will belong to the same company.
Send Invite Cancel
84541members
353795posts

Wrong result in Machine SCADA Expert SQL query.

AVEVA Plant SCADA Forum

A support forum for AVEVA Plant SCADA (formerly Citect SCADA). Share new and exciting product information, connect, learn, and collaborate with the ecosystem of Plant SCADA Users. AVEVA Plant SCADA a reliable, flexible and high-performance Supervisory Control and Data Acquisition software solution for industrial process customers. This forum is to connect, share, learn and collaborate new and exciting product information. Feel free to join and share to your Ecosystem of Plant SCADA Users.

Solved
jthyge
Ensign
Ensign

Wrong result in Machine SCADA Expert SQL query.

Hello

 

I am making a SQL query to a MySQL database. 

 

When I run the query in MySQL, I get the right result. 

 

When I send the SQL statement from Machine SCADA Expert, the result is not right. 
It is like the lase WHERE clause is ignored. 

 

This is the Query: 

SELECT SUM(Minute_In_State) From
   (SELECT
   Time_Stamp,
   State,
   TIMESTAMPDIFF(SECOND, LAG(Time_Stamp) OVER(ORDER BY Time_Stamp), Time_Stamp)
   AS Minute_In_State
   FROM db.xyz_1_state
   ORDER BY Time_Stamp) AS T
Where State = 1;

 

Any suggestion why the result is different, when sent from Machine SCADA Expert?


Accepted Solutions
BevanWeiss
Spock
Spock
0 Likes
1
962

Re: Wrong result in Machine SCADA Expert SQL query.

This is the Geo SCADA Expert forum.  So you're not that likely to get great results looking for Machine SCADA Expert info here (since they are different products).

 

I think you wanted this forum instead: https://community.exchange.se.com/t5/Industry-Automation-and-Control/bd-p/industry-automation-contro...


Lead Control Systems Engineer for Alliance Automation (VIC).
All opinions are my own and do not represent the opinions or policies of my employer, or of my cat..

See Answer In Context

2 Replies 2
BevanWeiss
Spock
Spock
0 Likes
1
963

Re: Wrong result in Machine SCADA Expert SQL query.

This is the Geo SCADA Expert forum.  So you're not that likely to get great results looking for Machine SCADA Expert info here (since they are different products).

 

I think you wanted this forum instead: https://community.exchange.se.com/t5/Industry-Automation-and-Control/bd-p/industry-automation-contro...


Lead Control Systems Engineer for Alliance Automation (VIC).
All opinions are my own and do not represent the opinions or policies of my employer, or of my cat..
jthyge
Ensign
Ensign
0 Likes
0
957

Re: Wrong result in Machine SCADA Expert SQL query.

Oh Ok. 

Thanks!!