163
}
164
166
>
if len(whereClauses) > 0 {
167
whereString = " WHERE " + strings.Join(whereClauses, " AND ")
168
}
169
171
>
`SELECT %s FROM executions_visibility%s ORDER BY %s DESC, %s DESC, %s LIMIT ?`,
172
>
strings.Join(sqlplugin.DbFields, ", "),
173
>
whereString,
174
>
sqlparser.String(c.GetCoalesceCloseTimeExpr()),
175
>
sadefs.GetSqlDbColName(sadefs.StartTime),
176
>
sadefs.GetSqlDbColName(sadefs.RunID),
177
>
)
178
>
queryArgs = append(queryArgs, pageSize)
179
>
180
>
return stmt, queryArgs
181
}
182