SQL Query to extract out the description along with value

[udit.soota]

Hi,

I'm using a http server to query values from para and was wondering if there was a way to query datapoint descriptions.

I have tried the following query, but it gives out an error.

Query: SELECT '_online.._value' FROM 'XYZ.state.zyx:_common'

Thanks in advance for your help.

[leoknipp]

The _common config is a "virtual" config. In the PARA module it is displayed as a config but it cannot be accessed like a "real" config. As the information is not stored on a config + attribute you cannot use it in a dpQuery(). With the keyword _COMMENT for the WHERE condition you can filter for a DP description.
If you want to read the description for a DP element you have to use the function dpGetDescription().

Best Regards
Leopold Knipp
Senior Support Specialist

[buec]

Also dpGetAllComments() coud be useful, if you have to filter comments.

[gschijndel]

I would not advise a deprecated function, but use the replacement: dpGetAllDescriptions