func getJobs()

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))
    }