Can't Fetch the patient id in the admin page

[nishkarsh002]

When i'm opeing the admin page it can't fetch the patient the name of the patient is missing

[MohamdAlaa]

the problem is that in columns page the the part that should dispaly the patient name is :-
{
accessorKey: "patient",
header: "Patient",
cell: ({ row }) => {
const appointment = row.original;
console.log(appointment);

  return <p className="text-14-medium">{appointment.patient.name}</p>;
},

},

but if console the appointment like i did you will find that there is no patient.name here because if you remember we there wasn't a name input in new-appointment so you need to return the patient object in the function . so what you need to do is

• go to your lib folder => actions => appointment.actions.ts
• replace your old function => getRecentAppointmentList with this new one

// GET RECENT APPOINTMENTS
export const getRecentAppointmentList = async () => {
try {
const appointments = await databases.listDocuments(
DATABASE_ID!,
APPOINTMENT_COLLECTION_ID!,
[Query.orderDesc("$createdAt")]
);
// For each appointment, fetch the related patient data
const appointmentsWithPatients = await Promise.all(
appointments.documents.map(async (appointment) => {
try {
const patient = await databases.getDocument(
DATABASE_ID!,
PATIENT_COLLECTION_ID!,
appointment.patient
);
return {
...appointment,
patient: patient,
};
} catch (error) {
console.log(error);
}
})
);

const initialCounts = {
  scheduledCount: 0,
  pendingCount: 0,
  cancelledCount: 0,
};

const counts = appointmentsWithPatients.reduce((acc, appointment) => {
  const status = (appointment as { status?: string }).status;
  switch (status) {
    case "scheduled":
      acc.scheduledCount++;
      break;
    case "pending":
      acc.pendingCount++;
      break;
    case "cancelled":
      acc.cancelledCount++;
      break;
  }
  return acc;
}, initialCounts);

const data = {
  totalCount: appointments.total,
  ...counts,
  documents: appointmentsWithPatients,
};

return parseStringify(data);

} catch (error) {
console.error(
"An error occurred while retrieving the recent appointments:",
error
);
}
};