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 t

As part of a BPL I am building I need to foreach over a some repeating elements and look for a certain value, if said value is present I need to forward the message to another operation. I can't

Hello everyone,I try excuting a SQL Query like this SELECT ID, CompanyName FROM Company WHERE CompanyName LIKE 'condition' But if I want to search CompanyName have special char %, ex: '

Security requirements around certificates are getting stricter, and revocation lists are a must-have. In this video, we will outline our support for Online Certificate Status Protocol (OCSP), discuss why it is important, and demonstrate how to use it.

Takeaway:…

I am trying to explore some new possibilities outside of the normal day to day HL7 interfacing we do. I have only done 1 other Web Service interface but it was using a SOAP proxy wizard. Now I am task

At the George James Software booth at Global Summit last year we took the wraps off the work we've been doing to make our popular editing and debugging tool Serenji available on the Visual Studio Code

Hi,When we define a %String property, and don't mention any MAXLEN, by default it uses 50 as defined in class %Library.String.As a result, when we try to save data more than 50 characters, it fai

I have an application which is distributed across maybe 5 servers since it has over a thousand users at a time we had an upgrade to the application last week and I had an integration build that uses t

In this video, we will share our experiences with implementing change control and talk about the tools and processes we use. We will discuss best practices a...

Added new System Default Setting  for Production (not Host) setting.However, Production setting is still the same. I have tried restarting Production and instance, to no avail.How do I specify Sy

Hi guys,Mostly the title.  Let's say my commands are stored in a text file "inFile".  Here was my best guess: console IRIS2018 <inFileFor reference, here's an example o

This is a quick note on what happens when, on your CSP page, you call a cache script which returns a %Boolean and store that value in a javascript variable.When you call a script with language="cache

Hi guys,I'm running a method on an instance of Cache 2010, which, when compiled, has $$$OK in it's .int code.  This line throws an error, telling me that "the OK macro isn't recognized". Som

InterSystems is currently verifying InterSystems IRIS 2019.1 with Windows Server 2019. This work is scheduled to complete by the end of January  2019. In the second half of this month InterSystem