Just a heads up: On March 24, 2025, starting at 4:30pm CDT / 19:30 UTC, the site will be undergoing scheduled maintenance for a few hours. During this time, the site might be unavailable for a short while. Thanks for your patience.
×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.