Persisting Search Results
You can use SuiteAnalytics Workbook to query your NetSuite data using the analytics data source, which offers advanced query capabilities. For more information about SuiteAnalytics Workbook and how you can recreate your existing saved searches to workbooks, see the following topics:
Persisting search results enables you to run saved searches asynchronously, for up to 3 hours, saving search results in a CSV file. This capability is useful for searches across high volumes of data that could possibly return a timeout.
The results for each search are saved in a CSV file that is available for 7 days. Results are deleted after this time period. When a search has a Pending status for 24 hours, its status changes to Failed. When a search has a Failed status, you can try to persist the search again. The available statuses are:
-
Pending – Search is running.
-
Completed – Search is finished. The download link is available.
-
Timeout – An execution of the search exceeded the three hour time limit. The download link is not available.
-
Failed – Some error occurred in the execution of the search. The download link is not available.
To persist search results:
-
Go to Reports > Saved Searches > All Saved Searches to view the Saved Searches list page.
-
Click Persist (CSV) for the search.
When you click Persist (CSV), a Search Results page displays the status of the search running in the background.
When search execution is complete, a download link for a CSV file of the results is available on the Search Results page. You can also access this page by clicking the new Reports > Scheduled Searches > Search Results link.
Persisting Search Results for Non-Administrator Users
Administrators may enable other users with non-administrative roles to persist searches.
To allow a role to persist searches:
-
Go to Setup > Users/Roles > Manage Roles and click the custom role for users whom you want to enable to persist search results.
-
Click Edit to modify the role settings.
-
On the Permissions tab, click Lists.
-
Choose Persist Search from the bottom of the dropdown list and click Add.
-
Click Save.
If you want to enable selected users to persist searches, you can add the Persist Search permission to their global permissions. To learn how to assign a global permission, see Using the Global Permissions Feature.