My Stuff
Default Avatar
See All the Unlockable Badges See All the Unlockable Badges

User_KN5OE Red Ribbon

Comments

  • Hi Richard Your example #2 was something i have seen before when I was trying to get my query to work. For some reason unknown to me, whenever I use the CTE in the union all part of the query it does not work in SuiteSQL. Any other ways of doing this in NetSuite? Doesnt have to use CTEs? CTEs and SuiteQL just seemed the…
    in retrieving hierarchical data Comment by User_KN5OE Aug 29, 2024 9:54PM
  • Richard, Thanks for confirming. So any thoughts on correcting that part? That is the essential part of what I'm trying to do, the recursion part of the CTE.
    in retrieving hierarchical data Comment by User_KN5OE Aug 27, 2024 4:36PM
  • Hi Richard, if i change your suggested query to with tbl (accttype) as (select accttype from account where id < 100 union all select accttype from account where id < 100) select * from tbl then it works. If i try my query in the console as suggested by that article, then i get the same error as before As i mention before…
    in retrieving hierarchical data Comment by User_KN5OE Aug 26, 2024 5:19PM
  • Hi Richard tbl is the CTE, it refers to the results of the query. The complete query is the first one, with the recursion. with tbl (id,name, quantity, parent_id) as ( select custrecord_ntx_arena_comp_component as id, BUILTIN.DF(custrecord_ntx_arena_comp_component) as name, custrecord_ntx_arena_comp_qty as quantity,…
    in retrieving hierarchical data Comment by User_KN5OE Aug 23, 2024 11:17PM
  • Hi Angela, our human users :) do use OKTA to login to NetSuite. That works fine. For integrations inbound into NetSuite we use token based authentication, which NetSuite supports though simple configuration - generate tokens, give them to 3rd party, they set those up in their system, and that authenticates to NetSuite. I…
    in Authenticating to boomi rest API using Oauth2 and OKTA in SuiteScript 2.1 Comment by User_KN5OE Aug 23, 2024 8:00PM
  • Hi James I tried with naming all the columns, so that they are the same, but the error is the same with tbl (id,name, quantity, parent_id) as (select custrecord_ntx_arena_comp_component as id, BUILTIN.DF(custrecord_ntx_arena_comp_component) as name, custrecord_ntx_arena_comp_qty as quantity,…
    in retrieving hierarchical data Comment by User_KN5OE Aug 22, 2024 8:12PM
  • Hi Richard I can get 1 level using a CTE (no recursion). with tbl (id,name, qty, parent_id) as (select custrecord_ntx_arena_comp_component, BUILTIN.DF(custrecord_ntx_arena_comp_component) as name, custrecord_ntx_arena_comp_qty as quantity, custrecord_ntx_arena_comp_parent_comp as parent_id from…
    in retrieving hierarchical data Comment by User_KN5OE Aug 21, 2024 11:01PM
  • Hi, thanks for the response. This article seems to be more about integration of OKTA to NetSuite, so users in NetSuite can get provisioned through OKTA. My need is more the other way round. I want to authenticate to Boomi, using OKTA. So Suitescript running in NetSuite, wants to call a Boomi REST api, but needs to be…
    in Authenticating to boomi rest API using Oauth2 and OKTA in SuiteScript 2.1 Comment by User_KN5OE Aug 21, 2024 9:31PM
  • Hi Alex Do you know if this is possible to achieve using a SuiteAnalytics query? maybe using CTEs WITH recursion? I understand that this might not be possible using saved searches, as they are fairly limited.
    in retrieving hierarchical data Comment by User_KN5OE Aug 20, 2024 5:55PM
  • Hi Alex, So this is the main record for Components, just has a bunch of data about that component. No relationship info. Eventually in the query results I will need to have some of this info. For now to keep the query simple i'm not including. The relationship custom record. Saved search showing sample data from the…
    in retrieving hierarchical data Comment by User_KN5OE Aug 16, 2024 8:15PM
  • Hi Mikko, yes, its checked on the child/sublist custom record. And it does seem to work for roles that have edit access, I guess the setting does say 'Allow Child Record *Editing*'
    in rendering a custom sublist Comment by User_KN5OE Aug 15, 2022 8:04PM
  • Hi Mikko, Thanks for the reply. That does work for this case, but i also need access via restlet, where we cant set it to run as admin. I'm not a huge fan of running things with elevated privileges if its not absolutely necessary. In general I was wondering if there is a workaround for using recmach<fieldid> where the role…
    in rendering a custom sublist Comment by User_KN5OE Aug 12, 2022 9:58PM
  • Hi Leonard, Thanks, that worked perfectly. Who would have thought a missing <body> tag would have made all the difference.
    in Using <a href="#loc"> in an email Comment by User_KN5OE Jun 21, 2022 11:57PM
  • Hi Michelle Attached is a dumbed down version of the email body to be sent via nlapiSendEmail It basically contains a <a href="#123"> tag that reference a element later on in the email, with an id of 123. If you send this to an Outlook user, via the nlapiSendEmail API. and they click the link it takes them to…
    in Using <a href="#loc"> in an email Comment by User_KN5OE Jun 21, 2022 6:28AM
  • Hi, Just for clarification you want me to change <a href="#loc"> to <a href="https://<account-id>.app.netsuite.com#loc">Loc</a>. I do not want the email recipient to go to netsuite when they click the link. Is the expectation that the nlapiSendMail api will remove the NetSuite domain from the href, so it will then work in…
    in Using <a href="#loc"> in an email Comment by User_KN5OE Jun 20, 2022 5:58PM
  • Hi, Thanks for the followup. As mentioned in the original post creating a field was not something I wanted to do. Was hoping there was an alternative method. Thanks
    in Date math in advanced scriptable email template Comment by User_KN5OE Jun 16, 2022 9:54PM