Doing an opportunity search and need to get the en...
# suitescriptn
Nick
12/10/2020, 8:17 PMDoing an opportunity search and need to get the entity type such as partner or customer for if statement. How can I do that through the search and not do a lookupfields
s
stalbert
12/10/2020, 8:21 PMSuiteQL? join anything you want there it seems.
n
Nick
12/10/2020, 8:26 PMCan't in this instance.
s
stalbert
12/10/2020, 8:31 PMcan't do SuiteQL or can't do the join?
b
battk
12/10/2020, 8:35 PMnot really sure how you get a partner in the entity field
battk
12/10/2020, 8:36 PMbut you can probably use the customer join to get the stage or status
n
Nick
12/10/2020, 8:38 PMokay, i'll try that @battk
Nick
12/10/2020, 8:38 PM@stalbert can you use that in a suitelet?
s
stalbert
12/10/2020, 8:39 PMI think you can use SuiteQL in all server side scripts
stalbert
12/10/2020, 8:40 PMthough I haven't tried in a suitelet. The main reason I suggest it is it allows you maximum flexibility in joining in data from other tables.
n
Nick
12/10/2020, 8:41 PMgot ya, i'll look into it
m
michoel
12/10/2020, 11:29 PMYou can absolutely use SuiteQL in a suitelet and in client side scripts too
s
stalbert
12/10/2020, 11:44 PMI almost hate SQL, but it seems SuiteQL is such a leap forward compared to the prior alternatives I intend to start using it everywhere I can.