- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
Link copied. Please paste this link to share this article on your social media post.
Posted: 2022-08-15 04:20 AM . Last Modified: 2023-05-02 11:53 PM
Get Telemetry Data without "null"
Hello,
I created an SQL Query in Geo SCADA Expert 2021 as in the below.
When I exported the Telemetry Signal List after creating the query, I saw "null" data. This "null" data should not be displayed
I did some filtering in this screen in the below but I couldn't be successful. Which filter i must choose?
- Labels:
-
ViewX
Link copied. Please paste this link to share this article on your social media post.
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
Link copied. Please paste this link to share this article on your social media post.
Posted: 2022-08-15 04:52 AM
To filter the resultset of an SQL query based on a column not being NULL use the <column> IS NOT NULL syntax:
https://www.w3schools.com/sql/sql_null_values.asp
The current value of a point is NULL when it has never been updated and the OPC quality will be 'waiting for initial data'.
Andrew Scott, R&D Principal Technologist, AVEVA
Link copied. Please paste this link to share this article on your social media post.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
Link copied. Please paste this link to share this article on your social media post.
Posted: 2022-08-15 04:52 AM
To filter the resultset of an SQL query based on a column not being NULL use the <column> IS NOT NULL syntax:
https://www.w3schools.com/sql/sql_null_values.asp
The current value of a point is NULL when it has never been updated and the OPC quality will be 'waiting for initial data'.
Andrew Scott, R&D Principal Technologist, AVEVA
Link copied. Please paste this link to share this article on your social media post.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
Link copied. Please paste this link to share this article on your social media post.
Posted: 2022-08-15 10:13 PM . Last Modified: 2022-08-16 11:31 PM
"select x,y, z
from tableName
where x is not null"
To filter a results without null values
OR another filter
where x >= 0
Link copied. Please paste this link to share this article on your social media post.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
Link copied. Please paste this link to share this article on your social media post.
Posted: 2022-08-16 02:00 AM
The correct syntax to exclude NULL values is:
SELECT X, Y, Z FROM TABLE WHERE X IS NOT NULL
The following syntax will not work as the SQL standard specifies that the comparison operators (=, <>, >= etc.) cannot be used to test for NULL (see https://www.w3schools.com/sql/sql_null_values.asp😞
SELECT X, Y, Z FROM TABLE WHERE X <> NULL
Andrew Scott, R&D Principal Technologist, AVEVA
Link copied. Please paste this link to share this article on your social media post.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
Link copied. Please paste this link to share this article on your social media post.
Posted: 2022-08-19 07:26 AM
Thanks for help. It worked.
Link copied. Please paste this link to share this article on your social media post.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
Link copied. Please paste this link to share this article on your social media post.
Posted: 2023-12-13 05:03 AM
To refine the resultset of an SQL query by excluding rows where a specific column is NULL, employ the syntax <column> IS NOT NULL. For detailed information, refer to the following link:
https://www.w3schools.com/sql/sql_null_values.asp.
https://iqratechnology.com/academy/sql-training/sql-null/
In the context of point values, a NULL signifies that the point has not been updated, and the associated OPC quality is designated as 'waiting for initial data.
Link copied. Please paste this link to share this article on your social media post.