Robert Nedelkow-Oracle · Oracle NetSuite Community Manager · Admin

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,

A Formula (Text) in your results with CASE WHEN {datefield} IS NULL THEN 'WORD' ELSE '0' END should work. Thanks,

Hi Kevin, You can remove the New column by turning off Inline Editing. Thanks,

You can extract the month using a Formula (Text) Field on the Results tab: TO_CHAR({datecreated},'Month') Thanks,

Try a customer search using the 'summary' filter option and add a summary filter for "maximum" of "activity : date" is not after x days ago. You also need to group the results by customer name/id or some other field. Thanks,

Hi Natalie, You could first determine the internal id's of the companies, then add them in the case search using the internal id field. The internal id field will allow you to select multiple id's. Thanks,

You can also include the Internal ID field by default on search results by enabling the preference at: Home > Set Preferences > General tab > Show Internal IDs = T. Thanks,

If this is in a portlet, click Set Up and make sure Allow Inline Editing = T. Thanks,

Try adding criteria for Main Line = T as well. Thanks,

You might have the user preference for internal id enabled. Go to Home > Set Preferences > General tab, and make sure Show Internal IDs = F. Thanks,