There could be multiple items in an SO with the sa...
# suitescripta
acameron
06/19/2018, 6:01 PMThere could be multiple items in an SO with the same item instead of doing a qty, so I wanted the explicit line, which I have however it does not directly seem to corrolate with any way to load that line lol
j
jkabot
06/19/2018, 6:16 PMthe
linelinec
creece
06/19/2018, 6:17 PMi think you mean linesequence and line
creece
06/19/2018, 6:17 PM(respectively)
j
jkabot
06/19/2018, 6:18 PMi mean when you do record.getSublistValue({ sublistId: 'item', fieldId: 'item', line: 1 }), the
linea
acameron
06/19/2018, 6:18 PMI guess my frustration point is lack of naming consistency and implementation. Line references a uniqueid however loading by line is asking for its respective position. That doesnt seem logical
c
creece
06/19/2018, 6:19 PMline is a unique ID not the position. You can have lines 1,2,3 and then delete 3 and add a new line and that "new" 3 has a line of "4"
a
acameron
06/19/2018, 6:20 PMI understand, I guess all I'm asking is now I have that ID how do I use it to load the line lol
acameron
06/19/2018, 6:20 PMI can't seem any way to load the sl item with it
acameron
06/19/2018, 6:21 PMI can't not seem to directly identify which fieldId stores that value to load by it
j
jkabot
06/19/2018, 6:21 PMWhat I ended up doing is make my own column field to serve as a unique ID. I was frustrated at the lack of documentation / access to whatever fields netsuite uses internally.
jkabot
06/19/2018, 6:21 PMI generate a unique value for each item on beforeSubmit
a
acameron
06/19/2018, 6:21 PMI remember you mentioning that before and I may have to do that but I just hate reinventong the wheel it has to be here somewhere
acameron
06/19/2018, 6:43 PMFunny enough if you load a line using findSublistLineWithValue and the field item, then getCurrentSublistValue for line it returns the correct result. However if you attempt to findSublistLineWithValue using the field 'line' you get a -1 result.
j
jkabot
06/19/2018, 6:46 PMI wonder if it has something to do with whether findSublistLineWithValue uses strict equality or not
try passing a string instead of a number or vice versa
a
acameron
06/19/2018, 6:47 PMI passed it as a string, according to the records browser the line column is a text field, I can try parsing it as an integer though
j
jkabot
06/19/2018, 6:52 PMI just tested using the browser console, so at least in a client script findSublistLineWithValue worked with the
line Copy code
rec.findSublistLineWithValue({ sublistId: 'item', fieldId: 'line', value: '1' }) // output: 0a
acameron
06/19/2018, 6:59 PMvar lineTest = soRecord.findSublistLineWithValue({
sublistId: 'item',
fieldId: 'line',
value: lineid
});
acameron
06/19/2018, 6:59 PMUE doesnt seem to work, and I verified the value of lineid was 3
acameron
06/19/2018, 6:59 PMresult is -1
acameron
06/19/2018, 7:00 PMI did try with parseInt(lineid) just for giggles too
j
jkabot
06/19/2018, 7:01 PMdoes getSublistValue({ sublistId: 'item', fieldId: 'line', line: idx }) return 3 for any idx?
a
acameron
06/19/2018, 7:01 PMits just not consistent behavior between UE and CS
acameron
06/19/2018, 7:02 PMI did this but yea:
var lineNumber = soRecord.findSublistLineWithValue({
sublistId: 'item',
fieldId: 'item',
value: item
});
var lineNum = soRecord.selectLine({
sublistId: 'item',
line: lineNumber
});
var wrxLine = soRecord.getCurrentSublistValue({
sublistId: 'item',
fieldId: 'line'
});
acameron
06/19/2018, 7:02 PMwrxLine returns the correct result of 3
acameron
06/19/2018, 7:02 PMWhich I then now have to do this: if(lineid == wrxLine){
acameron
06/19/2018, 7:02 PMOf course it wont work if there is more than one items of the same thing on a so
acameron
06/19/2018, 7:02 PMbleh
acameron
06/19/2018, 7:03 PMSorry I don't know how to format the code in slack lol
j
jkabot
06/19/2018, 7:03 PMthat's quite frustrating netsuite
jkabot
06/19/2018, 7:03 PMyou use backticks `
jkabot
06/19/2018, 7:03 PMtriple backticks above and below for blocks of code
a
acameron
06/19/2018, 7:03 PM Copy code
if(lineid == wrxLine){acameron
06/19/2018, 7:04 PMBrilliant, thanks lol. At least something works 😛
j
jkabot
06/19/2018, 7:04 PMbut it sounds like if calls to getXXXvalue work for the
linea
acameron
06/19/2018, 7:05 PMI was thinking that, but another sublist loop sounds like a heavy hit on performance...
acameron
06/19/2018, 7:05 PMI wonder how much of their API is looping half the time
j
jkabot
06/19/2018, 7:05 PMi'm sure findSublistLineWithValue is already a loop
a
acameron
06/19/2018, 7:05 PMVery true lol
acameron
06/19/2018, 7:05 PMGood plan I'll go whip that up in a lib
acameron
06/19/2018, 7:05 PMthanks!
j
jkabot
06/19/2018, 7:05 PMbut honestly in my experience in-memory code execution is never the source of performance latency
jkabot
06/19/2018, 7:06 PMit's always database i/o like searches or record loading
jkabot
06/19/2018, 7:06 PMor http calls
a
acameron
06/19/2018, 7:06 PMWith NS for sure. The lag can be pretty brutal at times
j
jkabot
06/19/2018, 7:06 PMthe in-memory sublist is pretty much an array that netsuite hides behind a byzantine API
a
acameron
06/19/2018, 7:07 PMI would hate to be a guy that works AT Netsuite as an engineer 😕
j
jkabot
06/19/2018, 7:07 PMi'm not sure if there's any overhead using "dynamic mode" calls like selectLine
jkabot
06/19/2018, 7:08 PMbut i wouldn't sweat looping and reading values
jkabot
06/19/2018, 7:08 PMyeah lol
c
creece
06/19/2018, 7:08 PMdynamic mode can add slight overhead but its not gonna matter for such small datasets
j
jkabot
06/19/2018, 7:09 PMif we are seeing the customer-facing side (which you'd normally want to be at least a little consistent) who knows what things are like internally
c
creece
06/19/2018, 7:14 PMI just imagine a lot of shitty java code
a
acameron
06/19/2018, 7:43 PMThanks for the help guys, I have this fixed now with my own lookup function. What a pita. I have never seen a variable name overlap so poorly in such an expensive application before 😕
c
creece
06/19/2018, 7:44 PMall good glad you got it working
2 Views