Can't make CDA work with 1-element StringArray
I reccently updated CDE to the latest version. Now, I have a query that goes something like:
SELECT Country, SUM(Sales)
FROM myTable
WHERE Region IN (${region})
GROUP BY Country;
Before the update, my region variable in CDE could have a value of "A1" (a string), or [["A1"], ["A2"], ["A3"]] (an array), and work flawlessly with the query above.
But now, CDA accepts neither "A1" nor [["A1"]] as a valid value and my query fails.
Seems like the only way I can pass a 1-element string array to CDA from CDE is passing the region variable with a value of [["A1"], null].
Does anyone know a better way to make this work? Somehow doing that null-ended array does not feel like a real solution to me...
Regards
Reply With Quote
