How can I query all data points that have a specific value in their dyn_string element?

[i.mak]

Hello!

I have data points that, among others, have an element of type dyn_string. Let's call it "colors".
Let's imagine that one data point has "colors": [green, red, blue]. The other has [orange, purple]. The third one has [red, white, black, yellow].

I want to use dpQuery() function. What SQL statement should I use to select data points that have "red" in their "colors" element?

[leoknipp]

Querying data with a specific value in the original value is possible with the following statement.
The example is querying for datapoint elements starting with "ExaDP_**" and online values containing "yellow".

SELECT '_online.._value' FROM 'ExaDP_**' WHERE '_online.._value' LIKE "*yellow*"

Best Regards
Leopold Knipp
Senior Support Specialist

[i.mak]

Hello, Leopold!
Thank you very much!