Mayesh Nadesan
03/14/2025, 6:04 AMCeligo AI
03/14/2025, 6:04 AMAI generated answer (using internal Slack threads):To modify and show date in a saved search in NetSuite, you can use the
Date Last Modified
filter. However, it's important to note that the UI only allows you to select hours, not specific minutes. If you need to get down to specific minutes, you would need to do it from a script.
Here's a general approach to do this:
1. Load the saved search using search.load({id: 'customsearch_your_search_id'})
.
2. Add or amend the filters. For example, you can add a filter for Date Last Modified
and set it to a specific date and time.
3. Inspect the search.Search
object after loading it to ensure the filters are set correctly.
If you want to get records that were modified within a specific time frame (like within the last hour or 30 minutes), you can use a relative date filter on the Date Last Modified
.
If you're using a script, you can create a Date object and manipulate it to be the date that you would set in the UI if you were creating a custom range. For example, if you want to get records that were not updated within the last 30 minutes, you can subtract 30 minutes from the current time and use that as your filter.
Here's a general approach to do this:
1. Create a new Date object: var now = new Date()
.
2. Subtract 30 minutes from the current time: now.setMinutes(now.getMinutes() - 30)
.
3. Add a filter to your search: search.filters.push(search.createFilter({name: 'lastmodified', operator: search.Operator.AFTER, values: [now]}))
.
Please note that this is a general approach and you may need to adjust it based on your specific requirements and the structure of your saved search.
******
Disclaimer:
This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes.
******Celigo AI
03/14/2025, 6:04 AMSlack thread 1: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.847657
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.84294194
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.837839901
Celigo AI
03/14/2025, 6:04 AM