Query non-internal DPs

[Romero]

I am trying to show all the DPs that are not internal on a table to select different attributes on them and see overall information at a glance.
It may be pretty easy, but i am not finding a "clean" solution for this.

The only thing that comes to my mind is to put every non-internal DPT on the WHERE statement, however i know there must be a better solution. I do not want to change this panel every time a DPT is created and with a large number of DPT, the query could be 4-5 lines long.
On the FROM statement, i do not know how to exclude just the "_" before every internal DP.

What is the best practice to accomplish this task?

I am using WinCC OA 3.16 P015 on Windows.

[kilianvp]

You can try something like:

Code: Select all

WHERE _DPT NOT LIKE "_*"

to remove interal DPTs