Hi. I want to get itemId from item group result of...
# suitescriptc
Core
09/03/2023, 4:20 PMHi. I want to get itemId from item group result of SavedSearch list in map/reduce script. Maybe it's easier to explain with images. Please let me know if someone knows about the solution
a
Anthony OConnor
09/03/2023, 5:06 PMLooks like you started to do this with itemlList? but you're using
getvaluegetValuedata Copy code
if (result.getValue(columns[1]) !=0) {
data.push({
itemId: result.getValue(columns[0]),
itemName: result.getText(columns[0]),
qty: result.getValue(columns[1]),
amount: result.getValue(columns[2])
});
}c
Core
09/03/2023, 5:17 PMthanks for your replay. I already tried with getValue() but it didn't return itemID. Because as you can see the images, Item field is a itemlist not a single item.
a
Anthony OConnor
09/03/2023, 5:21 PMyeah ok let me try again, I don't use columns[x] and getValue works differently if you pass in a a column instead of a field name etc.
Anthony OConnor
09/03/2023, 5:23 PMumm what i see from the images (i think) its not clear since you didn't provide everything I would need.
is that they ARE all the same item, they're just grouped by item on the search?
the internal ID of every entry on the drill down is 6377630
Anthony OConnor
09/03/2023, 5:26 PMis your data object getting anything added to it correctly?
Anthony OConnor
09/03/2023, 5:26 PMare you getting any error messages?
Anthony OConnor
09/03/2023, 5:28 PMif qty and amount are working then should be ok to leave those. using the column references.
Copy code
if (result.getValue(columns[1]) !=0) {
data.push({
itemId: result.getValue({
name: 'item',
summary: search.Summary.GROUP
}),
itemName: result.getText({
name: 'item',
summary: search.Summary.GROUP
}),
qty: result.getValue(columns[1]),
amount: result.getValue(columns[2])
});
}c
Core
09/03/2023, 5:41 PMthank you. there was my spelling fault.
now everyting is working well. good weekend
👍 1
e
ec
09/03/2023, 8:10 PMCurious, was this in the getinputdata stage or in map or reduce?
c
Core
09/05/2023, 12:44 AMit was in getInputData stage
Core
09/05/2023, 12:45 AMIf you want a whole code, I can provide you
e
ec
09/05/2023, 3:29 AMno, fine. was just curious. all good - you got it straightened out
3 Views