We love hearing from our users. Tell us what you want to see next and upvote ideas from the community. * Bugs and troubleshooting should as usual go through InterSystems support.
Conversion of Python Datatype to IRIS native values
We can easily create Python native data types from IRIS for example, by using ##class(%SYS.Python).Builtins().dict() or convert IRIS native complex datatypes to python datatypes ex: listbuild to python list ##class(%SYS.Python).ToList(). However, ...
Adding an index on EncounterNumber in HSAA.Encounter will significantly enhance query performance by reducing full table scans, optimizing joins, and accelerating data retrieval for reporting and analytics. Many reports and queries rely on filteri...
a simulation of host variables is actually only Available with Embedded SQL only.you know the famous (and horrible to me) :varnam syntax.I propose to take some workaround to allow similar functionality as in other SQL dialects.For good reasons the...
Flyway is an opensource db migration tool. Here is the related discussion: https://community.intersystems.com/post/flyway-support-intersystems-iris It'd be great to have IRIS support. There is an attempt dated 3 years ago: https://github.com/flywa...
Evgeny Shvarov
4 months ago
in InterSystems IRIS
0
Community Opportunity
Create a vscode extension to use the Intersystems IRIS Load Data utilities into VSCode.
Users can select a file from VSCode and click export, VSCode allows to the user select the persistent class, the fields, encoding and other options allowed an...
We utilise the Export feature to export classes from a production ready for a deployment. We already have a list of classes to deploy from our source control history. It would be handy if we could list out the classes/production items/ LUTs etc., ...
Supabase.com is a backend as a service platform. By default, it provides Postgres as a backend, but there is a wrapper mechanism that allows to add different data vendors. https://supabase.com/blog/postgres-foreign-data-wrappers-with-wasm https://...
Evgeny Shvarov
4 months ago
in InterSystems IRIS
0
Community Opportunity
Option for Assign append to escape automatically in DTL editor
Sometimes it seems in DTLs the asign operators are poor at escaping hl7. i.e. one comment we had was < comment > <![CDATA[ * T & B subsets reflexed due to abnormal proportions of ]]> </ comment > calling assign like the below...
Create a built-in native JSON datatype like "%Library.String" and implement the SQL JSON_ functions natively. Store, retrieve, search, validate by schema and update the before save and save JSON values instead of store into %String - we can't stor...