How can I get a list of contacts attached to a transaction along with their roles? I'm struggling with getting the roles specifically. I'm unable to find a join with SuiteQL, and the "contactrole" field on a transaction search returns empty. Loading the transaction record and getting the contacts sublist doesn't seem to be possible either. .getLineCount() returns 0.

you can probably get the contact to transactions via search