ServiceDesk Lite
An internal ticketing system with roles, a status workflow, and a change history.
ServiceDesk Lite is a demo internal system for handling employee tickets: roles, a status workflow, comments, and a full change history for every ticket.
The problem
Internal technical tickets often live in chats or email: it's hard to track status, who's handling what, and what's already been done — history gets lost, and access to other people's tickets isn't restricted at all.
The solution
ServiceDesk Lite gives employees and admins separate roles, a clear ticket status workflow, comments, and a full change history, with data access restricted at the database level (row-level security) rather than only by interface checks.
Key features
- 01Employee and admin roles
- 02Ticket status workflow
- 03Employee registry
- 04Ticket comments
- 05Change history (activity log)
- 06Ticket dashboard
- 07Database-level data access control (RLS)
Interface
Architecture
A Next.js application with a role model (employee/admin), a ticket status workflow, and a change history. Data access is restricted at the PostgreSQL level (row-level security), not only by checks in the application code.
Verification
0
Lint
findings
0
Typecheck
errors
572 / 572
Unit tests (Vitest)
passed, 49 files
Successful
Build
8 / 8
E2E smoke (Playwright)
passed
Limitations of this demo
- — A demo implementation: no real company employees or tickets are processed.
- — Scenarios involving the real production auth provider were verified manually, separately from the automated runs, not by the full CI matrix.
Links
Next project
DocuMindHave a similar task?
Describe it in your own words — I'll reply with how I'd approach it.