Creating a Dataset Builder Plug-in Script File

You must implement each Dataset Builder Plug-in interface function in a JavaScript file (with a .js extension). You can use SuiteCloud IDE, another JavaScript IDE, or a text editor to create the plug-in implementation script file.

The following is a Dataset Builder Plug-in sample:

          /**
 * @NApiVersion 2.x
 * @NScriptType datasetbuilderplugin
 */
define(['N/dataset'], function(dataset) {
   return Object.freeze({
      createDataset: function(context) {
         var trandate = dataset.createColumn({
            fieldId: 'trandate',
            alias: 'date'
         });
         var join = dataset.createJoin({
            fieldId: 'createdby',
            target: 'entity'
         });
         var name = dataset.createColumn({
            join: join,
            fieldId: 'lastname',
            alias: 'name'
         });
         var tranid = dataset.createColumn({
            fieldId: 'tranid',
            alias: 'id'
         });
         var total = dataset.createColumn({
            fieldId: 'foreigntotal',
            alias: 'total'
         });
         var columns = [tranid, name, trandate, total];
         context.dataset = dataset.create({
            type: 'transaction',
            columns: columns,
            name: 'Test Dataset',
            description: 'My Test Dataset'
         });
      },
   });
}); 

        

General Notices