167
}
168
170
>
for i, field := range sqlplugin.DbFields {
171
>
dbFields[i] = "ev." + field
172
>
}
173
175
>
if len(whereClauses) > 0 {
176
whereString = " WHERE " + strings.Join(whereClauses, " AND ")
177
}
178
180
>
"SELECT %s FROM executions_visibility ev "+
181
>
"LEFT JOIN custom_search_attributes USING (%s, %s) "+
182
>
"LEFT JOIN chasm_search_attributes USING (%s, %s)"+
183
>
"%s "+
184
>
"ORDER BY %s DESC, %s DESC, %s LIMIT ?",
185
>
strings.Join(dbFields, ", "),
186
>
sadefs.GetSqlDbColName(sadefs.NamespaceID),
187
>
sadefs.GetSqlDbColName(sadefs.RunID),
188
>
sadefs.GetSqlDbColName(sadefs.NamespaceID),
189
>
sadefs.GetSqlDbColName(sadefs.RunID),
190
>
whereString,
191
>
sqlparser.String(c.GetCoalesceCloseTimeExpr()),
192
>
sadefs.GetSqlDbColName(sadefs.StartTime),
193
>
sadefs.GetSqlDbColName(sadefs.RunID),
194
>
)
195
>
queryArgs = append(queryArgs, pageSize)
196
>
197
>
return stmt, queryArgs
198
}
199