Robert Nedelkow-Oracle · Oracle NetSuite Community Manager · Admin

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.

To resolve this, perform the following steps: 1. Navigate to Lists > Search > Saved Searches > New. 2. Select Customer. 3. In the Criteria tab > Standard subtab, select Formula (Text). 4. In the Customer Search popup window, set the following: •Field: Choose Alt. Email, Mobile Phone, Home Phone, Subscription Category or…

Does the search return dupes when the script has been disabled? Thanks,

I would check with Support. They may be able to point you in the right direction. Thanks,

You use expressions to specify the OR condition in your criteria. Check the Use Expressions checkbox under the Criteria tab. The last column allows you to set the AND/OR condition. Thanks,

Here's a similar thread that includes examples: https://usergroup.netsuite.com/users/showthread.php?t=31596&highlight=matrix+item+child Thanks,

An example of a workflow might be to automate a drip marketing campaign or automate an approval routing process. Saved search results provide reporting and tracking and can serve as the basis for business analysis and strategic decision-making. A saved search can have many advanced search filters and display options which…

Hi Brett, that is correct. Currently all scheduled saved searches run at 2 a.m. Pacific Time. You may want to vote for Enhancement Request 208791 - Saved Searches: Allow the ability to email saved searches at a scheduled time(start time). Thanks,

You can use a Formula (Text) field with a formula like: to_char({date}, 'YYYY'). This will only show the year of the date field. Thanks,

Try adding the Publish Search permission with Level = Full to the role. Thanks,

The Help topic titled, SQL Expressions outlines the SQL functions that can be used in NetSuite search formulas and custom formula fields. Thanks,

You could group each of the columns under the results tab. Thanks,

thanks can you give me an example? Or where can I read more to learn how to use the formulas? The Help topic titled, Search Formula Examples and Tips is a good place to start. You can also try searching this UserGroup for the thread titled, 100 Ways to Use Formula Fields. Thanks,

You should be able to use something like: {today} Thanks,