Discussions
Read on for the latest updates including:
• Agenda Builder launch
• SuiteWorld On Air registration
• New NetSuite Prompt Studio Contest
• And more!
Check out this thread to learn more!
Saved search to show last log entries only
We have a scheduled script instance saved search, which we use within dashboard views to show the current status of various script deployments associated with our despatch system.
Criteria:
Script Deployment : Internal ID | is any of 1234, 1235, 1236 | |
Date Created | is after three days ago |
Results:
Field | Summary Type | Formula | Summary Label | |
Script Deployment : Title | Group | |||
Formula (Date/Time) | Maximum | nl_tz.convert({datecreated}) | Last Job Time | |
Status | Maximum | Status | ||
Percent Complete | Minimum | Progress |
The summaries are applied on the results as a crude way to achieve the desired result - to only see one log line per script.
This all works fine 99% of the time when scripts execute successfully. However, we find that one script in particular errors about once a week (always around the same time, due to a search timeout). When an error occurs, that queue continues to show "error" in the status column, until our 3 day criteria window elapses.