saved search of all custom fields (all field types...
# ask-stanley-ai
l
saved search of all custom fields (all field types and all record types)
c
AI generated answer (using internal Slack threads):
To create a saved search of all custom fields (all field types and all record types), you would need to create a search in NetSuite using SuiteScript. Here is a sample code snippet that was shared in one of the threads:
Copy code
javascript
var customRecordSearch= search.create({
    type: "customrecordtype",
    filters: ['isinactive', 'is', false],
    columns: ['scriptid', 'name']
});
var res= customRecordSearch.run();
var results = res.getRange({
    start: 0, 
    end: 10
});
This script creates a search for a custom record type, filters out inactive records, and returns the script ID and name of the first 10 records. However, please note that not all custom fields may be available for saved searches. If the custom field value is not stored, it might not be available for saved searches. There might be instances where you can have a non-stored value field that is a formula, made up of other values available in the search itself, and then it will work. For custom records to appear in the "Search Type" list, you need to view one of the records and in the upper right click "search". If some of them are not appearing, it might be due to how they are connected or set up. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******
Slack thread 1: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.825774074
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.823133
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.822111309
Please provide your feedback on this answer.