How can one convert a string to an array using SuiteQL? I get a string with โ1, 2, 3โ returned, but would want it as an array
m
michoel
12/05/2022, 11:21 AM
Split the result in javascript
string.split(', ')
f
Felix Divall
12/05/2022, 12:31 PM
Well, while that is possible, isnโt there a way to do this directly with SuiteQL? This means you need to do a search, convert and then search again - instead of just one search
w
Watz
12/05/2022, 12:58 PM
What do you want the result to look like? Do you want all other columns to be multiplied by the number of values in that csv-string?
Watz
12/05/2022, 12:59 PM
What kind of column are you querying? If it is a multiselect then there should be a mapping-table that you can join instead of getting the comma-separated list.