Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
Now is the time to ask your NetSuite-savvy friends and colleagues to join the NetSuite Support Community! Refer now! Click here to watch and 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.
3