Dashboard — Semestre en cours

📊 Dashboard — Semestre

Vue transverse de toutes les matières. Voir aussi _MOC 4A — ESIEA.

🕒 10 dernières séances

TABLE WITHOUT ID
  file.link AS "Séance",
  matiere AS "Matière",
  date AS "Date",
  statut AS "Statut"
FROM "10 - Cours"
WHERE type = "seance"
SORT date DESC
LIMIT 10

📝 Séances encore à mettre au propre

TABLE WITHOUT ID
  file.link AS "Séance",
  matiere AS "Matière",
  date AS "Date"
FROM "10 - Cours"
WHERE type = "seance" AND statut = "brut"
SORT date DESC

🃏 Fiches à réviser

TABLE WITHOUT ID
  file.link AS "Fiche",
  matiere AS "Matière",
  statut AS "Statut"
FROM "10 - Cours"
WHERE type = "flashcards" AND statut = "à réviser"
SORT matiere ASC

❓ Toutes les questions ouvertes

TASK
FROM "10 - Cours"
WHERE !completed
GROUP BY matiere