Robert Nedelkow-Oracle · Oracle NetSuite Community Manager · Admin

SuiteAnswers Answer Id: 22384 might help - Search for Saved Searches using SuiteScript.

I think the setting your'e looking for is under Set Preferences > Analytics > SHOW LIST WHEN ONLY ONE RESULT

I think there is something close to what you are looking for in SuiteAnswers Answer Id: 12701.

You could use an employee saved search: 1. Lists > Search > Saved Searches > New > Employee 2. Leave Criteria tab Blank (No Criteria) 3. In the Results tab you should have the following fields: * Role * Role Change Action * Role Change Date 4. Save and Run

If you base the search off date created or similar date field, you could try adding a formula to the criteria like: Formula (Numeric) > Enter formula as: case when to_char({trandate},'D') in (2,3,4,5,6) then 1 else 0 end > then compare the value to 1. This should return all records created on weekdays. This example applies…

The formula is from SuiteAnswers Answer Id: 30407 and it looks like the 'F' is enclosed in a slanted apostrophe (’ vs '). Also, you can try comparing the result to 'T' instead of just T.

One option might be to Disable/Hide a field depending on the user's role using a script. An example is provided in SuiteAnswers Answer Id: 31253.

We are tracking this functionality in Enhancement 115393 Saved Reports > Allow Users to Categorize Saved Reports > Assign to Existing Categories/Folders and/or create new Categories/Folders.

There are a few things to consider when creating a search for use in a group - i.e. you cannot define a dynamic group using a summary search. See SuiteAnswers Answer Id: 14455 for more information.

Try setting the option to Run Unrestricted = T under the Results tab of the search. This should make the search results available to users who normally do not have permissions to see the underlying records.

We are tracking this in Enhancement 239129 - Ability to enter formula in the Available Filters tab of saved searches.

The formatting requirements are: The name must be enclosed in double quotes. The email address must be enclosed in carets. There must be a space between the quoted name and the email address. See SuiteAnswers Answer Id: 19150 for examples.

Try changing this preference at: Home > Set Preferences > Reporting/Search tab > Show List When Only One Result = T.

Even though the formula is the same, the field {custitem_pr_factorial} is likely a text field and needed quotes.

i dont know. what do you mean set when ordered by? is that a sql formula? The When Ordered By Field is available when you select a Summary Type of either Minimum or Maximum, on the Results subtab of a search record. [ATTACH=CONFIG]n286986[/ATTACH]

The invalid expression happens with {systemnotes.field.id} - try {systemnotes.field} instead.

The formula would differ a bit on a customer search. Try using {call.startdate} instead of {startdate}.

You can create a saved search for existing searches: 1. Navigate to Lists > Search > Saved Searches > New. 2. Click on Saved Search. See SuiteAnswers Answer Id: 31529 for more information.

Matt, thanks for the update. I assume the custom record uses permissions and roles are listed under the Permissions tab. Have you tried adding the Administrator role to the list? Thanks,

Hi Matt, are you the owner of the mass update? The failure may occur if the owner of the update doesn't have the related permission. Thanks,

Try enclosing the search string in quotation marks, or follow it with a backslash, to search for records containing only exact matches. Enter cu: “ max” or cu:max\ to search for customers with a name of Max. Customers with names containing the letters max, like Maxam, Lomax, or Maximum Tires, are not returned. Quotation…

You could set criteria using formula(numeric): CASE WHEN to_char({datecreated},'HH24') < 12 THEN 1 ELSE 0 END

listagg(x,’,’) is not yet supported . Please contact Support and reference Defect 294790. Your case should get attached so you can receive notification when it becomes available.

Hi Jim, The permission which controls the Public checkbox is the Publish Search permission. 1. Navigate to Setup > Users/Roles > Manage Roles. 2. Edit the custom role. 3. Click the Permissions subtab. 4. Click the Lists subtab. 5. On a new permission line, select Publish Search. 6. Select Full access level. 7. Click Add.…

A script may be the way to go in this case. We are tracking this functionality in Enhancement 155770: Reports > Saved Searches > All Saved Searches > To be able to specify the file name of the results attached to the email.

The Lists permission named "Perform Search" controls the Customize View button. Try setting the permission level to View to remove the button. Thanks,

Hello Nathalie, An Enhancement Request has been created for this and you can vote for this in your NetSuite Account Center. Enhancement 109703 - Setup > Customization > Lists > click one of lists: Be able to export list values as CSV export. Thanks,

Try CASE WHEN to_char({item.custitem_refurbished}) = 'T' THEN 'Refurbished' ELSE 'New' END Thanks,

Enhancement 213878 should address this: Saved Searches > Execution Log tab : Ability to create and run a saved search that captures information from the Execution Log tab of the search.

This goes back a while but I tried the same formula Concat('"', Concat({comments}, '"')) as well as '"' || {comments} || '"' and both exported to csv as expected using Excel 2010.