--- id: Exasol Administration Essentials aliases: [] tags: - process/project - process/course status: Archiv subtitle: Exasol Administration Essentials --- >[!info]- Projekt >Goal:: >Progress:: `$= dv.view('project-progress', {file: 'Exasol Administration Essentials'})` >Target:: `$= dv.view('project-target', {file: 'Exasol Administration Essentials'})` >Bar:: `$= dv.view('project-progress-bar', {file: 'Exasol Administration Essentials'})` >Tasks:: `$= const aufgaben = dv.page('Exasol Administration Essentials').file.inlinks.where(t => { const mt = dv.page(t.path); return mt.tags?.includes('process/task') && mt.status === 'In Arbeit'}); if (aufgaben.length > 0) { dv.header(4, aufgaben.length > 1 ? "Aufgaben" : "Aufgabe"); dv.list(aufgaben) }` ## Project Info ## Thoughts ## Resources https://exacademy.exasol.com/courses/course-v1:Exasol+ADMIN+X/course/ ## Review questions Zertifizierung ist erst erforderlich, wenn Kunde dies fordert. ## Aufgaben - [x] Kurseinführung abgeschlossen [start:: 2024-02-27] [due:: 2024-02-28] [completion:: 2024-02-28] - [x] Kurs Exasol Administrator Essentials durcharbeiten [start:: 2024-02-28] [completion:: 2024-02-28] - [x] Ist Zertifizierung erforderlich [start:: 2024-02-28] [scheduled:: 2024-03-11] [completion:: 2024-03-12] ## Offene Aufgaben ```dataviewjs const pages = dv.current().file.inlinks.where(p => dv.page(p.path).tags?.includes('process/task')).where(p => dv.page(p.path).file.tasks.length != dv.page(p.path).file.tasks.where(t => t.fullyCompleted === true).length); dv.table(["Project", "Status", "Completed", "Tasks"], pages.map(p => { const page = dv.page(p.path); const tasks = page.file.tasks; return [ page.file.link, page.status, tasks.where(t => t.fullyCompleted === true).length, tasks.length ] })); ``` ## Aufgaben ```dataviewjs const pages = dv.current().file.inlinks.where(p => dv.page(p.path).tags?.includes('process/task')); dv.table(["Project", "Status", "Completed", "Tasks"], pages.map(p => { const page = dv.page(p.path); const tasks = page.file.tasks; return [ page.file.link, page.status, tasks.where(t => t.fullyCompleted === true).length, tasks.length ] })); ```