FlowInquiry Release

This release introduces new reporting capabilities, improved real-time updates using Server Sent Events (SSE), and enhanced project management features such as iteration closing and project status events. It also includes improvements to email notifications, multi-tenant handling, build infrastructure, and overall user experience. Several documentation updates and dependency upgrades were also included to improve developer productivity and platform stability.

What's Changed

Features

• feat(reporting): add aggregated ticket reports and UI support by @haiphucnguyen in #302
• feat(reporting): add aging report of tickets by @MrChatterjee98 in #283
• feat(project): enable public read-only access to FlowInquiry project board by @caominhduc52 in #279
• feat(project): add project status change events by @MrChatterjee98 in #265
• feat(iteration): add close iteration controller and UI button by @MrChatterjee98 in #258 and #276
• feat(iteration): add sprint iteration name generator service by @MrChatterjee98 in #257
• feat(export): support exporting projects to CSV and Excel by @hetpatel14 in #288
• feat(email): add email watchers for overdue tickets by @anurrags in #246
• feat(email): introduce email job scheduling service and table by @larry-ca in #263

Improvements

• refactor(events): replace WebSocket with Server Sent Events (SSE) for real-time updates by @haiphucnguyen and @minhnguyen-ai in #255, #260, #291
• refactor(email): improve email sending workflow by @caominhduc52 in #278
• refactor(tenant): improve multi-tenant handling and async task propagation by @haiphucnguyen in #251 and #254
• refactor(core): remove JHipster dependency and revamp core modules by @haiphucnguyen in #308
• refactor: improve type safety, code structure, and dependency management by @haiphucnguyen in #292
• perf: add database index for overdue tickets by @caominhduc52 in #282
• ui: improve portal layout, styling, and overall UX by @haiphucnguyen in #298 and #301
• build: improve build pipeline, Docker multi-platform builds, and deployment by @haiphucnguyen in #295, #306, #307

Fixes

• fix(liquibase): resolve production migration failures for tenant seed data by @haiphucnguyen in #303
• fix(ci): resolve CI pipeline failures on forked PRs by @haiphucnguyen in #264
• fix(frontend): fix frontend build issues by @haiphucnguyen in #305

Docs

• docs: add scheduler job creation guideline by @haiphucnguyen in #245
• docs: update integration test documentation by @haiphucnguyen in #247
• docs: add dynamic query usage guide for backend by @haiphucnguyen in #284

Dependencies

• deps: upgrade project dependencies and commands by @minhnguyen-ai and @haiphucnguyen in #244 and #262
• security: upgrade Next.js to address CVE-2025-66478 by @haiphucnguyen in #285

Contributors

Thanks to the following contributors for this release:

• @haiphucnguyen
• @minhnguyen-ai
• @MrChatterjee98
• @caominhduc52
• @larry-ca
• @anurrags
• @hetpatel14

Full Changelog: v1.2.3...v1.2.4

✅ Release Notes

This update includes new testing coverage, project settings improvements, Slack integration, and several backend and frontend fixes.

🧪 Testing & Code Quality

• Added more backend integration tests, including coverage for epic and iteration services (#227, #228, #229, #235, #240, #242)
• Added more Playwright tests for frontend and project flows (#221, #222, #223)
• Integrated JaCoCo reporting and collected report files (#225)

⚙️ Project Settings & Navigation

• Introduced the project settings page (#233, #237)
• Embedded project settings into the project entity (#238)
• Linked project section into the main navigation (#239)
• Added project listing page for users (#241)

📦 Dependency Upgrades

• Upgraded to Tailwind CSS v4 (#219)
• Upgraded to Zod v4 (#236)
• Updated Spring AI dependencies (#234)

🔧 Backend & Frontend Fixes

• Fixed workflow validation issues (#218)
• Fixed frontend compilation issues (#220)
• Applied minor UI and backend query fixes related to project settings (#233)

💬 Integration

• Added Slack service integration (#207)

📖 Documentation & OpenAPI

• Enabled OpenAPI docs for the dev profile (#230)
• Added API docs links in UI and backend section (#231, #232)
• Updated various documentation files (#224)

🧱 Build & Workflow

• Fixed GitHub workflow issues (#226)

📦 Full Changelog

Compare v1.2.2...v1.2.3

✨ New Features

• Add backend support for project management (#196)
• Add new frontend entities for project features (#197)
• Set project navigation based on project short name (#198)
• Add parent ticket ID field, update entities, mappers, and relationships (#195)
• Support project-level ticket numbers and reorganize Liquibase data (#199)
• Add project task views and fix missing attributes when fetching cached values (#208)

🧪 Testing & Developer Experience

• Integrate Spring TestContainers library (#200)
• Add Playwright end-to-end tests (#204)
• Add Playwright tests for user roles and integration tests for authority service (#206)
• Update Playwright developer guidelines (#205)

☁️ DevOps & Deployment

• Add Kubernetes deployment support with Helm and Terraform (#174)
• Update Helm installation script and related documentation (#194)

🛠 Improvements & Fixes

• Refactor team request model to generic ticket entities (#193)
• Fix style issues (#173)
• Upgrade Gradle wrapper (#177)
• Update package dependencies (#180)
• Update release version (#175)

📚 Documentation

• Update and reorganize general documentation (#172)
• Update doc links (#192)
• Add step-by-step manual installation guide using scripts (#202)
• Update project management documentation (#209)

📦 Full Changelog

Compare v1.2.1...v1.2.2

🚀 Release Notes – v1.2.1

🛠️ Bug Fixes & Improvements

• Fix issue where frontend Docker failed to run; updated README and documentation (#157)
• Fix bash script command compatibility and Docker port exposure issues (#158)
• Minor UI bug fixes across the application (#163)
• Bug fix for saving project tasks without SLA; Kanban board now refreshes after task creation (#164)
• Various backend issue fixes for improved stability (#165)
• Add missing localized text for better i18n coverage (#166)
• Fix incorrect ticket count by date range (#167)
• Refresh avatar immediately after user uploads a new one (#168)
• Fix sidebar menu display issues (#169)
• General cleanup and update (#170)

💻 Developer Experience

• Use openssl to generate a random string that works across all tested environments (#171)

📦 Full Changelog

Compare v1.2...v1.2.1

🚀 Release Notes – v1.2

🎉 New Features

• Project Iteration and Epic Management

  • Create and manage iterations and epics within projects to better organize tasks.
  • Edit iterations and epics directly in the task form.
  • Full backend API and schema support for project iterations and epics.
    🧩 Related PRs: #105, #109, #142

• Task Estimation Field

  • New field to capture estimated effort per task, enhancing sprint planning and workload management.
    🧩 Related PR: #106

• SMTP Configuration via UI

  • Configure email (SMTP) settings directly from the admin panel.
  • Enables sending registration emails, ticket notifications, and workflow alerts.
    🧩 Related PRs: #126, #130

• Version Management and Upgrade Notification

  • Version tracking feature added to inform users about new FlowInquiry versions.
    🧩 Related PRs: #145, #147

⚡ Performance & Optimization

• Java Mail Refactor & GreenMail Testing

  • Refactored mail service for better flexibility and introduced GreenMail for integration testing.
    🧩 Related PR: #144

• Form Handling Enhancements

  • Improved UX and validation for date fields and timezone adjustments across forms.
    🧩 Related PRs: #143, #146

🔬 Testing & Reliability

• Team Request Integration Tests

  • Updated integration tests to reflect new team request workflows and behavior.
    🧩 Related PR: #112

• Fixes to Backend Integration Tests

  • Addressed test failures caused by backend model changes.
    🧩 Related PR: #133

🛠️ Bug Fixes & Improvements

• Build System Fixes

  • Resolved backend build issues, classpath problems, and annotation conflicts.
    🧩 Related PR: #107

• Fix Docker Build for Frontend

  • Improved Docker build scripts to properly handle frontend applications.
    🧩 Related PR: #156

• Windows Support for CLI Scripts

  • Updated shell scripts to run smoothly on Git Bash for Windows.
    🧩 Related PR: #118

• Standardized Frontend Build Commands

  • Added unified Next.js build commands to ensure consistent builds across frontend projects.
    🧩 Related PR: #117

• Localization Enhancements

  • Improved i18n support and localization coverage across the frontend and project views.
    🧩 Related PRs: #119, #124, #134, #139, #141

📌 Other Updates

• Monorepo Migration

  • Merged all projects (backend, frontend, documentation, and ops tools) into a single monorepo under flowinquiry/flowinquiry.
    🧩 Related PRs: #115, #125

• Documentation Overhaul

  • Updated all documentation to reflect the monorepo structure and improve developer onboarding.
  • Added a dedicated Backend Data Layer guide and updated Docker setup instructions.
    🧩 Related PRs: #110, #116, #127, #128, #131, #132, #140

• Docker Compose Setup

  • Added scripts to install and launch FlowInquiry with Docker Compose easily.
    🧩 Related PRs: #148, #149, #150, #151, #152, #153

🙌 New Contributors

We’d like to welcome and thank our newest contributors:

• @MrChatterjee98 – Estimation feature, Team request integration tests
• @minhnguyen-ai – Backend integration test fixes, documentation improvements

Thank you for your valuable contributions! 🎉

Full Changelog: v1.1...v1.2

Let us know if you have any feedback or suggestions!
Want to contribute? Check out the FlowInquiry GitHub repo.

🚀 Release Notes - Latest Update

🎉 New Features

• Project Management Feature - Introduced full support for project management, including:

  • Kanban Board - Manage tasks visually with drag-and-drop functionality.
  • Real-Time Notifications - Receive updates instantly when projects are created or modified.
  • Statistical Data & Insights - Track project performance with enhanced analytics.
  • API & Database Support - Added necessary backend APIs and database changes to support project management.
  • Navigation Enhancements - Improved project navigation for a seamless experience.

  Related Pull Requests:

  • #86 - Add project module
  • #88 - Project management queries
  • #92 - Notification support
  • #94 - Project user APIs
  • #98 - Project navigation API

⚡ Performance & Optimization

• Second-Level Cache for Hibernate - Improved query performance with caching. #87
• Query Caching for Efficiency - Optimized frequently used queries. #100

🔬 Testing & Reliability

• Integration Tests for Project Service - Ensured stability with new integration tests. #89

🛠️ Bug Fixes & Improvements

• Fixed Query Utilities - Addressed inconsistencies in query handling. #95
• Fixed Predefined Date Handling - Resolved date-related issues. #96
• Fixed Team Request Navigation - Improved navigation for project-related requests. #97
• Corrected Overdue Ticket Count Query - Fixed inaccurate overdue ticket counts. #99

📌 Other Updates

• Updated Contributors Section - Added acknowledgments for new contributors. #91

Let us know if you have any feedback! 🚀

New Contributors

• @Norphy made their first contribution in #87

Full Changelog: v1.0...v1.1

🚀 Release Notes - v1.0

🎉 New Features

• Enhanced Notification System

  • Notifications are now saved before being sent via WebSocket to ensure reliability.
  • Introduced SLA-based workflow notifications for better tracking of pending tasks.
  • Added more attributes to watchers to improve tracking and visibility of ticket updates.

  Related Pull Requests:

  • #72 - Require notifications to be saved before sending
  • #73 - Workflow SLA notifications
  • #75 - Added watchers and fixed datetime inconsistency
  • #76 - Added more attributes to watchers

🛠️ Bug Fixes & Improvements

• Build System Fixes

  • Resolved Spring Data warning: "No constructor parameter names discovered".
  • Fixed type compatibility issues affecting data persistence.

  Related Pull Requests:

  • #69 - Fixed Spring Data warning
  • #74 - Fixed type compatibility issue

• Watcher & Ticket Updates

  • Ensured users who create new team requests are not automatically added to the watcher list unless explicitly assigned.
  • Improved data selection based on date range filtering.

  Related Pull Requests:

  • #77 - Select data per date range
  • #83 - Prevent automatic watcher assignment

• Data & Integration Testing Enhancements

  • Added sample data for testing environments.
  • Implemented integration tests for the Team Service to improve stability.

  Related Pull Requests:

  • #70 - Added sample data
  • #71 - Added integration tests for Team Service

🎉 Version Release

• Official Release of v1.0 🎉 - Marking a stable version milestone with improved features and optimizations.
  • #84

👏 New Contributors

We welcome our new contributors who made their first contributions:

• @jonnypark-code - #69
• @larry-ca - #83

Thank you for your valuable contributions! 🚀

Full Changelog: v0.9...v1.0

Description

🎉 Introducing FlowInquiry v0.9! This is the first public release, bringing a powerful workflow automation system designed for team collaboration and request management as an alternative solution of Jira, Zendesk, etc.

Key Features:
✅ Dynamic Workflows – Define and automate request workflows with transitions and SLAs.
✅ Team Requests Management – Track and manage customer requests assigned to teams.
✅ Role-Based Access Control – Secure access with fine-grained permissions.
✅ Spring Boot Backend – High-performance backend with PostgreSQL.
✅ Liquibase Migrations – Seamless database versioning.
✅ Real-time Notifications – Stay updated instantly with live system alerts.

Why v0.9?
🚀 This release sets the foundation for a stable and scalable system. While the core functionality is in place, we are actively improving and adding more features based on user feedback.

What's Next? (v1.0 Roadmap)
🔹 Enhanced workflow notifications, live alerts
🔹 Improving AI models integration, work with offline models

💡 Try it out, explore the features, and share your feedback! Your insights will help shape FlowInquiry into the best workflow automation tool. 🚀

New Contributors

• @minhnguyen-ai made their first contribution in #66