[Imported] Point Configurations

[sbeadle]

>>Message imported from previous forum - Category:ClearSCADA Software<<
User: ROVSCADAENGINEER, originally posted: 2019-04-17 23:13:04 Id:410
I am wanting to see the point configuration for several datapoints on the server. One being that the alarm severity is set to 1000 being critical across several points. Yet I can only seem to raise this column on the CDBCONFIGCHANGES in the columns of FieldName. If I run a query on the history I can see the old and new value. I am just wanting to see the current configuration of each point. I know you can be crafty with this by using join function etc. However is there a way I can just query the current configuration of a large set of points?

[sbeadle · Accepted solution]

>>Responses imported from previous forum

Reply From User: dmercer, posted: 2019-04-17 23:25:42
If you're trying to do this with points for different types, you would look in the schema for a common type that they all inherit from that includes the fields that you want. Eg. for any simple digital point you can use CPointDigital. I can't tell you what your WHERE clause should be since I don't know how your database is set up, but I imagine that you want to do something like this:

`SELECT FullName, State0Severity, State0SeverityType, State1Severity, State1SeverityType
FROM CPointDigital
WHERE FullName LIKE '%Something%'`

Reply From User: ROVSCADAENGINEER, posted: 2019-04-18 00:11:52
Your a saviour dean. Thanks!

Reply From User: adamwoodland, posted: 2019-04-28 22:26:13
Also note that if you can't find a common parent table, you can also use UNION to merge tables. There are a couple of ways to do this, i.e.

SELECT [Columns] FROM Table1 UNION Table2

In which case columns need to exist in both tables, or the more flexible but more cumbersome:

(SELECT [Columns] FROM Table1) UNION (SELECT [Columns] FROM Table2)

The number of columns need to match, and the data type for the column also needs to match, but you can also just specify '' or 0 to 'fill the gap'