5/8/2019 8:50 AM | |
Joined: 4/20/2018 Last visit: 12/2/2020 Posts: 4 Rating: (0) |
Dear All, I am using Wincc advance scada for one of my project. So in that I am storing the datas to SQL server by using script language but I need to filter the datas from the SQL and I need to show the filtered datas in the SCADA. Filtering will be based on the dates, Shift base from the SCADA screen So any body know How to do this? Please help me........... ------------------------------------------------------------------------------------------ |
Last edited by: Jen_Moderator at: 05/08/2019 11:26:53New subject after splitting |
|
5/8/2019 9:44 AM | |
Joined: 7/5/2013 Last visit: 4/26/2024 Posts: 3076 Rating: (505) |
Hello slijnmi,
filtering is done with the SQL query. The following link might help: How do you access an SQL database in WinCC Runtime Advanced using a script? Regards, Frink |
Pi is exactly three! |
|
This contribution was helpful to1 thankful Users |
4/20/2023 5:53 AM | |
Joined: 8/3/2009 Last visit: 4/26/2024 Posts: 12869 Rating: (1641)
|
Hello Noorie How to read out Data from SQL SErver is already posted above If you need to write also to CSV file then you can use a Script: https://support.industry.siemens.com/cs/ww/en/view/106501825 If you do not have WinCC Advanced RT or something in your usecase is different then please open an new own topic Bye Murof |
If this Information really helps, you could use the Rate function |
|
Follow us on