Function buildFilterConditions

apps/sim/lib/logs/filters.ts:268–319

(
  params: LogFilterParams,
  options: BuildFilterConditionsOptions = {}
)

 * @returns Combined SQL condition or undefined if no filters
 */
export function buildFilterConditions(
  params: LogFilterParams,
  options: BuildFilterConditionsOptions = {}
): SQL | undefined {
  const { useSimpleLevelFilter = true } = options
  const conditions: SQL[] = []

  if (useSimpleLevelFilter && params.level) {
    const levelCondition = buildSimpleLevelCondition(params.level)
    if (levelCondition) conditions.push(levelCondition)
  }

  if (params.workflowIds) {
    const condition = buildWorkflowIdsCondition(params.workflowIds)
    if (condition) conditions.push(condition)
  }

  if (params.folderIds) {
    const condition = buildFolderIdsCondition(params.folderIds)
    if (condition) conditions.push(condition)
  }

  if (params.triggers) {
    const condition = buildTriggersCondition(params.triggers)
    if (condition) conditions.push(condition)
  }

  const { startCondition, endCondition } = buildDateConditions(params.startDate, params.endDate)
  if (startCondition) conditions.push(startCondition)
  if (endCondition) conditions.push(endCondition)

  const searchConditions = buildSearchConditions({
    search: params.search,
    workflowName: params.workflowName,
    folderName: params.folderName,
    executionId: params.executionId,
  })
  conditions.push(...searchConditions)

  if (params.costOperator && params.costValue !== undefined) {
    conditions.push(buildCostCondition(params.costOperator, params.costValue))
  }

  if (params.durationOperator && params.durationValue !== undefined) {
    const condition = buildDurationCondition(params.durationOperator, params.durationValue)
    if (condition) conditions.push(condition)
  }

  if (conditions.length === 0) return undefined
  if (conditions.length === 1) return conditions[0]
  return and(...conditions)
}