const existingDetails = await db
.select({
id: reports.id,
name: reports.name,
linkedFileID: reports.linkedFileID,
effectiveDate: reports.effectiveDate,
uploadedBy: reports.uploadedBy,
lastUpdated: reports.lastUpdated,
createdOn: reports.createdOn,
nextRelease: reports.nextRelease,
templateName: fileUpload.originalFileName,
})
.from(reportDetails)
.where(eq(reportDetails.name, reportName))
.leftJoin(fileUpload, eq(reportDetails.template, fileUpload.id));
const existingDetails = await db
.select({
id: reports.id,
name: reports.name,
linkedFileID: reports.linkedFileID,
effectiveDate: reports.effectiveDate,
uploadedBy: reports.uploadedBy,
lastUpdated: reports.lastUpdated,
createdOn: reports.createdOn,
nextRelease: reports.nextRelease,
templateName: fileUpload.originalFileName,
})
.from(reportDetails)
.where(eq(reportDetails.name, reportName))
.leftJoin(fileUpload, eq(reportDetails.template, fileUpload.id));