RE: Item search returning incorrect value
I’m currently working on a Suitelet script in SS2.0 and am encountering an issue with returned search values. I’ve seen the same issue before in SSP, assumed it was a bug and simply worked around it – but wouldn’t expect to see the same with a regular Suitescript release.
I have an item saved search set up in the UI, which includes the column “Name”. This works fine and returns our product’s item code.
If I load the same search in SS2.0, result.getValue(‘itemid’) is returning the value from storedisplayname instead.
I tried dumping a JSON.stringify on the search result and the raw search output displays the same issue – and doesn’t contain the item code anywhere.
Is there some quirk to item searches I need to know about?
Is the value (including the item code) you are expecting inside the field ITEM NAME/NUMBER? Which is basically the “itemid” column. I tried this on my test account and was able to pull what’s inside the said field. I did not get the Display Name column. My saved search is pretty basic, no formulas or anything. And I used the snippet below.
var mySearch = search.load({
id: 'customsearch67_2'
});
mySearch.run().each(function (result) {
itemName = result.getValue({
name: 'itemid'
});
console.log(itemName);
return true;
});
Is the item code the only thing missing? I have experience where UI Saved Search combines certain data like Item Code + Item Name, but when getting the data through scripting, it will only show one or the other. One suggestion is to use formula, simply put {itemid}, it should display the same thing, and use this formula column in the script.
Hope it helps.
dbarnett
can you post your item saved search code? just tried in a demo account and am getting the expected result here.