go to post Pietro Di Leo · 7 hr ago Hi Timo, thank you for your response and clarifications! As I wrote to Jolyon now is it clearer how %d and %old variables work in OnSQLTrigger UDFs.
go to post Pietro Di Leo · 8 hr ago Hi Jolyon, thanks for the clarifications. I'm quite experienced with Feature Framework but I've never worked with OnSQLTrigger UDFs and felt confused about them, mostly due to some information I received and probably misread. Now it is more clear and sounds logic to me that variables %d and %old can't be overwritten, as well as %response and %session, I suppose. What I'm trying to do is to force the default value of a boolean property of a questionnaire to be 1 on insert. I was trying with OnSQLTrigger because I can't modify the Region model of the questionnaire to set a Custom default value, nor use an OnAfterSave UDF because I can't know if the questionnaire has never been inserted, and not even an OnBeforeSave because I noticed that, for whatever reason, TrakCare API calls don't trigger them.
go to post Pietro Di Leo · Feb 12 Hi David, unfortunately it is impossible to modify the initial expression of that value. Because of the TrakCare framework, the particular class whose property belongs is automatically generated and, I don't know if it is possible for core team, but I'm not allowed to modify it.
go to post Pietro Di Leo · Feb 2 Hi Vachan, thanks for your reply. Unfortunately we don't always have SSH access to our clients' machines, so this can't be applied. With this question I intended if there is anything in VSCode lke the Export Project feature in Studio. Currently, the only solution I've found is building a custom API to do this and a UI to interact with it, but it must be installed on the machine.
go to post Pietro Di Leo · Jan 29 Hi, about the backend language, what do you mean by saying: Develop a full-stack solution using InterSystems IRIS, InterSystems IRIS for Health, or IRIS Cloud Service as a backend. By full stack, we mean a frontend web or mobile application that inserts, updates, or deletes data in InterSystems IRIS via REST API, Native API, ODBC/JDBC, or Embedded Python. For example, is it allowed to implement the application backend completely through irisnative python package or REST API or PEX, without any line of ObjectScript or Embedded Python? Moreover, should the application be able to perform every CRUD operation or is it fine to perform just a few, like only insert and update?
go to post Pietro Di Leo · Jan 4 Hi Nicki, I hope I will be able to publish soon the second part of this articles serie in which I describe how to setup the whole instance with web applications, namespaces, interoperability and databases through a manifest file. Stay tuned.
go to post Pietro Di Leo · Dec 13, 2025 Hello, my iris_io_utility has two related YouTube videos as you can see on Open Exchange. Moreover, what do you mean for online demo? A release of my VS Code extension is available on the GitHub page and can be downloaded and installed, as well as other VS Code extensions in this contest.
go to post Pietro Di Leo · Dec 12, 2025 Thanks Antonio, this is a great point! Maybe in the next version it will be possible
go to post Pietro Di Leo · Dec 7, 2025 Hi @Anastasia Dyubaylo! I’ve published a new application on Open Exchange (iris-io-utility), which is currently awaiting approval. I’m wondering if there’s a way to automatically submit it as a candidate once it’s approved or if I must wait for the submission until the app is approved. Thank you in advance!
go to post Pietro Di Leo · Dec 2, 2025 Wow! What a great news, thanks to InterSystems and congratulations to all the participants for their great ideas
go to post Pietro Di Leo · Nov 24, 2025 My idea is a docker image with all the materials to let newcomers learn properly how to code in objectscript and work with InterSystems IRIS Create a Docker image with material for | InterSystems Ideas (P.S. because of a connection issue I posted the same idea three times, the first two without a description. I couldn't see any of my posted idea so I tried multiple times to post it. Is there any way to remove the drafts?)
go to post Pietro Di Leo · Nov 6, 2025 Hi Thomas, I've just added it from the GitHub repository, I don't know why but it was missing, probably I forgot to include it when I wrote the article. Thanks for reporting it to me😊
