Anyone have an example of SuiteQL using

appliedtotransaction

join?

I think you need instead the nextlinks and previouslinks from here

I saw that but wasn't sure. I ended up just using a saved search but maybe I'll research a bit more.

it’s worth the research, cause query is so far more superior. however, i found it lacking as well, since certain types just don’t show up for some reason (just earlier today I was asking about Fulfillment Requests - these are an exception, apparently)

Agree. Document fields and others are still missing too.