Organize Table Data by Sublist Using Scripts in NetSuite

When loading dynamic and function-generated tables using scripts, you can now obtain data organized by sublist. To achieve this in NetSuite CPQ Configurator, you can set the new sublist parameter for getTable().loadContent() to true. By default, this parameter is set to false, allowing you to omit it if organization by sublist isn't necessary. This new implementation is recommended over the traditional method using getData() with the loadapi parameter set to true, as it significantly enhances the performance of table loading.

Syntax Example

Here's how to use the getTable().loadContent() function with the sublist parameter:

"text-purple-400">let table = "text-purple-400">await getTable('TABLE_CODE').loadContent({
    sublists: true
});

Function Output

The output in the console for the above function will display the organized table data by sublist, enabling more refined data processing and display. This improvement is particularly beneficial in applications where data volume is significant and organization plays a crucial role in usability and speed.

Key Benefits

• Improved Performance: By using the sublist parameter, table loading becomes more efficient compared to traditional methods.
• Flexible Implementation: The sublist parameter can be set or omitted based on specific use cases, providing flexibility in script development.

Note: Ensure that you are on the latest version of the NetSuite CPQ Configurator for optimal results.

Who This Affects

• Administrators: Manage and implement new scripting capabilities.
• Developers: Enhance scripts to utilize the sublist organization feature.
• End Users: Experience improved data organization and loading times in the application.

Key implementations of this feature will help in maintaining organized and efficient data representation in various NetSuite applications, particularly those using scripting for dynamic data presentations.