294
1, // page size arg
295
)
296
>
case filter.RunID != nil && filter.MinTime != nil && filter.MaxTime != nil && filter.PageSize != nil:
visibility.go
297
>
// pagination filters
298
>
*filter.MinTime = convertToDbDateTime(*filter.MinTime)
299
>
*filter.MaxTime = convertToDbDateTime(*filter.MaxTime)
300
>
whereClauses = append(
301
>
whereClauses,
302
>
fmt.Sprintf("%s >= ?", sadefs.GetSqlDbColName(timeAttr)),
303
>
fmt.Sprintf("%s <= ?", sadefs.GetSqlDbColName(timeAttr)),
304
>
fmt.Sprintf(
305
>
"((%s = ? AND %s > ?) OR %s < ?)",
306
>
sadefs.GetSqlDbColName(timeAttr),
307
>
sadefs.GetSqlDbColName(sadefs.RunID),
308
>
sadefs.GetSqlDbColName(timeAttr),
309
>
),
310
>
)
311
>
queryArgs = append(
312
>
queryArgs,
313
>
*filter.MinTime,
314
>
*filter.MaxTime,
315
>
*filter.MaxTime,
316
>
*filter.RunID,
317
>
*filter.MaxTime,
318
>
*filter.PageSize,
319
>
)
320
default:
321
return fmt.Errorf("invalid query filter")