When I use the CONTAINS function in structure with a hard coded array as the list to check against it works, but when the array is from a function it doesn't. My goal is to build an array (array2) that does not have any of the elements from another array (array1)
Ex:
array1 = A, B, C
array2 = if the values being checked are A, B, D, then I only want the value of D to be in the array2 (since A and B were in array1)
This works
values#subtree{if field1 = somevalue and contains(array ("A", "B", "C"), component) = 0 : component} ---> returns just D
This does not work
values#subtree{if field1 = somevalue and contains(values#subtree{if field2 = someothervalue : component}, component) = 0 : component} --> returns A, B, D
Is this a bug in the Contains function? Is there another way to do this?
I've verified that the inner aggregate function values#subtree{if field2 = someothervalue : component} returns the correct values.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.