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?
I tried copying the above code snippet into a suitelet and found it worked OK. I then realised that the difference was that I’m running mine “Available without login” and testing on a public facing URL (it’s for a data feed integration).
Running my script as administrator, the correct {itemid} values come out. Running it as anything else, I get {storedisplayname} values instead – even using our “superuser” role, which is basically administrator with the mandatory 2FA customization permissions removed. From the deployment screen, I can run the same script and output a CSV with different column values depending on whether I use the UI or external URL links.
It’s obviously a permissions issue, but I presume also an underlying bug somewhere. I can’t believe Netsuite intended it to swap values rather than return an error.
Glad you were able to sort it out. This definitely sounds like a bug to me as well.
dbarnett
can you post your item saved search code? just tried in a demo account and am getting the expected result here.