Cool feature!

I asked for interoperability adapters for issuing shell calls and the answer was quite objective, although the DC post reference didn't match my question (I guess)... Anyway, here is the link: https://community.intersystems.com/ask-dc-ai?question_id=218088

PS: I tried to google the same question just for fun, prefixing Intersystems to it ("intersystems is there an interoperability adapter for call programs by command line?), and didn't get any result pointing to EnsLib.Pipe.OutboundAdapter. :)

I don't know if it can make any difference, but have you tried to use the EnsLib.Pipe.OutboundAdapter adapter to issue a shell call instead of $ZF(-100)?

Hi Benjamin!

Thank you for your kind words!

Thank you for your feedback as well, we really appreciate seeing people using our apps! :)

We release a new version with some improvements:

1. When SQL executions generate error, the UI just present the error description keeping all elements, instead of the weird behavior you noticed
2. We added a new sample database available in OpenExachange - the HoleFoods in order for people to try the tool with other schemas - like you already did ;)
3. Now you can add SQL queries as examples. So if the LLM returns a wrong SQL, you can fix it and update your example library, giving a change to the tool to improve the prompt in the next related user prompts. One collection is generated per schema.

Again, thanks for your feedback!

Below, some screenshots of such improvements: