Anyone know how to get the list of contacts associ...
# suiteqlc
Cory Weiner
07/11/2023, 6:42 PMAnyone know how to get the list of contacts associated with an opportunity? I can’t seem to find any table that maps the two
n
Nathan L
07/11/2023, 6:59 PMI think join contact.company on transaction.entity
Nathan L
07/11/2023, 6:59 PMc
Cory Weiner
07/11/2023, 7:05 PMThat would give all contacts linked to that company. But I only want the ones listed specifically to a transaction
Cory Weiner
07/11/2023, 7:07 PMFor a customer we may have 10 different opportunities, each with a different decision maker, for example. It works fine in native netsuite UI but I can’t figure out the SuiteQL table that holds the linkage between the two
3 Views