I have a SuiteQL Query that is only working when r...
# suiteqln
NS
08/30/2021, 2:59 PMI have a SuiteQL Query that is only working when run in the Administrator role otherwise I get an UNEXPECTED_ERROR... could there be permissions I'm missing? The suitescript I'm running is called in a restlet called from a suitelet, and the suitelet is set to run as administrator as well. So I'm confused. Any ideas?
j
JC
08/30/2021, 5:05 PMcustom records?
n
NS
08/30/2021, 8:22 PMI have successfully identified that it's the 'transactionShippingAddress' table I don't have permissions to but still don't know what permission to add to my role.
j
JC
08/30/2021, 8:23 PMdo you have all transaction types added to the permissions in the role?
t
tdietrich
08/30/2021, 8:36 PM@NS Do you have Lists > Perform Search granted to the role?
n
NS
08/30/2021, 8:39 PMYeah basically all transactions. And yes I have Perform Search set to Full as well.
t
tdietrich
08/30/2021, 8:42 PMAnd do you also have
Transactions > Find Transactiontdietrich
08/30/2021, 8:43 PMI'm just guessing, because the roles are confusing...
tdietrich
08/30/2021, 8:44 PMBut I'd also double check
Lists > CustomersLists > Custom Profilen
NS
08/30/2021, 8:51 PMI did not have Customer Profile but adding it didn't do the trick. Thanks for the help so far.
t
tdietrich
08/30/2021, 8:53 PMI suspect it's one of those weird ones that you're missing.
tdietrich
08/30/2021, 8:53 PMAre you in a OneWorld account?
n
NS
08/30/2021, 8:56 PMI am not
t
tdietrich
08/30/2021, 8:58 PMI'm curious - can you select against the transactionShippingAddressbookEntityAddress table?
n
NS
08/30/2021, 9:02 PMYes! and it seems to have the fields I need. So odd. But thanks a lot!
t
tdietrich
08/30/2021, 9:04 PMVery strange.
tdietrich
08/30/2021, 9:05 PMBased on my notes, they're essentially the same table.
tdietrich
08/30/2021, 9:05 PMtransactionShippingAddressbook might also help.
tdietrich
08/30/2021, 9:05 PMAnyway, good luck!
👍 1
3 Views