01
About this report
One row per saved search with its name, script id, search type, owner, whether it is public, whether it is inactive, and when and by whom it was created.
Use it before a cleanup to find duplicates, searches owned by people who have left, and public searches that show more than they should.
02
Sample preview
Fictional figures in the shape you will see. Yours come from your account.
| Search | Script id | Search type | Owner | Public | Inactive | Created | Created by |
|---|---|---|---|---|---|---|---|
| Open orders by rep | customsearch_open_orders_rep | Transaction | Dana Whitfield | Yes | No | 2024-02-11 | Dana Whitfield |
| AP aging for CFO | customsearch_ap_aging_cfo | Transaction | Tom Okafor | No | No | 2023-06-30 | Tom Okafor |
| Customers missing email | customsearch_cust_no_email | Customer | Priya Natarajan | Yes | No | 2025-01-17 | Priya Natarajan |
| Old import check | customsearch_import_check | Item | Former Admin | Yes | Yes | 2021-09-03 | Former Admin |
03
The SuiteQL
This is the query each report runs. Read it, copy it, or change it after import.
SELECT ss.name AS search_name,
ss.scriptid AS script_id,
ss.searchtype AS search_type,
BUILTIN.DF(ss.owner) AS owner,
ss.ispublic AS is_public,
ss.isinactive AS is_inactive,
TO_CHAR(ss.createddate, 'YYYY-MM-DD') AS created,
BUILTIN.DF(ss.createdby) AS created_by
FROM savedsearch ss
ORDER BY search_type, search_name