https://netsuiteprofessionals.com logo
Join Slack
Powered by
Anyone know any way through SuiteQL or SavedSearch...
# suiteql
j
Anyone know any way through SuiteQL or SavedSearch or …. anything … to get the ORDER of the Item Options found at 
/app/common/custom/itemoptions.nl
? This order controls what order they appear in on the transaction item line. I already have a M/R script running to store the connection between the ItemOptions and their Items (the only way I found to do this is to literally do a record.load on each item and retrieve the value in the multiselect 
itemoptions
field) so I know from my DB which options below to which items, but now I need to know what order to list them in…. Pinging @tdietrich just in case….
a
I don't understand what you mean by "this order controls what order they appear in on the transaction item line"
as far as i can tell the options aren't referenced on the item lines directly, because the item reference itself on the line would be a matrix child, so the options would be there, not on the item line?
oh n/m they ARE there, they're just not in alpha order like everything else... weird
i'm getting flashbacks of item matrix nonsense from years ago when I worked on suite commerce, sorry I can't help.
hmm is this the order? the itemoptions array on the item record?
j
dumb question (I’m sleepy) but how did you get that second screenshot?
a
NS field explorer chrome extension
i think it just does a record.toJSON and lets you keyword filter on the resulting object
j
ah no, that’s what I’m using now to map the IOs to Items, but it doesn’t give the actual order how they’d appear when you using the item on a transaction
for me it comes in alphabetical order by name of IO
4 Views
Open in Slack
PreviousNext
Powered by