class PipelineRunDao extends NamedParameterJdbcDaoSupport {

    @Transactional(propagation = Propagation.SUPPORTS)
    public List<PipelineRun> loadPipelineRuns(List<Long> runIds) {
        if (runIds.isEmpty()) {
            return new ArrayList<>();
        }
        MapSqlParameterSource params = new MapSqlParameterSource();
        params.addValue(LIST_PARAMETER, runIds);
        addTaskStatusParams(params);
        return getNamedParameterJdbcTemplate().query(loadPipelineRunsWithPipelineByIdsQuery,
                params,
                PipelineRunParameters.getExtendedRowMapper());
    }

}