Reviving Legacy Code: The Query Converter Journey

Not too long ago, we found ourselves facing a familiar challenge – legacy code.
Our systems relied on old Servoy raw queries, making maintenance complex and slowing us down. We knew there had to be a better way.
So, we set out on a journey to modernise and automate this process, turning outdated queries into Servoy Query Builder-cleaner, more efficient, and ready for the future of logistics.

The First Step: Gathering Knowledge

Like any great quest, we needed the right tools. We started by scraping Servoy documentation from the web using n8n. Instead of sifting through endless pages, we embedded this knowledge directly into Supabase with OpenAI API, creating a searchable, AI-powered knowledge base.
✅ Easy integration thanks to n8n’s flexibility
✅ Fast access to structured information
✅ A solid foundation for automation

The Next Step: Automating Query Conversion

With knowledge in place, the next phase is even more exciting—developing an AI-driven function that will convert raw queries into Servoy Query Builder automatically. No more manual rewrites. No more inefficiencies. Just clean, modernised code in seconds.

This is more than just an upgrade-it’s a transformation. By combining AI, automation, and intelligent workflows, we’re not just modernising our code; we’re setting the stage for a new era of logistics innovation.
And this is just the beginning.
Follow our journey as we push the boundaries of AI-driven automation at Globis Software NV. 🚀