The below JSON is what I get when logging out each...
# suitescriptj
jarens
08/29/2018, 12:58 PMThe below JSON is what I get when logging out each result of a loaded saved search. The below is me trying to get '5553012'. Can anyone help with the syntax to get a summary formula out of a result? Also if there is something special I need to do to find that second formula?
s
samyt
08/29/2018, 12:59 PMAre you trying in get in M/R script?
j
jarens
08/29/2018, 1:00 PMNo, this is a search in a Suitelet.
r
rmlakhani
08/29/2018, 1:01 PMvar value = values[“SUM(formulanumberic)“];
rmlakhani
08/29/2018, 1:02 PMyou’re dealing with a JSON object there
j
jarens
08/29/2018, 1:03 PMIt doesn't handle like JSON object. I get and error if I try to return result.values["SUM(formulanumeric)"]
jarens
08/29/2018, 1:03 PMsays "values" is undefined
s
samyt
08/29/2018, 1:03 PMYou can use summary parameter in your result!
r
rmlakhani
08/29/2018, 1:04 PMWhat is the top level value
rmlakhani
08/29/2018, 1:04 PM?
rmlakhani
08/29/2018, 1:05 PMif its result
rmlakhani
08/29/2018, 1:05 PMtry result[“values”][“SUM(formulanumeric)“]
s
samyt
08/29/2018, 1:06 PMresult[i].getValue({name: "field",summary: "SUM",sort: search.Sort.DESC,label: "Amount Remaining"}) this is something I used to do
samyt
08/29/2018, 1:07 PMIf you still want to work on JSON I would suggest you can try to Parse the value and then pull it
j
jarens
08/29/2018, 1:22 PMThanks @samyt, result.getValue({
name: 'formulanumeric',
summary: search.Summary.SUM
}); works.
jarens
08/29/2018, 1:22 PMNow how do I get the second formula numeric?
jarens
08/29/2018, 1:26 PMnvm, I'll just make the second a formulacurrency
s
samyt
08/29/2018, 1:26 PM{
name: "formulanumeric",
formula: "your formula",
label: "Formula (Numeric)"
}
j
jarens
08/29/2018, 1:29 PM@samyt, yeah that's how I'd do it if I created the search in the script. This one I want non-developers to maintain so I'm passing saved searches in as parameters, so I don't know how the labeling works... hmm idea maybe I'll load and log out the saved search and see if that gives hints.
s
samyt
08/29/2018, 1:30 PMOr else you can use a delimiter and perform both formula numeric field functionality in one field
samyt
08/29/2018, 1:32 PMFor eg :formula(numeric) "553012 &* 90343". You can use get the value using result.getValue() and split using (&*)
j
jarens
08/29/2018, 1:35 PMNice. I'll keep that in mind as that's a nice workaround. Fo r this script I think just using formulacurrency will be easiest since it's only the two numbers I need.
👍 1
r
rustyshackles
08/29/2018, 7:57 PMYou can also get the all the columns then loop thru the columns and get the value using results.getValue(column[index])
👍 1
3 Views