Query filtered by dynamic type value (array)

Discussions about product bugs & problems!
Note: This is no replacement for the Official ETM Support!
Search

Post Reply
3 posts • Page 1 of 1
uxout
Posts: 82
Joined: Wed Jul 20, 2016 12:07 pm

Query filtered by dynamic type value (array)

Post by uxout »

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,

User avatar
leoknipp
Posts: 2846
Joined: Tue Aug 24, 2010 7:28 pm

Re: Query filtered by dynamic type value (array)

Post by leoknipp »

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

uxout
Posts: 82
Joined: Wed Jul 20, 2016 12:07 pm

Re: Query filtered by dynamic type value (array)

Post by uxout »

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

Post Reply
3 posts • Page 1 of 1