Is there not any way to get account name out of N/...
# suitescriptk
Kris Wood
04/25/2021, 2:15 AMIs there not any way to get account name out of N/query? If I try getting account.acctname it says not exposed. If I try any of the other account name related fields in the Analytics UI they all say they're for search context only. >.<
b
battk
04/25/2021, 2:17 AMguessing ids is a poor way to get data
battk
04/25/2021, 2:17 AMbuild your query in the ui and copy the columns it uses
k
Kris Wood
04/25/2021, 2:17 AMNot trying to get the ID on this part, trying to get the account name for creating the account in the other sandbox
b
battk
04/25/2021, 2:17 AMor use the records catalog
k
Kris Wood
04/25/2021, 2:18 AMyes, that's what I did. Built it in the UI, coped the SQL, ran it in N/Query, got the error
Kris Wood
04/25/2021, 2:18 AMcopied*
Kris Wood
04/25/2021, 2:19 AMCan't create a new Account record without a value for the Name field.
b
battk
04/25/2021, 2:19 AMwhat was the query you copied
k
Kris Wood
04/25/2021, 2:26 AMUntitled
Kris Wood
04/25/2021, 2:26 AMThose are the columns
Kris Wood
04/25/2021, 2:27 AMaccountcontextsearch.acctnameKris Wood
04/25/2021, 2:27 AMthe others say not exposed
Kris Wood
04/25/2021, 2:27 AMI copied the joins, too
b
battk
04/25/2021, 2:29 AMcant really give you much
battk
04/25/2021, 2:29 AMdont know the tables
battk
04/25/2021, 2:29 AMor the joins
k
Kris Wood
04/25/2021, 2:33 AMThanks anyway 🙂
b
battk
04/25/2021, 2:33 AMas in you didnt give the information
7 Views