in Sources/XCMetricsBackendLib/UploadMetrics/Repository/PostgreSQLJobLogRepository.swift [72:84]
func getJobs(params: JobListRequest, on db: Database) -> EventLoopFuture<Page<JobLogEntry>> {
let query = JobLogEntry.query(on: db)
.filter(\.$createdAt >= params.from)
.filter(\.$createdAt <= params.to)
if let status = params.status {
query.filter(\.$status == status)
}
if let filter = params.filter {
query.filter(\.$logFile ~~ filter)
}
return query.sort(\.$createdAt, .descending)
.paginate(PageRequest(page: params.page, per: params.per))
}