I keep getting complaints about time outs

is there any way i could get these five results into one text field? so rather than five rows, i’d have one row with a field containing: Base -10% Base -20% Base -10% Base -10% Base -09%

A file, which can't be shown because your team is past the free storage limit, was commented on.

@mattb You might be able to do something with

NS_CONCAT

hmmm will give it a crack

i’ve used

CONCAT

in the past such as just adding some text to an existing field like

CONCAT(150, {custentity_os_delcode})

just not sure how to go about joining a few fields together that share the same name

You need to group the result, and then if you do

NS_CONCAT({field})

the result will be the value of each {field} in the group seperated by commas

@mattb (sorry I typed out half of that, and then got caught up in some work)

what, like your day job, no way 😉

😆

is it NS_CONCAT or just CONCAT?

NS_CONCAT for grouped results, CONCAT for ungrouped results

If you want to google to understand better, it's the same idea as

WM_CONCAT

in Oracle, or

GROUP_CONCAT

in mySQL

great, thank you!

@michoel: could never get concat it to fire - any tips? non-groups is definitely the preference

what i’ve read regarding wm_concat is pretty much what i want though; take a field that is repeated on each row into one cell

@mattb so ns_concat is basically the netsuite equivalent of wm_concat. You have to use groups for it to work. If you want to post your search criteria / results I can take a look, though I've already left the office for the day so I probably won't be able to look until Monday

@michoel: no worries; chat monday!

Why do I get an Unauthorized Access when I try to run a web query of a report I created I even enabled all audience/accesss and still doesnt work

@dave Is there any chance you mistyped your email address when you first tried to open it and checked the box to use that for all subsequent queries?

I've tried opening it several times and retyping it to verify that the email address was correct

it was correct

never seen that before...

😞

Figured it out,

it has to be all lowercase

Can we edit a promotion field and do sourcing and filtering on sales orderform?

Promotion is a standard field.

is it possible to cancel/close/delete orders using an import?