Posibility to query address configs via SQL statement

Find and share HowTos to various installations / configurations!
3 posts • Page 1 of 1
daniel.ponader
Posts:34
Joined: Tue Jan 10, 2012 1:40 pm

Posibility to query address configs via SQL statement

Post by daniel.ponader »

Dear All

Is there a possbility to query address configs of DPEs? Of course it's possible to make a query like this:

SELECT '_address.._active' FROM 'DP_1_PB'

In this case I expected to get a list with DPEs which have an address config but i got a list of all DPEs of the selected DP.

Where is the mistake?

Thanks in advance.

Daniel

leoknipp
Posts:2928
Joined: Tue Aug 24, 2010 7:28 pm

Re: Posibility to query address configs via SQL statement

Post by leoknipp »

Hello,

querying _address-configs is not possible.
The query is answered by the event-manager and the _address-config is only known by the driver. Also the configs _smooth, _msg_conv and _cmd_conv are only known by the driver. Therefore these configs can also not be used in a query.

If you want to get a list of configured (active) adresses you can use the elements .AD.* at the internal driver-datapoint (_DriverX, dp-type _DriverCommon).
For details please have a look at the online help: Reference tables --> Internal datapoint types --> _DriverCommon

Best Regards
Leopold Knipp
Senior Support Specialist

daniel.ponader
Posts:34
Joined: Tue Jan 10, 2012 1:40 pm

Re: Posibility to query address configs via SQL statement

Post by daniel.ponader »

Thank you very much.

Good advice, works perctly!

3 posts • Page 1 of 1