go to post José Pereira · Oct 29 Interesting... The method exports User definitions, Role definitions, and Privileges by default, so it's kind working. Did you tried to pass the value "*" to parameters Schema and Table to test it on all schemas and table into your namespace? Also make sure you are in the correct namespace.
go to post José Pereira · Oct 28 Hi! I don't know how to achieve this by using Portal directly, but you can export SQL schema using this method in Cache. Just for note, in IRIS you also have this another option. HTH
go to post José Pereira · Sep 3 Hi @Ashok Kumar However, starting with version 2024.2, the IRIS installer no longer includes Python installation by default. This is true just for Windows, right?
go to post José Pereira · Aug 28 Maybe this project can help you: https://openexchange.intersystems.com/package/JSON2Persistent
go to post José Pereira · Aug 27 "So in this case the AI tool is not yet a magical replacement for missing/lacking documentation :(" Indeed! It's not rare to me access the methods source code to get more information... may be IS could use GenAI to improve their doc :o) Anyway, I appreciate the message "This is beyond my current knowledge" instead of hallucination.
go to post José Pereira · Aug 21 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. :)
go to post José Pereira · Aug 21 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)?
go to post José Pereira · Aug 16 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: When SQL executions generate error, the UI just present the error description keeping all elements, instead of the weird behavior you noticed 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 ;) 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:
go to post José Pereira · Aug 3 Hi @Evgeny Shvarov Thank you for your feedback and for the nice screenshot (i'll use it in the project readme :))! Really appreciate it! I'll implement your suggestion; it'll improve user experience for sure, thanks!
go to post José Pereira · Feb 20 For those who reach this out, %FileCharacterStream class was deprecated in favor of %Stream.FileCharacter. Here is the updated snippet for convinence: Set tTempFile = ##class(%Stream.FileCharacter).%New() Set tTempFile.Filename = "/tmp/file.csv" $$$THROWONERROR(st, tTempFile.CopyFrom(csvfile)) $$$THROWONERROR(st, tTempFile.%Save())
go to post José Pereira · Feb 16 Hi Prashanth, I had a similar requirement once. The following is how I managed it: First, I setup a method in a CSP dispatch class, which respond to a REST endpoint, to invoke a Business Service in the current namespace working production: ClassMethod SomeRestEndpointCallback(body As %DynamicArray) As %DynamicObject { $$$TOE(st, ##class(Ens.Director).CreateBusinessService("BusinessServiceName", .service)) $$$ThrowOnError(service.ProcessInput(body, .output)) Return output } Then, I created a adapterless Business Service (https://docs.intersystems.com/irislatest/csp/docbook/DocBook.UI.Page.cls...) in order to don't pooling for data but just wait for an external trigger instead: Class some.package.AdapterlessBS Extends Ens.BusinessService { /// Configuration item(s) to which to send file stream messages Property TargetConfigNames As Ens.DataType.ConfigName(MAXLEN = 1000); Parameter SETTINGS = "TargetConfigNames:Basic:selector?multiSelect=1&context={Ens.ContextSearch/ProductionItems?targets=1&productionName=@productionId}"; Method OnProcessInput(request As %RegisteredObject, Output response As %RegisteredObject) As %Status { Set tSC = $$$OK Try { // Could be any message... adapter to your needs Set tMsg = ##class(Ens.StringResponse).%New() Set tMsg.StringValue = "some value" // Send the message to the targets Set targets = $LFS(..TargetConfigNames) For i=1:1:$LL(targets) { Set target = $LG(targets, i) // can be sync or async... it's up to you decide //Set tSC = ..SendRequestSync(target, tMsg) Set tSC = ..SendRequestAsync(target, tMsg) Quit:$$$ISERR(tSC) } } Catch (ex) { Set tSC = ex.AsStatus() } Quit tSC } Now, you can add this Business Service to a interoperability production and set the desired Business Process as its target. So, when your REST endpoint is accessed, it will call the BS and then the BP. HTH,José
go to post José Pereira · Feb 6 Hi Robert, Great article! May be you find this discussion about ObjectScript quality rules interesting.
go to post José Pereira · Feb 6 Hi, In addition to @Robert Barbiaux response, you can use IRIS Unit Test in the ObjectScript side.
go to post José Pereira · Feb 5 Hi David. Thank you for your interest int the project. I didn't try it in GitHub Codespaces, but I just test it in my local Windows PC and it worked: As you can see, the command in README.md worked for me. I like to use this flags to get more information on possible issues. But, I changed such a commnad to just docker-compose up -d, once this command automatically builds the image if it does not exists. Thank you for your feedback, really appreciate it!
go to post José Pereira · Feb 3 Hi @Evgeny Shvarov / @Semion Makarov ! I just added an IRIS Interoperability Production show how to use the code generated by IRIS-FHIRfy to convert a simple CSV into FHIR and persist it to IRIS for Health. Evidences could be found here, here or here. Could you add the points for Digital Health Interoperability bonus to IRIS-FHIRfy, please? Thank you!
go to post José Pereira · Jul 10, 2023 Hi, I think you missed some links references: Btw, great article! :)
go to post José Pereira · Jul 9, 2023 Hi @Semion Makarov I added a BI dashboard to do analytics on the app logs of iris-fhir-generative-ai to the release 1.0.9, and a second article explaining about such analytics. So, I'd like to ask for IRIS BI and Second article bonuses. PS: Sorry for publish this so late, but I had this idea just Sunday late. 😄 Thanks!
go to post José Pereira · Jul 5, 2023 Thanks @Tani Frankel! I've the privilege to attend that session, very inspiring!