Hi @Andrew Sklyarov 

Thanks a lot for the kind words and for pointing that out!
You're absolutely right — starting the query with WHERE 1=1 is a smart and simple way to handle dynamic conditions without worrying about when to add WHERE or AND. It definitely makes the code cleaner.

As for %Execute, yes, managing the parameters dynamically is still a bit tricky since the number of placeholders needs to match the inputs. Building the parameter list on the fly could work, but it does add a bit of extra logic.

👋 Hello everyone!

I'm Muhammad Waseem, currently working as a Technical Consultant specializing in healthcare data transformation, clinical trials systems, and AI-driven applications using InterSystems IRIS.

I’ve been part of the InterSystems Global Summit for several years now, and I’m excited to be attending READY 2025 as well!
I’m particularly focused on projects involving FHIR, HL7, and RAG-based solutions using vector search.

Looking forward to connecting, learning, and sharing ideas with this amazing community!

Let’s connect on LinkedIn:
🔗 linkedin.com/in/muhammad-waseem-21259020