Hi guys, hope you're well! Question, how can i access a field inside a saved search that contains a formula?

Given a Search defined like:

const lateEntriesSearch = s.create({
  type: s.Type.TIME_BILL,
  filters: [
    [`formulanumeric: ${daysElapsedFormula}`, s.Operator.GREATERTHAN, 7]
  ],
  columns: [
    'employee',
    'date',
    'datecreated',
    {
      name: 'formulanumeric',
      formula: daysElapsedFormula
    }
  ]
})

You could retrieve the formula column like so:

result.getValue({ name: 'formulanumeric' })

Hi! Thank you for your response. I have this:

search.createColumn({
   name: "formulanumeric",
   summary: "MAX",
   formula: "{netamount} ",
   label: "Net Amount"
})

You have a

Summary

on your Column, so you need to retrieve it using

getValue

with the

Summary

specified as well. In general, you retrieve a Column value by calling

getValue

with the same parameters as you called

createColumn

. In this case,

result.getValue({ name: 'formulanumeric', summary: s.Summary.MAX })

Oh I see. So in this case, the s in the s.Summary.MAX refers to which variable?

Oh sorry, that's the

Search

module

I used search and it did not work.

It contains an enumeration for all the

summary

options

Let me try again 🙂

`N/search.Summary`: https://docs.oracle.com/en/cloud/saas/netsuite/ns-online-help/section_4345777923.html#search.Summary

What would you do when you have more than one column with a "formulanumeric"?

There are probably multiple ways. I use the `Result`'s

toJSON()

method like so:

const results = lateEntriesSearch.run().getRange({ start: 0, end: 1000 })
const lateEntries = results.map(resultToObject)

function resultToObject (result) {
  const res = result.toJSON()
  console.log(res)
  return {
    employeeName: result.getText({ name: 'employee' }),
    daysElapsed: res.values.formulanumeric,
    daysElapsedNoRound: res.values.formulanumeric_1
  }
}

Ahhh I see, that's great!

I desperately wish the

search

module had a method similar to the

query

module's

asMappedResults()

I do not think i have used the query's module. That one is similar to the search, i am assuming? I will look at it in a bit 🙂