The NS Search Definition extension is designed to decrypt and display NetSuite Saved Search and Report Definitions in XML format. This extension is especially useful for NetSuite administrators and developers who need to decrypt and inspect search definitions for auditing, debugging, or development purposes.
Features
Decrypt NetSuite Saved Search or Report Definitions: Right-click on an XML file and choose "Decrypt Definition" to decode NetSuite Saved Search pr Report definitions.
Right-click on Folders to Decrypt Multiple Files: Right-click on a folder in the VS Code Explorer and choose "Decrypt All Definitions". This will process all customsearch*.xml and customreport*.xml files in the folder, decrypting and formatting each search or report definition.
Search Across Multiple Saved Search or Report Files: Once you have downloaded multiple Saved Search or Report XML files, use the folder decryption feature to decrypt them in bulk and open them for inspection.
Command Palette Integration: You can trigger the decryption process using the command palette with the command "Decrypt Definition" or "Decrypt Definitions".
Formatted XML Output: The decrypted search and report definitions are automatically formatted for easy reading and analysis.
Example Usage
Decrypt a Single File
Right-click on the file in the VS Code Explorer and select "Decrypt Definition".
The decrypted and formatted XML is opened in a new tab.
Decrypt All Definitions in a Folder
Right-click on a folder containing NetSuite Saved Search or Report XML files (e.g., customsearch*.xml or customreport*.xml).
Select "Decrypt All Definitions" from the context menu.
All .xml files that match the pattern customsearch*.xml and customreport*.xml in the selected folder will be decrypted and saved to the specified output folder or displayed in the editor.
Use Case: Analyzing NetSuite Saved Search and Report XML Files
You can download all NetSuite Saved Search and Report XML files (using SuiteCloud Development Framework (SDF) or other methods) and decrypt them using this extension. Once decrypted, you can search for specific information, such as:
Fields Used: Open the XML files and look for specific fields that are part of the search criteria or result columns.
Formulas Used: Search for any formulas used in the saved searches by inspecting the XML for formula expressions.
Downloading NetSuite Saved Search and Report XML Files
To download NetSuite Saved Search XML files, you can use NetSuite's SuiteCloud Extension for Visual Studio Code, available at the VS Code Marketplace. This extension enables you to work with SuiteCloud projects and provides tools to download, deploy, and manage NetSuite objects, including Saved Search definitions.