Hey all, Has anyone used findSublistLineWithValue to find a checked checkbox?

I'm getting a -1 result for 'true' and true parameters.

'T'

Sorry, try 'T' instead of True etc

Yeah... I really didn't want to try that.

I thought SS2.0 completely got rid of T/F for checkboxes. But you're correct. 'T' works

findSublistLineWithValue must use getText instead of getValue for it's comparison.

I think NetSuite just forgot to wrap T/F for a good fraction of the API, which can make it confusing. IIRC search.lookupFields and record.submitValues uses T/F

anyone have experience scripting around the the Single Sign-On Only role? We utilize this role to allow customers to access a “billing center” where they can apply payments to open Invoices. There’s a User Event behind this that is supposed to call out to an external system once the Invoice is paid in full. It fires for internal roles, but does not seem to work for SSO Only. Are there limitations to how this role works?

anyone know if there's a datetime field somewhere that's set when an item fulfillment's status is changed to shipped? things like 'ship date' 'actuate ship date' etc. aren't populated when I try to perform a search on item fulfillments so I'm drawing a bit of a blank

In a map/reduce, can you have getInputData do a paged search, and have each page of results be a separate map stage?

Can we wrap up html code in client script ?

@Kevin sort of. What do you want to do with that HTML?

you can put HTML in an inline HTML field or a rich text field, for example

@Kris Wood the getInputStage can return a reference to a saved search or your own array of results but it is a unique return, you must need to create your own array from the paged search and then each line will be a separate map stage

@eminero yeah, I was trying to get some extra governance units out of it

I've got 13,000 records to update and I want to do it in a single run if possible

some of my search result columns are truncating with a '(more...)' at the end of the field, even though that text is not in the field when I look at the record - anyone see this before?

@Kris Wood For the

getInputData stage

, you write a function that returns an object that can be transformed into a list of key/value pairs. For example, if your function returns a search of NetSuite records, the system would run the search. The key/value pairs would be the results of the search: Each key would be the internal ID of a record. Each value would be a JSON representation of the record’s field IDs and values. For the

map stage

, you can optionally write a function that the system invokes one time for each key/value pair. If appropriate, your map function can write output data, in the form of new key/value pairs. If the script also uses a reduce function, this output data is sent as input to the shuffle and then the reduce stage. Otherwise, the new key/value pairs are sent directly to the summarize stage. You do not write a function for the

shuffle stage

. In this stage, the system sorts through any key/value pairs that were sent to the reduce stage, if a reduce function is defined. These pairs may have been provided by the map function, if a map function is used. If a map function was not used, the shuffle stage uses data provided by the getInputData stage. The shuffle stage groups this data by key to form a new set of key/value pairs, where each key is unique and each value is an array. For example, suppose 100 key/value pairs were sent. Suppose that each key represents an employee, and each value represents a record that the employee created. If there were only two unique employees, and one employee created 90 records, while another employee created 10 records, then the shuffle stage would provide two key/value pairs. The keys would be the IDs of the employees. One value would be an array of 90 elements, and the other would be an array of 10 elements. For the

reduce stage

, you write a function that is invoked one time for each key/value pair that was provided by the shuffle stage. Optionally, this function can write data as key/value pairs that are sent to the summarize stage. In the

summarize stage

, your function can retrieve and log statistics about the script’s work. It can also take actions with data sent by the reduce stage.

@Kris Wood if you got 4,000 results at a time, you will use 10 units and for 13,0000 you will spend around 40 units to get all the results, you can then easily send the 13,000 results to the map stage and it should not be a problem

Map/Reduce can return more than 4k results at single call

@Kevin that's correct my approach was assuming he needed to create his own object to be returned, if not a saved search with the necessary ids will be fine

Oh ok, I was thinking map got 1000 units total. Is it 1000 units per result line from getInputData?

1000 units per invocation, yes

Yep, that´s right I thought the same the first time I created a map/reduce script but it is per invocation

sweet

Hi, Could anyone of you pls let me know, How to convert an XML file to XSD? Thank you!!

does anyone know of a good way to find which scripts use a custom field? We are looking to rename a field (including internal id), but not sure which scripts might be affected.

do a repo search for the field ID

@creece - Thanks but I am not familiar with 'repo search' ... can you please explain a little more? Do you mean that we search in File Cabinet?