i am trying to use nQuery to return a list of cust...
# suitescripts
screnshaw
12/19/2019, 12:35 AMi am trying to use nQuery to return a list of customers from my script and i keep getting a permissions issue for my role. is there a special permission a role needs to use query?
b
battk
12/19/2019, 12:43 AMs
screnshaw
12/19/2019, 12:46 AMHey battk, I have that checked already
screnshaw
12/19/2019, 12:46 AMi also have perform search permission
b
battk
12/19/2019, 12:47 AMwhat error are you getting with what code
s
screnshaw
12/19/2019, 12:48 AMYOUR_CURRENT_ROLE_DOES_NOT_HAVE_PERMISSION_TO_PERFORM_THIS_ACTION
screnshaw
12/19/2019, 12:49 AMif I do a search on items it returns the items. if I do a query on items, I get that error
b
battk
12/19/2019, 12:52 AMwhat code
s
screnshaw
12/19/2019, 12:52 AMcopied and pasted what was in the N/query help docs
b
battk
12/19/2019, 1:02 AMwhat are the reports permissions for the role?
s
screnshaw
12/19/2019, 1:03 AMonly income
b
battk
12/19/2019, 1:03 AMread the docs harder
battk
12/19/2019, 1:03 AM Copy code
To provide SuiteAnalytics Workbook access to users assigned to a custom role, add the SuiteAnalytics Workbook permission to the role and set the access level to Edit on the Reports subtab of the Permissions tab.s
screnshaw
12/19/2019, 1:05 AMI read that 5 times and somehow missed that. Thanks!
screnshaw
12/19/2019, 1:25 AMso i'm working on a query. I'm searching for all items, and wanting to filter on inventory location where subsidiary = 2. Is this something a query can do?
b
battk
12/19/2019, 1:57 AMyou are doing a lot of work for something you can use 2 searches for
s
screnshaw
12/19/2019, 2:00 AMwas hoping that I could just do one search. Currently i'm going to have to do a search for the itme, and then for the locations
screnshaw
12/19/2019, 2:00 AMwhich it's simple, so yeah, you're probably right.
just wasn't sure if I would be able to make one query and filter on memberitem.location.subsidiary = 2
b
battk
12/19/2019, 2:02 AMsame rules for search apply
battk
12/19/2019, 2:02 AMmake the query in the ui
battk
12/19/2019, 2:02 AMthen convert it to code
s
screnshaw
12/19/2019, 2:02 AMi'm quite new to queries, but where do you make a query via ui?
b
battk
12/19/2019, 2:03 AMs
screnshaw
12/19/2019, 2:04 AMwell that's a lot more complicated lol
screnshaw
12/19/2019, 2:04 AMmore complicated than a search*
screnshaw
12/19/2019, 2:12 AMhow do I convert it to code? chrome extension?
b
battk
12/19/2019, 2:24 AMtrial/error after reading all of the N/query documentation
battk
12/19/2019, 2:24 AMalternatively load the query in suitescript and explore how it looks like
3 Views