Hello, I'm struggling with translations from custo...
# suitescriptt
t_gdb
10/28/2024, 11:48 AMHello, I'm struggling with translations from custom list values. I need to get the translations tables from custom list but I didn't succeed. I tried getSelectOptions / saved searches / queries. Someone has an idea how to do it ? ( Is it possible to run a saved search in suitescript with a different language ? )
watching following 1
t_gdb
10/28/2024, 11:11 PMI just found something very intriguing: you can search on the values of custom lists as if they were custom records
Copy code
var customlist_bb_useSearchObj = search.create({
type: "customlist_bb_use",
filters:
[
["internalidnumber","equalto","2"],
"AND",
["language","anyof","fr_FR","en_US","es_ES","it_IT"]
],
columns:
[
search.createColumn({name: "language", label: "Language"}),
search.createColumn({name: "name", label: "Name"}),
search.createColumn({name: "scriptid", label: "Script ID"}),
search.createColumn({name: "displaynametranslated", label: "Display Name (Translated)"})
]
});❤️ 1
e
erictgrubaugh
10/29/2024, 3:06 PMWhere did you find the field IDs you could use?
t
t_gdb
10/29/2024, 7:10 PMIn Analytics, the value returned by the custom list field is a custom record you can click on it (even if it's just a value, but in the backend of netsuite, it's also a simple custom record with a name). You can click on it, and from there you can perform a saved search and check all the columns.
e
erictgrubaugh
10/29/2024, 7:30 PMInteresting; would love it if these were captured in the Records Browser or Catalog, but I can't find them
t
t_gdb
10/29/2024, 7:40 PMyes it's not documented. I've found it a bit by chance.
e
erictgrubaugh
10/29/2024, 7:43 PMNice work; thanks for sharing!
11 Views