Hi,

I wonder why IRIS seems to have its on way to deal with order or operations such as the example in the title. This affects regular arithmetic operations but of course conditions in various statements.

Even after years of COS development, I still get caught by these tiny frustrating details and it is absolutely annoying when you are writing APIs that some some maths.

Here is an example:

Hi

I have two tables: one a local table using cache and the other is via an SQL gateway connection to an MSSQL Server via a 64bit ODBC driver (ODBC Driver 17 for SQL Server).

When I try to join them on a date field I don't get any matches, and I know that there are matches, e.g. running both views separately returns resuls for 30/11/2022.

The following statement returns rows for the first table r, but nothing for the table l

I got an error that occurs inside %CSP.Broker. That class is located inside %SYS namespace.

I tried lot of things (including checking system logs) but ultimately what would really help would be to be able to modify that class to add my own logs into it.

If I try to modify it, I got this error message:

Item '%CSP.Broker' is mapped from a database that you do no have write permissions on.

Hi all,

I'm fairly new to this engine so I was wondering what the best approach for creating a dynamic mapper to downgrade from one HL7 version to another (e.g 2.4 to 2.3) with the DTL Editor, It seems like something that would be quite commonly needed but I haven't found a method that works yet,

Hi everybody!

I'm new to a Caché world and need some help! Where I work we are running Cache 2016.1 version in a server, and 2018.1 in another server. I want to upgrade the version 2016.1 to 2018.1, but I fear it can raise some errors tha I cant resolve yet. My doubt is, if I upgrade it will run ok?

Thanks in advance!

As the title says I want to be able to hide code I deploy to TIe.

Morning everyone,

I would appreciate some advice please- hopefully there is plenty of experts out there.

We are setting up an sFTP share between hospital trusts here in the UK and I have set the outbound operation up using a custom extension of EnsLib.HL7.Operation.FTPOperation.

We are configuring a VPN tunnel to run between the sites also so there is a bit of firewall / network routing to take place to enable the connection but to add in a complication we are on a mirrored cluster and usually present on a Virtual IP address.

Hi guys,

Open question for all of you...

We are getting some warnings in our code of a class definition when switching namespaces in the code, because the classes we use in different namespace wouldn't exist in each other's... an example:

ClassMethod DoSomething() {
     set oldNS=$zutil(5)
     znspace "SECONDNS"
     set ok=##class(MyPackage.MyClass).MyMethod()
     znspace oldNS
}

In that example, the vscode "Intersystems Language Server" extension would tag "MyPackage.MyClass" as a problem because that class only exists in the second namespace.

Hi,

I

want to get the values from a serial property because my code depends upon the class serial class.

For example

Serial class

Class Data.Serial Extends %SerialObject

{

Property FirstName as %String;

Property LastName as %String;

}

Persistent class

I am sending an HL7 message from a BPL transform operation to a business operation that uses EnsLib.HL7.Operation.FileOperation.

Hi Friends ,

Here I need fetch the OrgCode value from party tag whose AgentId=1

<Msg>

<Parties>

<Party AgentId=0>

<OrgCode>abcd</OrgCode>

</Party>

<Party AgentId=1>

Hello,

I'm currently struggeling with a HTTP request to a URL, which contains an jpeg image file.

Testing the request with a browser or Postman results in the image being shown normally.

Using a %Net.HttpRequest with different configurations has resulted in a corrupted file.

My code works for some URLs from other servers perfectly fine, but with some it produces corrupted file contents which do not represent a jpeg.

Hello,

searching messages in our Message Bank is quite slow, often runs into timeout.

I wanted to perform a tune table on Ens_Enterprise_MsgBank.MessageHeader because this apparently has not been done yet - the Tune Table utility shows no entries for selectivity, etc.

I tried

w $SYSTEM.SQL.Stats.Table.GatherTableStats("""Ens_Enterprise_MsgBank"".MessageHeader")

and got this error message

Hi,

when I using ObjectScript Trigger Code , I want to get whether the fields has changed by using "{fieldName*C}" , actually, fieldName in "{fieldName*C}" is a real field name ,but in my code, fieldName is a variable as follows: