Function getDocumentMetadataByIds

apps/sim/app/api/knowledge/search/utils.ts:19–49

(
  documentIds: string[]
)

 * indicate the document is no longer visible and should be skipped.
 */
export async function getDocumentMetadataByIds(
  documentIds: string[]
): Promise<Record<string, DocumentMetadata>> {
  if (documentIds.length === 0) {
    return {}
  }

  const uniqueIds = [...new Set(documentIds)]
  const documents = await db
    .select({
      id: document.id,
      filename: document.filename,
      sourceUrl: document.sourceUrl,
    })
    .from(document)
    .where(
      and(
        inArray(document.id, uniqueIds),
        eq(document.userExcluded, false),
        isNull(document.archivedAt),
        isNull(document.deletedAt)
      )
    )

  const map: Record<string, DocumentMetadata> = {}
  documents.forEach((doc) => {
    map[doc.id] = { filename: doc.filename, sourceUrl: doc.sourceUrl ?? null }
  })

  return map
}

export interface SearchResult {
  id: string