Hi all! Ok I'm stumped. What are the column header...
# suitescriptk
Kris Wood
08/03/2023, 10:19 PMHi all! Ok I'm stumped. What are the column headers for custom segment value rows in SuiteScript?
Kris Wood
08/03/2023, 10:19 PMI can get the values out with SuiteQL but it doesn't give me the column names
c
Clay Roper
08/03/2023, 10:50 PM@Kris Wood How are you getting the values out with SuiteQL?
k
Kris Wood
08/03/2023, 11:09 PM Copy code
const sql = 'SELECT * FROM customrecord_cseg_myproject';
const keys = ['owner', 'isinactive', 'scriptid', 'parent', 'recordid', 'lastmodified', 'created', 'name', 'externalid', 'id'];
let csegArr = [];
query.runSuiteQLPaged({ query: sql, pageSize: 10 }).iterator().each(page => {
page.value.data.iterator().each(row => {
csegArr.push(keys.reduce((acc, key, i) => {
acc[key] = row.value.values[i];
return acc;
}, {}));
return true;
});
return true;
});Kris Wood
08/03/2023, 11:11 PMThere's probably a nicer way but I haven't found it yet
c
Clay Roper
08/04/2023, 12:03 AMAre there columns aside from
'owner', 'isinactive', 'scriptid', 'parent', 'recordid', 'lastmodified', 'created', 'name', 'externalid', 'id'Clay Roper
08/04/2023, 12:05 AMHow many values do you expect to return on a custom segment? Tens, hundreds, thousands?
k
Kris Wood
08/04/2023, 12:09 AMno, I found them before you answered. 🙂
😄 1
Kris Wood
08/04/2023, 12:09 AMthousands of rows
Kris Wood
08/04/2023, 12:10 AMnot my business requirements choice on that one. I'm just making it work
Kris Wood
08/04/2023, 12:13 AMThey want to upload a CSV of values for the segment, inactivate any existing ones that are not in the csv, add any net new ones from the CSV to the segment
Kris Wood
08/04/2023, 12:14 AMso first I needed to get IDs and names from the existing values in the segment, and thus needed to know which column numbers they were in
c
Clay Roper
08/04/2023, 12:21 AMAh, I gotcha. I might do something like the following, but I bet what you have above works just fine!
Copy code
const sql = `
SELECT
owner,
isinactive,
scriptid,
parent,
recordid,
lastmodified,
created,
name,
externalid,
id
FROM customrecord_cseg2
`
const results = [];
query.runSuiteQLPaged({ query: sql, pageSize: 10 }).iterator().each(page => {
results.push(...page.value.data.asMappedResults())
});k
Kris Wood
08/04/2023, 12:22 AMthat would work, too! I just didn't know the column headers when I started coding today so this is just where I ended up
c
Clay Roper
08/04/2023, 12:22 AMI know how that goes for sure! Best of luck to you
k
Kris Wood
08/04/2023, 12:36 AMThanks!
28 Views