If you create a saved search based on say Record A...
# suitescriptm
mg2017
07/25/2023, 4:09 PMIf you create a saved search based on say Record A, but you cannot access fields from Record B as there is no relationship between the two records, would it be possible to access Record B fields from a Record A search if we build it in a script?
s
Shawn Talbert
07/25/2023, 4:11 PMYes, via SuiteQL you can do ad-hoc joins.
m
mg2017
07/25/2023, 4:15 PMThanks. But does it have to be SuiteQL?
s
Shawn Talbert
07/25/2023, 4:17 PMYou might be able to do ad-hoc joins with plain N/query - I'm not sure. With the rise of SuiteQL I don't ever do imperative N/query searches.
Shawn Talbert
07/25/2023, 4:18 PMBut traditional N/search cannot do ad-hoc joins AFAIK
Shawn Talbert
07/25/2023, 4:18 PMthis is one of the killer features of SuiteQL, IMHO
👍 1
m
mg2017
07/25/2023, 4:29 PMSuiteQL is native NS and not third party?
s
Shawn Talbert
07/25/2023, 4:31 PMYes
Shawn Talbert
07/25/2023, 4:31 PMType 'SuiteQL' into NS help
Shawn Talbert
07/25/2023, 4:31 PMor wait for the batk help link AI to respond.
👌 1
🤭 2
m
mg2017
07/25/2023, 4:32 PMThanks