hi, i've seached for a few minutes to try and find...
# general
s
hi, i've seached for a few minutes to try and find good beginner level resources from a dev standpoint but not quite finding what i'd like . . . i get to detailed NS PDFs or high-level UI functionality . . . i'm looking for suite spot that can answer questions like: what's the basic database model? (like the schema browser is confusing to MS SQL dev and keys/related tables are not clear to me) what's the basic overview from dev point of view of the world salad items like SuiteQL, SuiteAnalytics, SuiteTalk and so on? or should i just power thru the NS pdfs and mine what i can out of them?
s
Depends what your goal, why are you looking for this information?
s
i'm joining dev effort that has a lot of restlet and code integration . . . i function best with big picture explanations of noun-verb combos with gotcha sidebars before i look at code here's a specific example -- when i query the transactions table there is a field
billingaddress
. . . using the schema/record/connect/analytics browser pages i can't quite correlate how/where it relates . . . in MS SQL there would be a FK and you could see it pointing to address or billingaddress table . . . in this case those tables do not exist (there are customeraddressbook etc) . . . if i use the BUILTIN-DF i can get related data but i can't figure out where it's cominng from and how the docs would tell me that . . . so probably a super basic issue where MS background or just not smart enough hobbling me 😄
s
As far as the word salad, most of the names are pretty indicative of what areas they represent. SuiteQL is literally a query language to query information from Netsuite. SuiteAnalytics is more related the Analytics page/engine that exists in Netsuite, which runs on SuiteQL behind the scenes. SuiteTalk is talking between netsuite and other systems, SOAP/rest api to send/receive between systems. For pure development, join #C29HQS63G, ask questions there. https://netsuiteprofessionals.slack.com/archives/C29HQS63G/p1620064572272500?thread_ts=1620053229.265600&cid=C29HQS63G
🙌 1
For more query related stuff (which is what it sounds like you really care about), follow @tdietrich blog. https://timdietrich.me/blog/ tons of query related info there
Specific small questions like the one you asked, I would post/ask in #C01FBBZ8PQC
s
thanks much @Sandii . . . i found tdietrich stuff which helped me get a hello-world js trigger for fun but still missing some big picture stuff unable to drag tables onto diagram surface and get the magical picture i want the way i'm used to doing it LOL . . . guess that's why it's learning . . .thanks so much for the boost much appreciated!!
s
yep that barrier to entry can be kind of steep, netsuite tends to be more of a platform that you learn by doing, but also ask plenty of questions. That is one of the major points of this group, if you are struggling with smoething, odds are someone else has as well.
👍 1
k
Addresses. Suck.
Just as a general warning
😄 2
haha