Column Object Members in SuiteScript 2.1 for Searches

Starting with SuiteScript 2.1, the Column object facilitates the creation and management of search columns in NetSuite searches, enhancing data retrieval and manipulation capabilities for scripts.

Overview of the Column Object

The Column object in the N/search module encapsulates a single search column, allowing developers to define how data is fetched and structured in search results. This object can be created using the method search.createColumn(options) and can be included in a search.Search object during search creation or loading.

Key Features of the Column Object

• Encapsulation: The Column object encapsulates the properties and methods for defining search columns.
• Customizability: Users can utilize the various methods and properties to adjust column settings, such as applying formulas or defining sorting behavior.
• Integration with Result Objects: Many search result processing methods can utilize Column objects directly, enhancing flexibility and convenience in handling search results.

Column Object Members

Here’s a quick overview of the available members (methods and properties) associated with the Column object:

Practical Usage Example

Here's a sample script snippet demonstrating how to create a search using a column with a formula:

1// Add additional code 
2...  
3search.create({
4    type: search.Type.TRANSACTION,
5    columns: [
6        'trandate',
7        'amount',
8        'entity',
9        'entity.firstname',
10        'entity.email',
11        search.createColumn({
12            name: 'formulatext',
13            formula: "{lastname}||', '||{firstname}"
14        })
15    ],  
16    // Add additional code  
17});

This script generates transaction search results featuring a concatenated column of last and first names.

Conclusion

The Column object in SuiteScript 2.1 empowers developers to effectively manage and manipulate search data within NetSuite. Its functionalities enhance search operations, making it easier to customize and retrieve the desired results based on specific criteria.

Source: This article is based on Oracle's official NetSuite documentation.

Key Takeaways

• The Column object is essential for defining search columns in SuiteScript.
• It supports various methods and properties to customize search result presentation.
• Practical usage includes building complex columns with formulas for enriched data displays.