Update the following code const [questionnaire, categories] = await…
- User
Update the following code const [questionnaire, categories] = await prisma.$transaction([ prisma.questionnaire.findFirst({ orderBy: [{ startDate: 'desc' }], where: { ...filter, approved: true, disabled: false, endDate: { gte: addDays(new Date(), -5), }, startDate: { lte: new Date(), }, isDraft: false, }, include: { questionnaireItems: { where: { disabled: false, }, include: { item: { include: { translation: true, itemMeasurements: true, }, }, }, }, questionnaireRegionStatus: { where: { regionCode: { in: regionCodes } }, }, }, }), prisma.division.findMany({ where: { disabled: false }, include: { group: { where: { disabled: false }, include: { class: { where: { disabled: false }, include: { subclass: { where: { disabled: false }, include: { translation: true, }, }, translation: true, }, }, translation: true, }, }, translation: true, }, }), ]); so that questionnaires with current date greater than endDate are not returned . Show the steps with explanation
- Assistant
Step 1: Import the
subDaysfunction from thedate-fnslibraryimport { subDays } from 'date-fns';Step 2: Replace the
endDateproperty in thewhereclause with a custom condition that checks if the current date is less than or equal to theendDateminus 5 days.endDate: { gte: subDays(new Date(), 5), lte: new Date() },This ensures that only questionnaires whose
endDateis within the last 5 days and not expired are returned.Step 3: Update the
questionnaireandcategoriesvariables to match the updated query.const [questionnaire, categories] = await prisma.$transaction([ prisma.questionnaire.findFirst({ orderBy: [{ startDate: 'desc' }], where: { ...filter, approved: true, disabled: false, endDate: { gte: subDays(new Date(), 5), lte: new Date() }, startDate: { lte: new Date(), }, isDraft: false, }, include: { questionnaireItems: { where: { disabled: false, }, include: { item: { include: { translation: true, itemMeasurements: true, }, }, }, }, questionnaireRegionStatus: { where: { regionCode: { in: regionCodes } }, }, }, }), prisma.division.findMany({ where: { disabled: false }, include: { group: { where: { disabled: false }, include: { class: { where: { disabled: false }, include: { subclass: { where: { disabled: false }, include: { translation: true, }, }, translation: true, }, }, translation: true, }, }, translation: true, }, }), ]);Explanation:
The
subDaysfunction is used to subtract 5 days from the current date and create a new date object. TheendDateproperty in thewhereclause is updated to check if it is greater than or equal to the new date object (i.e. within the last 5 days) and less than or equal to the current date (i.e. not expired). Thequestionnaireandcategoriesvariables are updated to match the updated query.
Other models, same or similar prompt
Responses were produced in different, uncontrolled contexts (system prompts, settings, prior turns). This is not a benchmark.