How can I get key value pairs from a multi select ...
# suitescriptk
Kris Wood
04/23/2021, 2:09 AMHow can I get key value pairs from a multi select field in a SuiteQL query result? I've tried a bunch of things and only get a list of internal IDs and none of the text values.
b
battk
04/23/2021, 2:31 AMbattk
04/23/2021, 2:38 AMyou may just want to live with caching the names of the subsidiaries if you want to make your code robust enough to handle commas in the name of the subsidiary
m
michoel
04/23/2021, 3:35 AMThere should be a mapping table that you can join
michoel
04/23/2021, 3:38 AME.g.
k
Kris Wood
04/23/2021, 7:53 PM@battk that worked perfectly thank you!
Kris Wood
04/23/2021, 7:54 PM@michoel Where did you find that screen? I've never seen it before, especially with the SQL with the little (i) button
Kris Wood
04/23/2021, 7:55 PMI ended up using BUILTIN.DF for Subsidiary and Parent, and using a SQL join to get currency.name 🙂
m
michoel
04/25/2021, 11:37 PM@Kris Wood that's from the Records Catalog
3 Views