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.
Online forums and learning are now in one easy-to-use experience.
By continuing, you accept the updated Community Terms of Use and acknowledge the Privacy Policy. Your public name, photo, and achievements may be publicly visible and available in search engines.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.