I'm looking to pull in the related transactions for a support case in SuiteQL. It seems that there is no direct link that is exposed for querying. Am I missing something? Are there any workarounds?

I assume you already tried the previous and next transaction link tables? I don't know if the case links are in there, but I'd check there if you haven't already.

pretty sure that’s just transaction to transaction

Natively I don't see a join to transactions. Have you created a custom field that refers to a specific transaction? I could see you getting a list of transactions based on a join to item and customer natively.

> pretty sure that’s just transaction to transaction I figured, but I've never actually taken the time to check. Not surprising that some of that stuff isn't exposed, given how much development time CRM and Case Management probably get in NS. 10 hours a year maybe?

@Ava you might have to use SuiteScript to go through the sublist records instead of using SuiteQL, unfortunately.

Yes, it seems like it, it doesn't look like it's exposed anywhere in suiteql. Oh well!