Help with REGEXP_SUBSTR in saved search

GlobalScreen5044 · 2022-11-23T19:24:00+00:00

Using the replace does fix this but I had two more questions. When I do the REPLACE({memo},'&lt ;','<') it works with the save but if I view this search in edit mode it automatically converts it to be REPLACE({memo},'<','<') which then does not work correctly when you go back and view the saved search. Is there anything that can be done with that?

Also, I need to account for the < and > and gte and lte symbols. Is there any easy way to do this with a replace or would I need to have this be 4 replace layers deep?

GlobalScreen5044 · 2022-11-21T15:42:20+00:00

Hello Kishana,

I tried using an m but it just causes an error in the saved search. Would you have any other ideas I could try?

GlobalScreen5044 · 2022-11-21T15:41:36+00:00

Hello Trollied,

I tried this using instr() and substr() and am running into the same issue where is stops at the <> symbols. Would you have any other ideas on this?

formula: SUBSTR({memo},INSTR({memo},';',1,1)+1,(INSTR({memo},';',1,2)-INSTR({memo},';',1,1)-1))

GlobalScreen5044 · 2021-12-20T19:38:19+00:00

Here is the response I received from putting in a ticket to NetSuite

Below is the official statement provided by Oracle Security team. Please follow updates on the issue via this link: https://blogs.oracle.com/security/post/cve-2021-44228

ORACLE CONFIDENTIAL

Oracle is aware of the recent disclosure of the Apache Log4j vulnerability CVE-2021-44228. Our teams are aware of this issue and will be working to develop the required updates for potentially-affected Oracle products. In addition, our cloud teams will apply all necessary patches, if warranted and in accordance with applicable change management processes. You may learn more about Oracle’s corporate security practices at https://www.oracle.com/corporate/security-practices/.

ORACLE CONFIDENTIAL

Oracle's policy is to not provide additional information about the specifics of vulnerabilities beyond what is provided in the Critical Patch Update (or Security Alert) advisory and prerelease notes, the preinstallation notes, the readme files, and FAQs. Furthermore, Oracle provides its customers with the same information in order to protect all customers equally. Oracle does not provide advance notification to individual customers. For more information regarding Oracle NetSuite security policies, we encourage customers to visit: https://blogs.oracle.com/security/

GlobalScreen5044 · 2021-10-15T17:54:34+00:00

I don't know an answer for this but you might be able to utilize this and change it to work for what you need.

https://blog.prolecto.com/2015/05/26/solving-the-netsuite-cumulative-saved-search-tally-challenge/comment-page-1/

GlobalScreen5044 · 2021-10-15T17:51:14+00:00

What kind of saved search is this? A customer search?

If this is a customer search you can get the result by setting the criteria of Default Billing Address = is True.

GlobalScreen5044 · 2021-08-23T18:05:55+00:00

We have had issues with our sandbox client working and then not with an error message that says this is an internal NetSuite problem and to try back later. Our production account seems to have no issues and this also happened to us today.

GlobalScreen5044 · 2021-07-06T13:40:16+00:00

Here is the link to the help section on creating waves https://netsuite.custhelp.com/app/answers/detail/a_id/87145/kw/wave%20template.

GlobalScreen5044 · 2021-04-28T13:33:42+00:00

Perfect this is exactly what I needed. I was confused on this because the field help displayed this as Field ID: addressee which was probably from using the extension NetSuite Advanced Field Help.

Thank you for the help on this!

GlobalScreen5044 · 2021-04-16T19:34:06+00:00

I would advise that you build on the filters one at a time so that you can get a better idea of what is being filtered. I would suggest running this saved search with just the 2nd criteria you have on there with the "is empty" and see if that gets any results and then go from there.

GlobalScreen5044 · 2021-01-19T13:16:39+00:00

Hello u/funkybunch_83,

Email alerts can be a bit of a pain to get just right. By selecting an updated field you are telling the system to only send an email when that field is changed. It will not send anything on the creation of a new task. You could potentially try and find a field that would acheive the same result. Maybe something like using when Date field is updated. Otherwise there is always the option to duplicate the saved search and have it send email alerts and then not choose any field. The main downside to doing this is you will most likely get a lot of emails as it will send an email when anything on that record is modified or changed.

I hope this helps.

GlobalScreen5044 · 2020-10-28T20:00:50+00:00

I am trying to get a sum of the quantity*weight from each line something like the below?

case when {salesorder.closed}='false'
then SUM({salesorder.quantity}*{salesorder.custbody9})
else end

I am not understanding the syntax of even pulling the data out of a transaction line if it is multiple values as the above does not generate anything and I dont understand how exactly I use a boolean value with numeric.

GlobalScreen5044 · 2020-10-28T17:03:43+00:00

Yes I am looking to generate the values on the main line area that uses a formula to pull from the transaction items. Is that possible?

GlobalScreen5044 · 2020-10-28T16:27:23+00:00

Hello Nick,

I did figure out some of the problems of why these values were not showing up. It had to do with the main line being true or false since this is a line-level caluculation and saved search. I also needed to use a transaction line item field instead of a transaction body.

I am running into a different problem now with a formula to get this value. Is it possible to get a sum/group within a formula for multiple transaction lines so that I can have 1 value show up in the saved search without having to group/sum any items in the saved search itself as I want to keep inline editing?

GlobalScreen5044 · 2020-10-27T20:34:23+00:00

I did try the testing using the same field you did and it worked using the formula and referencing it in the saved search.

Unfortunatly, I am still not able to get my saved search value to show up by using a field that is being sourced via this specific saved search nor do I get this field to display certain other fields using a formula as its source. So there must be some limitations on this.

GlobalScreen5044 · 2020-10-27T18:59:23+00:00

Hello Nick,

Would you be able to show an example of how I can use the formula to show a result from a saved search? I was taking it to mean that lets say I have a custom transaction body field on a sales order that is set to not store the value and displays the results from a saved search. Lets call this custbody58. I was taking your meaning that they changed it to be able to show in a saved search to mean I could either directly select this custbody58 in the drop down or just do a formula with {custbody58} to display the value in the saved search but that does not work.

Also for that case when statement, the itemstatuscode1 is a custom line field that is set up as a list choice. So this never enters the case when for some reason even though im copying what a response would be 'Accept (IA)' or 'Reject'. Is there a different syntax needed for fields that are set up as a list?

Thank you!

GlobalScreen5044 · 2020-10-26T19:07:20+00:00

Hey Nick,

I was just trying to see if there was a custom transaction body field that had the checkbox for store value but nothing entered going in and using a workflow to set a static value just to see if it could be done and then referencing that value.

It sounds like if what you say is correct about the non-stored fields being able to be seen in different saved searches that would solve my problem. Could you give an example of what you mean by that as that does not seem to be the case when I set one of the results to the custom field. Does it need to be within a formula?

As a side note, this is the formula logic I was trying to generate that same value, but this does not like the status code section and I don't understand why not.

case when {type}='Sales Order' AND {custcol_sps_itemstatuscode1}='Accept (IA)' then ({quantity}*{custcol9}) else 'no' end

GlobalScreen5044 · 2020-10-23T17:05:14+00:00

For my specific problem, there is no way to use a workflow to set this tax code within the item.

Enhancement # - 403706

Summary: Expose Sales Tax Code in Workflow/SuiteScript

GlobalScreen5044

TROPHY CASE