Query the JobStatusTracker (JST) table via .tables().jobStatusTrackers().
Filter on trackerType() / status() using the TrackerType / TrackerStatus enums (net.pricefx.domain.JobStatusTracker).
in() isn't supported for enum columns, for multiple values, combine several .equal() checks with exprs.or() (PFUN-35753).

Code

def qapi = api.queryApi()
def exprs = qapi.exprs()
def jst = qapi.tables().jobStatusTrackers()

return qapi.source(jst, [jst.id(), jst.jobName(), jst.trackerType(), jst.status(), jst.processingStart(), jst.processingEnd()],
        exprs.and(
                jst.trackerType().equal(net.pricefx.domain.JobStatusTracker.TrackerType.CALCULATIONFLOW),
                jst.status().equal(net.pricefx.domain.JobStatusTracker.TrackerStatus.FAILED)
        ))
        .stream { it.toList() }

Query JobStatusTracker (JST) by Type and Status

Code