Date range queries going too slow for you? SQL Performance got you down? I have one weird trick that might just help you out! (SQL Developers hate this!)*
If you have a class that records timestamps when the data is added, then that data will be in sequence with your IDKEY values - that is, TimeStamp1 < TimeStamp2 if and only if ID1 < ID2 for all IDs and TimeStamp values in table - then you can use this knowledge to increase performance for queries against TimeStamp ranges. Consider the following table:
Is there a way to read JSON and transform it (in DTL) by using a VDOC of this JSON (without transform it to internal message) like I can do with HL7 or XML?
If it possible, I guess that I should have a schema of the JSON so the second question is how to build a schema for JSON and load it to the IRIS?
Has anybody tried to write custom code to empty out queues when Interoperability shuts down? We run IRIS in Kubernetes cluster and we have compute pods scaling up and down. We have Message Bank operation to keep all messages in one place. We want to see all messages in Message Bank.
Watch this video to learn about InterSystems FHIR Server, the turnkey FHIR data solution that empowers FHIR application developers to focus on building life-changing healthcare applications:
https://www.youtube.com/embed/YyZc8dK9_jM [This is an embedded link, but you cannot view embedded content directly on the site because you have declined the cookies necessary to access it. To view embedded content, you would need to accept all cookies in your Cookies Settings]
In which folder under the "C:>InterSystems>IRISHealth" are the Mumps/cache routine stored? These are the routines created via the Studio module of the IRISHealth application.
I am currently trying to better my development process by using Visual Studio Code because I'm more familiar and comfortable with it than Studio.
I've followed the guide here, but I'm still having issues. I initially didn't have the Web Socket protocol allowed on my Web Gateway server, but I enabled that and restarted the server with no luck.
Hey Developers, Don't miss the 2022 Annual Open Exchange App Digest. Let's meet the most popular applications and their developers.
General Stats:
✓ 166 new applications in 2022 ✓ 6,874 downloads in 2022 ✓ 508 developers joined in 2022 ✓ 710 applications all time ✓ 22,497 downloads all time ✓ 1,964 developers joined all time
I have a test version of Cache installed on my laptop, but I cannot get logged into the database. I think my ID may be locked due to too many password failure attempts. I have not changed the Admin password or SuperUser password. Does anyone know what the default password would be for the Admin and/or SuperUser Id's? Or if someone knows how I can get in and unlock/reset my password, it would be much appreciated??
We have a scenario where an ObjectScript-based production calls a lookup service (SOAP in C#) to get information used in a value-set mapping process. The results can be cached in an IRISTEMP global to prevent a network call for every value, but that can hang around for quite some time on production systems.
The next logical step would seem to be to encapsulate strategies (LRU, MRU, etc.) and eviction code into an ObjectScript class that can be reused (we are not in a position yet to leverage embedded Python).
I've disabled TLS v1.0 and 1.1 within Healthshare setting, but still seeing these error messages when running a security scan. We do have apache being used. What else can I try?
Hey Community, Please check out the 2022 Annual Dev Community Article Digest with the most popular and commented articles. Thank you all for your contributions to the InterSystems Community in 2022!
General Stats
✓1676 posts published in 2022: – 277 articles – 481 announcements – 870 questions – 48 discussions ✓2,338 members joined the Developer Community in 2022 ✓10,640 posts published all time ✓12,061 members joined all time
I have a registered object class that extends %XML.Adaptor and I want to convert an object of it into canonical XML.
From reading the documentation and some trial and error, it seems like I would need to use %XML.Writer to write the object to XML first using the RootObject() method, then read it with %XML.Reader, and then use the Canonicalize() method of %XML.Writer to write it out again.
I finally got some time to organize a set of classes that I've been using for a few years to make it easier and kill the repetitive work of developing intragrations using XDBC.
https://www.youtube.com/embed/wJXvfeQoZxQ [This is an embedded link, but you cannot view embedded content directly on the site because you have declined the cookies necessary to access it. To view embedded content, you would need to accept all cookies in your Cookies Settings]
Because I had no idea how to build an integration solution for HL7 and didn't know where to start, I decided to follow the course Building Basic HL7 Integrations with InterSystems on Learning portal to get at least the idea of where to begin. After I studied all of it, I decided it might be a good idea to share my thoughts and reflections about it with everyone.
Hello, good afternoon! (or good morning or good evening)
I was doing some very basic tests, based on the documentation, using Python in Studio. I decided to call a python method through the Studio's own terminal as a demonstration, but the result was different from the terminal result:
Yesterday I downloaded and attempted to install the newest version of the Community Edition of IRIS but not the preview, and attempted to update an older version, but each time I tried to install it, I would get an error, and then an antivirus program would indicate that it had identified and blocked a threat (McAfee identified it as GenericRXAA-FA!EAEEF9B8457F with a location of C:\Users\jivey\AppData\Local\Temp\pbt3FDD840C\IRIS_x64.msi). I tried the installation again this morning and this time a threat was identified by Malwarebytes as Malware.AI.4072586503 and McAfee identified it as i
It was an amazing 2022 with all of you. Great questions and articles around the whole year and this brings us the most valuable gifts -- wisdom and knowledge. I want to thank you all for a great year full of fun and pleasure.
By update
Open Exchange app
1,132