Write me SuiteScript that uses the Builtin.df function to pull the values of the status field

AI generated answer (using internal Slack threads):

Based on the conversations, here is a SuiteScript example that uses the Builtin.df function to pull the values of the status field:

javascript
require(['N/query'], function(query) {
    var sql = 'SELECT BUILTIN.DF(Status) AS OrderStatus FROM Transaction';
    var results = query.runSuiteQL({query: sql}).asMappedResults();
    console.log(results);
});

In this script, we are using the

N/query

module to run a SuiteQL query. The

BUILTIN.DF(Status)

function is used to get the display value of the

Status

field from the

Transaction

record. The

asMappedResults()

function is used to return the results as an array of objects, where each object represents a row of the result set, and the properties of the object represent the columns of the result set. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******