SIMATIC WinCC Open Architecture Forum

Posted: **Wed Jan 17, 2024 6:08 pm**

Hello,
I would like to know if it is possible to filter a query with a dynamic element :

Example :
SELECT '_online.._value' FROM '*' WHERE '_online.._value' == ?
What should i write instead of '?' if i want to get elements with value dyn_int (0, 0, 0, 0) ?

Best regards,

Posted: **Fri Jan 19, 2024 12:43 pm**

I did some tests and it looks like filtering for a dyn array of values is not possible within a query string.
Take into account that the FROM statement must be as strict as possible to optimize the execution time for the query.

Best Regards
Leopold Knipp
Senior Support Specialist

Posted: **Mon Jan 22, 2024 9:16 am**

Is it something you will add in WinccOA in the future ?

SIMATIC WinCC Open Architecture Forum

Query filtered by dynamic type value (array)

Query filtered by dynamic type value (array)

Re: Query filtered by dynamic type value (array)

Re: Query filtered by dynamic type value (array)