Special Nested Search Properties in NetSuite

Special Nested Search Properties

Nested Searches

You can use results from one search in the filters of another search. The nested search runs first and returns an array of internal IDs, then the outer search uses those IDs in its filter.

Important:

If you nest searches the wrong way, it can cause performance issues.

Special Nested Search Properties

The all and default properties are a couple of special search options you'll use often. By default, config searches return up to 1000 results. If you set all: true, you can get more than 1000, but it might slow things down. If there are no results results, config returns an empty array, which might cause errors. The default property gives you a fallback value instead.

The example below shows a second search inside another. The second search is on the record customrecord_nxc_cr and returns a map of custrecord_nxc_cr_asset. This field stores the asset and therefore returns the internal ID of the asset found on the record. It uses a default of 0 to avoid issues if there are no results found in the nested search. Any results found are an array of assets internal IDs, and get excluded from the main search because the nested search is inside of this filter: ["internalid","noneof",

1"record": "customrecord_nx_asset",
2                                    "filters": [
3                                        ["internalid","anyof","${event.caseassets}"],"and",
4                                        ["internalid","noneof",{
5                                                "array": true,
6                                                "default": "0",
7                                                "assets": {
8                                                    "record": "customrecord_nxc_cr",
9                                                    "filters": [
10                                                        ["custrecord_nxc_cr_case","anyof","${event.supportcase}"],"and",
11                                                        ["custrecord_nxc_cr_task","noneof","${event.internalid}"]
12                                                    ],
13                                                    "map": "custrecord_nxc_cr_asset"
14                                                }
15                                            }]
16                                    ],