I want to find out the diff between two arrays and list them out with DQL.
Something like | fields array1, array2, diff
Diff needs to be calculated but not sure how to do that.
Here I have
array 1 = [“apple”, “orange”, “lychee”, “grapes”, “pineapple”]
array 2 = [“apple”, “orange”, “lychee”]
Then I would like diff result to be [“grapes”, “pineapple”].
How can I get diff through DQL?
thanks.
