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
84865members
354354posts

Get Telemetry Data without "null"

EcoStruxure Geo SCADA Expert Forum

Find out how SCADA systems and networks, like EcoStruxure Geo SCADA Expert, help industrial organizations maintaining efficiency, processing data for smarter decision making with IoT, RTU and PLC devices.

Solved
abdullah123456789
Lieutenant JG
Lieutenant JG
0 Likes
4
306

Get Telemetry Data without "null"

Hello,

 

I created an SQL Query in Geo SCADA Expert 2021 as in the below.

 

SQL.PNG

 

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?

 

14367827-9709-4ea5-a09a-0a1092c1c32a.jpeg


Accepted Solutions
AndrewScott
Commander
Commander
0 Likes
1
298

Re: Get Telemetry Data without "null"

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, Lead Engineer, AVEVA

See Answer In Context

4 Replies 4
AndrewScott
Commander
Commander
0 Likes
1
299

Re: Get Telemetry Data without "null"

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, Lead Engineer, AVEVA
BGedco2022
Lt. Commander
Lt. Commander
0 Likes
1
275

Re: Get Telemetry Data without "null"

"select x,y, z

from tableName

where x is not null"

To filter a results without null values 

 

OR another filter

 

where x >= 0

AndrewScott
Commander
Commander

Re: Get Telemetry Data without "null"

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, Lead Engineer, AVEVA
abdullah123456789
Lieutenant JG
Lieutenant JG
0 Likes
0
186

Re: Get Telemetry Data without "null"

Thanks for help. It worked.